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 Logs
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 Flash Recovery Area
2-33 Cataloging a Backup Piece
2-34 Updating Backups to Status UNAVAILABLE
2-35 Uncataloging and Recataloging Archived Redo Logs
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 Connecting Without a Recovery Catalog
2-49 Connecting in the Default NOCATALOG Mode
2-50 Connecting to Target, Recovery Catalog, and Auxiliary Databases
2-51 Converting Tablespaces on the Source Platform
2-52 Converting Datafiles on the Destination Platform
2-53 Copying Datafiles to and from ASM with CONVERT DATAFILE
2-54 Transporting a Database to a Different Platform
2-55 Transporting a Database to a Different Platform and Storage Type
2-56 Creating a Recovery Catalog and Registering Databases
2-57 Creating a Virtual Private Catalog
2-58 Creating a Local Stored Script
2-59 Creating a Global Stored Script
2-60 Creating a Stored Script That Uses Substitution Variables
2-61 Crosschecking All Backups and Copies
2-62 Crosschecking Within a Range of Dates
2-63 Deleting Expired Backups
2-64 Deleting Obsolete Backups
2-65 Deleting Archived Redo Logs That Have Already Been Backed Up
2-66 Forcing the Deletion of a Backup Set
2-67 Deleting a Global Script
2-68 Dropping a Virtual Private Catalog
2-69 Deleting a Database
2-70 Duplicating from an Active Database
2-71 Copying the Server Parameter File in Active Database Duplication
2-72 Setting New Filenames Manually for Duplication
2-73 Using the Source Database Filenames for the Duplicate Database
2-74 Creating a Standby Database with the Same Directory Structure
2-75 Creating a Standby Database in OMF and ASM
2-76 Executing a Stored Script
2-77 Creating and Executing a Stored Script That Uses Substitution Variables
2-78 Exiting RMAN
2-79 FLASHBACK DATABASE to a Specific SCN
2-80 FLASHBACK DATABASE to a Restore Point
2-81 Granting Privileges for a Virtual Private Catalog
2-82 Hosting to the Operating System Within a Backup
2-83 Executing an Operating System Copy Within RMAN
2-84 Importing Metadata for All Registered Databases
2-85 Importing Metadata for a Subset of Registered Databases
2-86 Listing Backups
2-87 Listing a Summary of Backups
2-88 Listing Backups by File
2-89 Listing Image Copies
2-90 Listing Database Incarnations
2-91 Listing Failures
2-92 Printing a Script to a File
2-93 Printing a Script to the Screen
2-94 Quitting RMAN
2-95 Recovering a Tablespace in an Open Database
2-96 Recovering Datafiles Restored to New Locations
2-97 Performing DBPITR with a Backup Control File and Recovery Catalog
2-98 Incrementally Updating Backups
2-99 Recovery from Loss of a Control File on a Standby Database
2-100 Recovering a NOARCHIVELOG Database
2-101 Recovering All Block Corruption in the Database
2-102 Registering a Database
2-103 Releasing a Channel Allocated in a RUN Command
2-104 Releasing a Maintenance Channel
2-105 Repairing Failures
2-106 Previewing a Repair
2-107 Replacing a Recovery Catalog Script
2-108 Reporting a Database Schema
2-109 Reporting Datafiles Needing Incremental Backups
2-110 Reporting Obsolete Backups and Copies
2-111 Resetting RMAN to a Previous Incarnation in NOCATALOG Mode
2-112 Restoring a Tablespace
2-113 Setting a New Name for a Restored Datafile
2-114 Restoring the Control File When Using a Recovery Catalog
2-115 Recovering the Database with a Control File Autobackup
2-116 Restoring a Control File Autobackup to a Nondefault Location
2-117 Restoring a Server Parameter File Autobackup to the Current Location
2-118 Previewing Backups
2-119 Recalling Offsite Backups from Offsite Storage
2-120 Validating the Restore of a Backup
2-121 Resynchronizing the Recovery Catalog in ARCHIVELOG Mode
2-122 Resynchronizing the Recovery Catalog from a Control File Copy
2-123 Resynchronizing the Recovery Catalog After a Structural Change
2-124 Resynchronizing the Recovery Catalog with a Standby Database
2-125 Revoking Privileges from a Virtual Private Catalog Users
2-126 Connecting in Default NOCATALOG Mode
2-127 Connecting to an Auxiliary Instance
2-128 Specifying Substitution Variables
2-129 Checking the Syntax of a Command File
2-130 Running a Stored Script and Appending Output to a Message Log
2-131 Invoking the RMAN Pipe Interface
2-132 Overriding Configured Settings
2-133 Executing an RMAN Script
2-134 Specifying a Tape Drive in Oracle Secure Backup
2-135 Setting the Command ID
2-136 Duplexing a Backup Set
2-137 Setting the Control File Autobackup Format During a Restore
2-138 Restoring the Server Parameter File
2-139 Showing All Configurations for the Target Database
2-140 Shutting Down a Database with the Immediate Option
2-141 Shutting Down a Database in NOARCHIVELOG Mode
2-142 Spooling RMAN Output to a File
2-143 Archiving the Unarchived Online Logs
2-144 Specifying a Filename within a Quoted String
2-145 Mounting the Database While Specifying the Parameter File
2-146 Starting an Instance Without a Parameter File
2-147 Switching to Image Copies to Avoid Restoring from Backup
2-148 Switching Datafile Filenames After a Restore to a New Location
2-149 Renaming Tempfiles Using SET NEWNAME and SWITCH TEMPFILE ALL
2-150 Switching to a Datafile Copy
2-151 Using TRANSPORT TABLESPACE with a Past Time
2-152 Using TRANSPORT TABLESPACE with Customized File Locations
2-153 Unregistering a Primary Database and Its Standby Databases
2-154 Unregistering a Database That is Not Unique in Catalog
2-155 Unregistering a Standby Database
2-156 Upgrading a Recovery Catalog
2-157 Validating a Backup Set
2-158 Validating the Database
3-1 Specifying the Default Location for Disk Backups
3-2 Setting the Maximum Size of a Backup Piece
3-3 Setting SBT Channel Parameters
3-4 Specifying Records by Recovery Point-in-Time
3-5 Listing Archived Log Backups by Time
3-6 Crosschecking All Logs in a Redo Thread
3-7 Crosschecking Backups Within a Time Range
3-8 Deleting Expired Backups
3-9 Listing Copies
3-10 Connecting to a Target Database Without a Recovery Catalog
3-11 Connecting to a Target Database and Entering the Password Interactively
3-12 Connecting with Operating System Authentication
3-13 Specifying a Datafile by Filename
3-14 Specifying a Datafile by Absolute File Number
3-15 Allocating a Tape Channel
3-16 Backing Up the Database to Disk
3-17 Using DB_FILE_NAME_CONVERT with a Single Conversion Pair
3-18 Using DB_FILE_NAME_CONVERT with Multiple Conversion Pairs
3-19 Listing Expired Backups Associated with a Standby Database
3-20 Crosschecking Foreign Archived Redo Logs
3-21 Specifying an ASM Disk Group
3-22 Specifying a Format for Datafile Copies
3-23 Creating a Consistent Database Backup for Archival
3-24 Removing the KEEP Attributes for a Backup
3-25 Listing Datafile Copies
3-26 Crosschecking Archived Redo Logs
3-27 Deleting Expired Backups
3-28 Listing Backups in a Specific Location
3-29 Deleting Archived Logs That Are Already Backed Up
3-30 Crosschecking Backups
3-31 Deleting Obsolete Backups
3-32 Crosschecking Backups
3-33 Deleting Datafile Copies
3-34 Specifying a Tempfile by Filename
3-35 Performing Incomplete Recovery to a Specified SCN
3-36 Reporting Obsolete Backups