Pro Oracle Database 11g Administration (6 page)
10. Using a Recovery Catalog ............................................................................................................ 470
11. Using a Media Manager ............................................................................................................... 470
xxi
■ CONTENTS
12. Setting the CONTROL_FILE_RECORD_KEEP_TIME Initialization Parameter ................................. 471
13. Configuring RMAN’s Backup-Retention Policy ............................................................................. 471
14. Configuring the Archive-Redo Logs’ Deletion Policy .................................................................... 472
15. Setting the Degree of Parallelism ................................................................................................ 473
16. Using Backup Sets or Image Copies ............................................................................................ 474
17. Using Incremental Backups ......................................................................................................... 475
18. Using Incrementally Updated Backups ........................................................................................ 475
19. Using Block-Change Tracking ...................................................................................................... 476
20. Configuring Binary Compression .................................................................................................. 476
21. Configuring Encryption ................................................................................................................. 477
22. Configuring Miscellaneous Settings ............................................................................................. 477
Segueing from Decisions to Action ............................................................................. 478
Using a Recovery Catalog ........................................................................................... 482
Creating a Recovery Catalog .............................................................................................................. 482
Registering a Target Database ........................................................................................................... 484
Backing Up the Recovery Catalog ...................................................................................................... 484
Synchronizing the Recovery Catalog .................................................................................................. 485
Recovery Catalog Versions ................................................................................................................. 485
Dropping a Recovery Catalog ............................................................................................................. 485
Summary ..................................................................................................................... 486
■Chapter 18: RMAN Backups and Reporting ....................................................... 487
Preparing to Run RMAN Backup Commands .............................................................. 487
Setting NLS_DATE_FORMAT .............................................................................................................. 488
Setting ECHO Setting ECHO ................................................................................................................ 488
Showing Variables ............................................................................................................................. 489
Running Backups ........................................................................................................ 489
Backing up the Entire Database ......................................................................................................... 489
Backing up Tablespaces .................................................................................................................... 491
Backing up Datafiles .......................................................................................................................... 491
Backing up the Control File ................................................................................................................ 491
xxii
■ CONTENTS
Backing up the Spfile ......................................................................................................................... 492
Backing up Archive Redo Logs .......................................................................................................... 492
Backing up Fast Recovery Area ......................................................................................................... 493
Excluding Tablespaces from Backups ............................................................................................... 493
Backing up Datafiles Not Backed Up ................................................................................................. 494
Skipping Read-Only Tablespaces ...................................................................................................... 494
Skipping Offline or Inaccessible Files ................................................................................................ 494
Backing Up Large Files in Parallel ..................................................................................................... 495
Adding RMAN Backup Information to the Repository ......................................................................... 495
Creating Incremental Backups .................................................................................... 496
Taking Incremental Level Backups .................................................................................................... 497
Making Incrementally Updating Backups .......................................................................................... 498
Using Block Change Tracking ............................................................................................................ 499
Checking for Corruption in Datafiles and Backups ..................................................... 499
Using VALIDATE .................................................................................................................................. 500
Using BACKUP...VALIDATE .................................................................................................................. 501
Using RESTORE...VALIDATE ................................................................................................................ 501
Logging RMAN Output ................................................................................................. 501
Redirecting Output to a File ............................................................................................................... 501
Capturing Output with Unix/Linux Logging Commands ..................................................................... 502
Logging Output to a File ..................................................................................................................... 503
Querying for Output in the Data Dictionary ........................................................................................ 503
RMAN Reporting .......................................................................................................... 504
Using LIST .......................................................................................................................................... 504
Using REPORT .................................................................................................................................... 504
Using SQL ........................................................................................................................................... 505
Summary ..................................................................................................................... 508
■Chapter 19: RMAN Restore and Recovery ......................................................... 509
Determining Media Recovery Required ...................................................................... 510
Determining What to Restore ...................................................................................... 511
xxiii
■ CONTENTS
How the Process Works ..................................................................................................................... 511
Using Data Recovery Advisor ............................................................................................................. 512
Using RMAN to Stop/Start Oracle ................................................................................ 515
Shutting Down ................................................................................................................................... 515
Starting Up ......................................................................................................................................... 515
Complete Recovery ..................................................................................................... 516
Testing Restore and Recovery ........................................................................................................... 516
Restoring Entire Database ................................................................................................................. 518
Restoring Tablespaces ....................................................................................................................... 519
Restoring Read-Only Tablespaces ..................................................................................................... 520
Restoring Temporary Tablespaces ..................................................................................................... 521
Restoring Datafiles ............................................................................................................................. 521
Restoring Datafiles to Non-Default Locations .................................................................................... 522
Performing Block Level Recovery ...................................................................................................... 523
Restoring Archive Redo Log Files ...................................................................................................... 524
Restoring the Spfile ............................................................................................................................ 526
Restoring a Control File ............................................................................................... 527
Using a Recovery Catalog .................................................................................................................. 527
Using an Autobackup to Restore ........................................................................................................ 528
Specifying a Filename ........................................................................................................................ 528
Incomplete Recovery .................................................................................................. 529
Determining the Type of Incomplete Recovery .................................................................................. 531
Performing Time-Based Recovery ..................................................................................................... 532
Performing Log Sequenced-Based Recovery ..................................................................................... 532
Performing Change/SCN-Based Recovery ......................................................................................... 533
Restoring to a Restore Point .............................................................................................................. 533
Restoring and Recovering to Different Server ............................................................ 534
Step 1: Create an RMAN Backup on the Originating Database .......................................................... 535
Step 2: Copy RMAN Backup to Destination Server ............................................................................. 536
Step 3: Ensure that Oracle is Installed ............................................................................................... 536
xxiv
■ CONTENTS
Step 4: Source the Required OS Variables ......................................................................................... 536
Step 5: Create an init.ora File for the Database to be Restored ......................................................... 536
Step 6: Create any Required Directories for Datafiles, Control Files, and Dump/Trace Files ............. 537
Step 7: Startup the Database in NOMOUNT Mode .............................................................................. 537
Step 8: Restore a Control File from the RMAN Backup ...................................................................... 538
Step 9: Startup Database in Mount Mode .......................................................................................... 538
Step 10: Make the Control File Aware of the Location of the RMAN Backups ................................... 538
Step 11: Rename and restore the datafiles to Reflect New Directory Locations ............................... 539
Step 12: Recover the Database .......................................................................................................... 540
Step 13: Set the New Location for the Online Redo Logs .................................................................. 541
Step 14: Open the Database .............................................................................................................. 542