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