List of Examples

• 1-1 Using Reserved Words as Arguments to RMAN Commands
• 2-1 Running a Command File from the Operating System Command Line
• 2-2 Running a Command File Within RMAN
• 2-3 Specifying Substitution Variables
• 2-4 Calling a Command File Within Another Command File
• 2-5 Displaying Repair Options for All Failures
• 2-6 Manually Allocating a Channel for a Backup
• 2-7 Distributing a Backup Across Multiple Disks
• 2-8 Creating Multiple Copies of a Backup on Tape
• 2-9 Allocating an Auxiliary Channel for Database Duplication
• 2-10 Deleting Backup Sets
• 2-11 Cross-Checking Backups on Multiple Devices
• 2-12 Cross-Checking in an Oracle Real Application Clusters (Oracle RAC) Configuration
• 2-13 Backing Up a Database
• 2-14 Backing Up Multiple PDBs
• 2-15 Performing a Cumulative Incremental Backup
• 2-16 Distributing a Backup Across Multiple Disks
• 2-17 Identifying Data File Copies by Tag
• 2-18 Backing Up and Deleting Archived Redo Log Files
• 2-19 Scripting Incrementally Updated Backups
• 2-20 Backing Up Disk-Based Backup Sets to Tape
• 2-21 Duplexing a Database Backup
• 2-22 Specifying How Channels Divide Workload
• 2-23 Creating an Incremental Backup for Refresh of a Standby Database
• 2-24 Specifying Corruption Tolerance for Data File Backups
• 2-25 Creating a Consistent Database Backup for Archival Purposes
• 2-26 Exempting Copies from the Retention Policy
• 2-27 Backing Up Files That Need Backups
• 2-28 Using NODUPLICATES To Back Up Data File Copies
• 2-29 Copying Archived Log From Operating System File to ASM
• 2-30 Multisection Backup of Data Files as Image Copies
• 2-31 Multisection Incremental Backup of Database as Backup Sets
• 2-32 Multisection Incremental Backup of Tablespaces
• 2-33 Cross-Platform Backup of the Entire Database
• 2-34 Cross-Platform Backup of a Consistent Tablespace
• 2-35 Cross-Platform Backup of a Tablespace Using Multiple Backup Sets
• 2-36 Cross-Platform Backup of a Tablespace Using Multiple Backup Pieces
• 2-37 Cross-Platform Inconsistent Backup of a Tablespace
• 2-38 Cross-Platform Incremental Backup of a Tablespace
• 2-39 Cataloging a Data File Copy as an Incremental Backup
• 2-40 Cataloging Multiple Copies in a Directory
• 2-41 Cataloging Files in the Fast Recovery Area
• 2-42 Cataloging a Backup Piece
• 2-43 Updating Backups to Status UNAVAILABLE
• 2-44 Uncataloging and Recataloging Archived Redo Log Files
• 2-45 Changing a Database Backup into an Archival Backup
• 2-46 Changing the Status of a Failure
• 2-47 Associating Backups with a New Database in a Data Guard Environment
• 2-48 Updating a DB_UNIQUE_NAME in the Recovery Catalog
• 2-49 Configuring Device and Backup Options
• 2-50 Overriding the Default Device Type
• 2-51 Configuring Automatic Channels Across File Systems
• 2-52 Configuring Automatic Channels in an Oracle Real Application Clusters (Oracle RAC) Configuration
• 2-53 Configuring Auxiliary File Names
• 2-54 Specifying the Default Format for Control File Autobackup
• 2-55 Creating Configurations for Standby Databases
• 2-56 Optimizing Backups
• 2-57 Configuring a Default Compression Algorithm
• 2-58 Connecting to a Target Database Without a Recovery Catalog
• 2-59 Connecting to a Target Database in the Default NOCATALOG Mode
• 2-60 Connecting to Target, Recovery Catalog, and Auxiliary Databases
• 2-61 Connecting to the Root Using Operating System Authentication
• 2-62 Connecting to a PDB as a Local User
• 2-63 Converting Tablespaces on the Source Platform
• 2-64 Converting Data Files on the Destination Platform
• 2-65 Copying Data Files to and from ASM with CONVERT DATAFILE
• 2-66 Transporting a Database to a Different Platform
• 2-67 Transporting a Database to a Different Platform and Storage Type
• 2-68 Creating a Recovery Catalog and Registering a Database
• 2-69 Creating a Virtual Private Catalog
• 2-70 Creating a Local Stored Script
• 2-71 Creating a Global Stored Script
• 2-72 Creating a Stored Script That Uses Substitution Variables
• 2-73 Cross-Checking All Backups and Copies
• 2-74 Cross-Checking Within a Range of Dates
• 2-75 Deleting Expired Backups
• 2-76 Deleting Obsolete Backups
• 2-77 Deleting Archived Redo Log Files That Are Backed Up
• 2-78 Forcing the Deletion of a Backup Set
• 2-79 Deleting a Global Script
• 2-80 Dropping a Virtual Private Catalog
• 2-81 Deleting a Database
• 2-82 Duplicating from an Active Database to a Host with the Same Directory Structure
• 2-83 Copying the Server Parameter File in Active Database Duplication
• 2-84 Duplicating a Database Without a Target Connection to a Host with the Same Directory Structure
• 2-85 Setting New File Names in the DUPLICATE Command
• 2-86 Using SET NEWNAME FOR DATABASE to Name Duplicate Files
• 2-87 Using SET NEWNAME FOR DATAFILE and SET NEWNAME FOR TABLESPACE to Name Duplicate Files
• 2-88 Using SET NEWNAME FOR DATAFILE to Name Oracle-Managed Files
• 2-89 Using CONFIGURE AUXNAME to Name Duplicate Files
• 2-90 Creating a Standby Database with the Same Directory Structure
• 2-91 Creating a Standby Database in OMF and ASM
• 2-92 Duplicating a Database Without Connection to Target Database and Recovery Catalog
• 2-93 Selecting a Specific Database When Duplicating Without Connection to Target Database and Recovery Catalog
• 2-94 Duplicating PDBs and Specific Tablespaces in a PDB
• 2-95 Executing a Stored Script
• 2-96 Creating and Executing a Stored Script That Uses Substitution Variables
• 2-97 Exiting RMAN
• 2-98 FLASHBACK DATABASE to a Specific SCN
• 2-99 FLASHBACK DATABASE to a Restore Point
• 2-100 Granting Privileges for a Virtual Private Catalog
• 2-101 Hosting to the Operating System Within a Backup
• 2-102 Executing an Operating System Copy Within RMAN
• 2-103 Importing Metadata for All Registered Databases
• 2-104 Importing Metadata for a Subset of Registered Databases
• 2-105 Listing Backups
• 2-106 Listing a Summary of Backups
• 2-107 Listing Backups by File
• 2-108 Listing Image Copies
• 2-109 Listing Database Incarnations
• 2-110 Listing Failures
• 2-111 Printing a Script to a File
• 2-112 Printing a Script to the Screen
• 2-113 Quitting RMAN
• 3-1 Recovering a Tablespace in an Open Database
• 3-2 Recovering Data Files Restored to New Locations
• 3-3 Performing DBPITR with a Backup Control File and Recovery Catalog
• 3-4 Incrementally Updating Backups
• 3-5 Recovery from Loss of a Control File on a Standby Database
• 3-6 Recovering a NOARCHIVELOG Database
• 3-7 Recovering All Block Corruption in the Database
• 3-8 Recovering Tables Partitions from a Backup
• 3-9 Recovering Tables to a Specified Log Sequence and Renaming the Tables
• 3-10 Recovering Tables to a Specified Time and Into a Different Tablespace
• 3-11 Registering a Database
• 3-12 Releasing a Channel Allocated in a RUN Command
• 3-13 Releasing a Maintenance Channel
• 3-14 Repairing Failures
• 3-15 Previewing a Repair
• 3-16 Replacing a Recovery Catalog Script
• 3-17 Reporting a Database Schema
• 3-18 Reporting Data Files Needing Incremental Backups
• 3-19 Reporting Obsolete Backups and Copies
• 3-20 Resetting RMAN to a Previous Incarnation in NOCATALOG Mode
• 3-21 Restoring a Tablespace
• 3-22 Setting a New Name for a Restored Data File
• 3-23 Restoring the Control File When Using a Recovery Catalog
• 3-24 Recovering the Database with a Control File Autobackup
• 3-25 Restoring a Control File Autobackup to a Nondefault Location
• 3-26 Restoring a Server Parameter File Autobackup to the Current Location
• 3-27 Previewing Backups
• 3-28 Recalling Offsite Backups from Offsite Storage
• 3-29 Validating the Restore of a Backup
• 3-30 Restoring Data Files on the Primary Database Using the Standby
• 3-31 Restoring a Database from a Cross-Platform Database Backup
• 3-32 Restoring a Tablespace from a Cross-Platform Tablespace Backup
• 3-33 Restoring a Tablespace Using a Cross-Platform Backup Consisting of Multiple Backup Sets
• 3-34 Restoring a Tablespace Using a Cross-Platform Consistent Backup that Contains Multiple Backup Pieces
• 3-35 Restoring a Cross-Platform Inconsistent Tablespace Backup
• 3-36 Resynchronizing the Recovery Catalog in ARCHIVELOG Mode
• 3-37 Resynchronizing the Recovery Catalog from a Control File Copy
• 3-38 Resynchronizing the Recovery Catalog After a Structural Change
• 3-39 Resynchronizing the Recovery Catalog with a Standby Database
• 3-40 Revoking Privileges from a Virtual Private Catalog Users
• 3-41 Connecting RMAN to a Target Database in Default NOCATALOG Mode
• 3-42 Connecting RMAN to an Auxiliary Database Instance
• 3-43 Specifying Substitution Variables
• 3-44 Checking the Syntax of a Command File
• 3-45 Running a Stored Script and Appending Output to a Message Log
• 3-46 Invoking the RMAN Pipe Interface
• 3-47 Overriding Configured Settings
• 3-48 Executing an RMAN Script
• 3-49 Specifying a Tape Drive in Oracle Secure Backup
• 3-50 Setting the Command ID
• 3-51 Duplexing a Backup Set
• 3-52 Setting the Control File Autobackup Format During a Restore
• 3-53 Restoring the Server Parameter File
• 3-54 Setting NEWNAME and Duplicating Without a Connection to Target Database
• 3-55 Setting a Compression Level for a Backup
• 3-56 Showing All Configurations for a Target Database
• 3-57 Shutting Down a Database with the Immediate Option
• 3-58 Shutting Down a Database in NOARCHIVELOG Mode
• 3-59 Spooling RMAN Output to a File
• 3-60 Adding a Data File
• 3-61 Querying a Table
• 3-62 Creating a Directory
• 3-63 Archiving the Unarchived Online Logs
• 3-64 Specifying a File Name Within a Quoted String
• 3-65 Mounting the Database While Specifying the Parameter File
• 3-66 Starting an Instance Without a Parameter File
• 3-67 Switching to Image Copies to Avoid Restoring from Backup
• 3-68 Switching Data File Names After a Restore to a New Location
• 3-69 Renaming Tempfiles Using SET NEWNAME and SWITCH TEMPFILE ALL
• 3-70 Switching to a Data File Copy
• 3-71 Using TRANSPORT TABLESPACE with a Past Time
• 3-72 Using TRANSPORT TABLESPACE with Customized File Locations
• 3-73 Unregistering a Primary Database and Its Standby Databases
• 3-74 Unregistering a Database That is Not Unique in Catalog
• 3-75 Unregistering a Standby Database
• 3-76 Upgrading a Recovery Catalog
• 3-77 Validating a Backup Set
• 3-78 Validating the Database
• 4-1 Specifying the Default Location for Disk Backups
• 4-2 Setting the Maximum Size of a Backup Piece
• 4-3 Setting SBT Channel Parameters
• 4-4 Specifying Records by Recovery Point-in-Time
• 4-5 Listing Archived Log Backups by Time
• 4-6 Crosschecking All Logs in a Redo Thread
• 4-7 Crosschecking Backups Within a Time Range
• 4-8 Deleting Expired Backups
• 4-9 Listing Copies
• 4-10 Connecting to a Target Database Without a Recovery Catalog
• 4-11 Connecting to a Target Database at the Operating System Command Line
• 4-12 Connecting to a Target Database with Operating System Authentication
• 4-13 Specifying a Data File by File Name
• 4-14 Specifying a Data File by Absolute File Number
• 4-15 Allocating a Tape Channel
• 4-16 Backing Up the Database to Disk
• 4-17 Using DB_FILE_NAME_CONVERT with a Single Conversion Pair
• 4-18 Using DB_FILE_NAME_CONVERT with Multiple Conversion Pairs
• 4-19 Listing Expired Backups Associated with a Standby Database
• 4-20 Restoring all Data files from a Cross-Platform Backup
• 4-21 Crosschecking Foreign Archived Redo Log Files
• 4-22 Specifying an ASM Disk Group
• 4-23 Specifying a Format for Data File Copies
• 4-24 Creating a Consistent Database Backup for Archival
• 4-25 Removing the KEEP Attributes for a Backup
• 4-26 Listing Data File Copies
• 4-27 Listing Data Files for a PDB
• 4-28 Crosschecking Archived Redo Log Files
• 4-29 Deleting Expired Backups
• 4-30 Listing Backups in a Specific Location
• 4-31 Deleting Archived Logs That Are Backed Up
• 4-32 Crosschecking Backups
• 4-33 Deleting Obsolete Backups
• 4-34 Crosschecking Backups
• 4-35 Deleting Data File Copies
• 4-36 Setting the Maximum Size of a Backup Piece
• 4-37 Specifying a Temp File by File Name
• 4-38 Specifying an ASM Disk Group
• 4-39 Specifying a Destination for Data File Copies
• 4-40 Specifying a Destination for Recovery Area files
• 4-41 Performing Incomplete Recovery to a Specified SCN
• 4-42 Reporting Obsolete Backups
• D-1 Running the S3 Backup Installer