Read Oracle RMAN 11g Backup and Recovery Online
Authors: Robert Freeman
RMAN Workshop:
Using RMAN Stored Scripts
. . . . . . . . . . . . . . . . . . . . . . . . . 420
Reporting on Datafiles That Have Not Been Backed Up Recently . . . . . . . . . . . 438
Reporting on Backup Redundancy or Recovery Window . . . . . . . . . . . . . . . . . 439
Reporting on Unrecoverable Operations on Datafiles . . . . . . . . . . . . . . . . . . . . 439
Performance Tuning RMAN Backup and Recovery Operations . . . . . . . . . . . . . . . . . . 445
RMAN Performance: What Can Be Achieved? . . . . . . . . . . . . . . . . . . . . . . . . . 446
Identifying Database–Related RMAN Issues . . . . . . . . . . . . . . . . . . . . . . . . . . . 454
Duplication to the Same Server: An Overview . . . . . . . . . . . . . . . . . . . . . . . . . 474
Duplication to the Same Server, Different ORACLE_HOME . . . . . . . . . . . . . . . 475
Contents
xix
Duplication to a Remote Server: An Overview . . . . . . . . . . . . . . . . . . . . . . . . . 475
RMAN Workshop:
Build a Password File
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 479
RMAN Workshop:
Duplication to the Same Server, Using Disk Backups
. . . . . 482
RMAN Workshop:
Duplication to a Remote Server, Using Disk Backups
. . . . . 485
Using Tape Backups for Remote Server Duplication . . . . . . . . . . . . . . . . . . . . . 487
Target-Less Duplication in 11
g
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 487
Incomplete Duplication: Using the DBNEWID Utility . . . . . . . . . . . . . . . . . . . 488
Requirements for Using RMAN for Standby Database Creation . . . . . . . . . . . . 493
The duplicate…for standby Command . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 494
RMAN Workshop:
Create a Standby Database Using RMAN
. . . . . . . . . . . . . . 495
Datafile Backups from the Standby Database . . . . . . . . . . . . . . . . . . . . . . . . . . 499
Archive Log Backups from the Standby Database . . . . . . . . . . . . . . . . . . . . . . . 499
Using Flashback Database for Standby Database Reinstantiation . . . . . . . . . . . 500
Media Management Considerations During a Restore . . . . . . . . . . . . . . . . . . . . 508
RMAN Workshop:
Duplicating a RAC Database to a Single-Node Database
. . 510
RMAN Workshop:
Creating a Single-Node Standby Database from
Backing Up the Multinode RAC Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . 515
xx
Oracle RMAN 11
g
Backup and Recovery
Mounting a Split Mirror Volume on Another Server . . . . . . . . . . . . . . . . . . . . . 523
Registering Split Mirror Copies with RMAN . . . . . . . . . . . . . . . . . . . . . . . . . . . 524
Taking RMAN Backups from the Split Mirror . . . . . . . . . . . . . . . . . . . . . . . . . . 525
RMAN Workshop:
Configure RMAN to Back Up from the Split Mirror
. . . . . . . 526
Getting Sync and Split Functionality from Oracle Software . . . . . . . . . . . . . . . . 527
Using a Standby Database, Flashback Database, and Incremental
Benefits of the Oracle Sync and Split Solution . . . . . . . . . . . . . . . . . . . . . . . . . 528
What Recovery Options Are Available? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 533
Who Can Act as a Second Pair of Eyes During Recovery? . . . . . . . . . . . . . . . . . 533
Case #1: Recovering from Complete Database Loss (NOARCHIVELOG Mode)
Case #2: Recovering from Complete Database Loss (NOARCHIVELOG Mode)
Case #3: Recovering from Complete Database Loss (ARCHIVELOG Mode)
Case #4: Recovering from Complete Database Loss (ARCHIVELOG Mode)