List of Examples

• 2-1 LIST FAILURE and ADVISE FAILURE
• 4-1 OS Authentication with the SYSDBA Privilege - Explicit
• 4-2 OS Authentication with the SYSBACKUP Privilege - Explicit
• 4-3 OS Authentication with the SYSDBA Privilege - Implicit
• 4-4 Password File Authentication as SYSDBA - Explicit
• 4-5 Password File Authentication as SYSBACKUP - Explicit
• 4-6 Password File Authentication as SYSDBA - Implicit
• 4-7 Connecting With OS Authentication - Implicit
• 4-8 Connecting with OS Authentication - Explicit
• 4-9 Connecting with Password File Authentication
• 4-10 Connecting to Target and a Recovery Catalog
• 4-11 Connecting to a Target Database from the System Prompt
• 4-12 Connecting to a Target Database from the System Prompt by Using Net Service Names
• 4-13 Connecting to Target and a Recovery Catalog from the System Prompt
• 4-14 Connecting to Target and Auxiliary Databases from the RMAN Prompt
• 4-15 Connecting to Target and Auxiliary Databases from the System Prompt
• 4-16 Connecting Locally to the Root
• 4-17 Connecting to the Root with Operating System Authentication
• 4-18 Connecting to the Root with a Net Service Name
• 4-19 Connecting As Target to a PDB
• 4-20 Checking the Syntax of a Command File with Bad Syntax
• 5-1 Configuring a Nondefault Backup Location
• 5-2 Configuring an ASM Disk 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 Recovery Appliance Backup Module Location During Channel Configuration
• 5-9 Specifying Recovery Appliance Client Configuration Settings
• 6-1 Configuring Channel Parallelism for Tape Devices
• 6-2 Configuring Basic Compression for Backup
• 8-1 Specifying File Names 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
• 11-1 Summary Listing of All Backups
• 11-2 Verbose Listings of Backups and Copies
• 11-3 Listing Backups By File
• 12-1 Fast Recovery Area Space Consumption
• 15-1 Sample Repair Script
• 17-1 VALIDATE DATABASE
• 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
• 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 Renaming Recovery Set Files
• 21-5 Redirecting ASM files
• 21-6 Renaming Auxiliary Set Oracle Managed Files (OMF) in TSPITR
• 21-7 Using SET NEWNAME
• 24-1 RMAN Syntax Error
• 25-1 Duplicating to a Different Host with the Same Directory Structure (Active)
• 25-2 Duplicating a PDB
• 25-3 Duplicating a Database to a Past Point in Time (Backup-Based)
• 25-4 Using an Archival Backup for Backup-Based Duplication
• 25-5 Duplicating a Database to a Past Point in Time (Backup-Based)
• 25-6 Duplicating a Database Without a Target and Recovery Catalog Connection (Backup-Based)
• 25-7 Duplicating a Database to a Past Point in Time (Backup-Based)
• 26-1 Duplicating from a File System to ASM (Active)
• 26-2 Duplicating from ASM to ASM (Active)
• 26-3 Excluding Read-Only Tablespaces
• 26-4 Excluding Specified Tablespaces
• 26-5 Including Specified Tablespaces
• 26-6 Including Specified Tablespaces
• 27-1 Specifying an Auxiliary Instance Parameter File
• 27-2 Specifying an End SCN
• 27-3 Specifying an End Restore Point
• 27-4 Specifying an End Time
• 27-5 Specifying Output File Locations
• 27-6 Using SET NEWNAME FOR DATAFILE to Name Auxiliary Data Files