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