List of Examples

• 2-1 LIST FAILURE and ADVISE FAILURE
• 2-2 REPAIR FAILURE
• 4-1 Checking RMAN Syntax Interactively
• 4-2 Checking the Syntax of a Command File with Bad Syntax
• 4-3 Connecting to the Target Database from the System Prompt
• 4-4 Connecting to the Target Database from the System Prompt
• 4-5 Connecting to the Target and Catalog Databases from the System Prompt
• 4-6 Connecting to the Target Database from the RMAN Prompt
• 4-7 Connecting to the Target and Catalog Databases from the RMAN Prompt
• 4-8 Connecting from the RMAN Prompt with Oracle Net Authentication
• 4-9 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
• 5-8 Specifying the Device Type on the BACKUP Command
• 6-1 Configuring Channel Parallelism for Tape Devices
• 6-2 Configuring the Backup Compression Algorithm
• 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 Flash Recovery Area Space Consumption
• 14-1 Sample Repair Script
• 15-1 Validating a Large Datafile
• 16-1 Dropping Multiple Objects with the Same Name
• 16-2 Renaming Dropped Tables
• 17-1 BACKUP VALIDATE DATABASE
• 17-2 RESTORE ... PREVIEW Output
• 18-1 Recovering Blocks by Using All Available Backups
• 18-2 Recovering Blocks from a Backup with a Specific Tag
• 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 Control File Recovery Script
• 19-4 Restoring a Database on a New Host
• 20-1 Querying TS_PITR_CHECK for a Subset of Tablespaces
• 20-2 Querying TS_PITR_CHECK for All Tablespaces
• 20-3 Output for Query of TS_PITR_CHECK
• 20-4 Querying TS_PITR_OBJECTS_TO_BE_DROPPED
• 20-5 Performing TSPITR on Two Tablespaces
• 20-6 Renaming Recovery Set Files
• 20-7 Renaming Auxiliary Set Files
• 20-8 Using CONFIGURE AUXNAME
• 22-1 RMAN Syntax Error
• 23-1 Using the SPFILE Clause to Name Duplicate Files
• 23-2 Sample Initialization Parameter File for the Auxiliary Instance
• 23-3 Duplicating to a Host with the Same Directory Structure
• 23-4 Duplicating a Database to a Past Point in Time
• 23-5 Duplicating to a Host with a Different Directory Structure
• 23-6 Duplicating from a File System to ASM
• 23-7 Duplicating from ASM to ASM
• 23-8 Excluding Read-Only Tablespaces
• 23-9 Excluding Specified Tablespaces
• 23-10 Including Specified Tablespaces
• 23-11 Creating a Temporary Archival Backup
• 23-12 Duplicating with SET NEWNAME
• 23-13 Using SET NEWNAME to Create Files in an ASM Disk Group
• 23-14 Using CONFIGURE AUXNAME to Generate Database Filenames
• 23-15 Reduplicating the Database
• 24-1 Specifying an Auxiliary Instance Parameter File
• 24-2 Creating a Transportable Tablespace Set
• 24-3 Specifying an End SCN
• 24-4 Specifying an End Restore Point
• 24-5 Specifying an End Time
• 24-6 Specifying Output File Locations
• 24-7 Using SET NEWNAME to Name Auxiliary Datafiles
• 25-1 Executing DBMS_TDB.CHECK_DB
• 25-2 Executing DBMS_TDB.CHECK_EXTERNAL
• 25-3 Converting a Database on the Source Host
• 25-4 Executing CONVERT DATABASE ON DESTINATION PLATFORM
• 26-1 Migrating the Online Redo Logs