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 Auxiliary 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