List of Examples

• 2-1 LIST FAILURE and ADVISE FAILURE
• 2-2 REPAIR FAILURE
• 4-1 Checking the Syntax of a Command File with Bad Syntax
• 4-2 Connecting to a Target Database from the System Prompt
• 4-3 Connecting to a Target Database from the System Prompt
• 4-4 Connecting to Target and Catalog Databases from the System Prompt
• 4-5 Connecting to the Target and Catalog Databases from the RMAN Prompt
• 5-1 SHOW ALL Command
• 5-2 Configuring a Nondefault Backup Location
• 5-3 Configuring Parallelism for an SBT Device
• 5-4 Configuring the Backup Type for an SBT Device
• 5-5 PARMS Setting for Oracle Secure Backup
• 5-6 Backing Up the Server Parameter File to Tape
• 5-7 Restoring the Server Parameter File from Tape
• 6-1 Configuring Channel Parallelism for Tape Devices
• 6-2 Configuring Basic Compression for Backup
• 7-1 Specifying Filenames with DB_FILE_NAME_CONVERT
• 7-2 Backing Up Backup Sets to Tape
• 7-3 Managing Space Allocation
• 8-1 Specifying Device Type DISK
• 8-2 Making Image Copies
• 8-3 Making Backup Sets
• 8-4 Applying a Tag to a Backup Set
• 8-5 Applying Tags to Image Copies
• 8-6 Assigning Tags to Output Copies
• 8-7 Making Compressed Backups
• 8-8 Backing Up a Database in NOARCHIVELOG Mode
• 8-9 Basic Incremental Update Script
• 8-10 Advanced Incremental Update Script
• 8-11 Creating a Temporary Archival Backup
• 9-1 Configuring Backup Optimization
• 9-2 Backing Up Archived Redo Logs to Multiple Media Families
• 9-3 Skipping Files During an RMAN Backup
• 9-4 Using MINIMIZE TIME with BACKUP DURATION
• 9-5 Using MINIMIZE LOAD with BACKUP DURATION
• 11-1 Fast Recovery Area Space Consumption
• 14-1 Sample Repair Script
• 16-1 BACKUP VALIDATE DATABASE
• 16-2 RESTORE ... PREVIEW Output
• 17-1 Dropping Multiple Objects with the Same Name
• 17-2 Renaming Dropped Tables
• 19-1 Restoring the Server Parameter File from a Control File Autobackup
• 19-2 Setting the DBID and Restoring the Control File from Autobackup
• 19-3 Restoring a Database on a New Host
• 20-1 Querying DBMS_TTS.TRANSPORT_SET_CHECK for a Subset of Tablespaces
• 20-2 Querying TS_PITR_OBJECTS_TO_BE_DROPPED
• 20-3 Using SCN and TS_PITR_OBJECTS_TO_BE_DROPPED
• 20-4 Performing TSPITR on Two Tablespaces
• 20-5 Renaming Recovery Set Files
• 20-6 Redirecting ASM files
• 20-7 Renaming Auxiliary Set Oracle Managed Files (OMF) in TSPITR
• 20-8 Using SET NEWNAME
• 22-1 RMAN Syntax Error
• 23-1 Duplicating to a Host with the Same Directory Structure (Active)
• 23-2 Duplicating a Database to a Past Point in Time (Backup-Based)
• 23-3 Using an Archival Backup for Backup-Based Duplication
• 23-4 Duplicating a Database to a Past Point in Time (Backup-Based)
• 23-5 Duplicating a Database Without a Target and Recovery Catalog Connection - Backup-Based
• 23-6 Duplicating a Database to a Past Point in Time - Backup-Based
• 24-1 Duplicating with SET NEWNAME FOR DATAFILE
• 24-2 Duplicating with SET NEWNAME FOR DATAFILE and FOR TABLESPACE
• 24-3 Duplicating with SET NEWNAME FOR DATABASE
• 24-4 Duplicating from a File System to ASM (Active)
• 24-5 Duplicating from ASM to ASM (Active)
• 24-6 Duplicating with SET NEWNAME FOR DATAFILE and FOR TABLESPACE
• 24-7 Using SET NEWNAME to Create Files in an ASM Disk Group
• 24-8 Sample Initialization Parameter File for the Auxiliary Instance
• 24-9 Excluding Read-Only Tablespaces
• 24-10 Excluding Specified Tablespaces
• 24-11 Including Specified Tablespaces
• 24-12 Including Specified Tablespaces
• 25-1 Specifying an Auxiliary Instance Parameter File
• 25-2 Creating a Transportable Tablespace Set
• 25-3 Specifying an End SCN
• 25-4 Specifying an End Restore Point
• 25-5 Specifying an End Time
• 25-6 Specifying Output File Locations
• 25-7 Using SET NEWNAME FOR DATAFILE to Name Auxiliary Datafiles
• 26-1 Executing DBMS_TDB.CHECK_DB
• 26-2 Executing DBMS_TDB.CHECK_EXTERNAL
• 26-3 Converting a Database on the Source Host
• 26-4 Executing CONVERT DATABASE ON DESTINATION PLATFORM