1A parte admin rac

Appendix A Practices and Solutions

Table of Contents
Practices for Lesson 1 ......................................................................................................... 4 Practice 1-2: Reviewing the Database Architecture ............................................... 5 Practices for Lesson 2......................................................................................................... 6 Practice 2-1: Configuring ARCHIVELOG Mode .................................................. 6 Practice 2-2: Resizing the Flash Recovery Area..................................................... 8 Practice 2-3: Verifying the Backup Destination ................................................... 12 Practice 2-4: Configuring the Retention Policy.................................................... 15 Practices for Lesson 3 ....................................................................................................... 16 Practice 3-1: Creating a Recovery Catalog........................................................... 16 Practice 3-2: Creating the Recovery Catalog Owner............................................ 24 Practice 3-3: Creating the RecoveryCatalog........................................................ 25 Practice 3-4: Registering a Database in the Recovery Catalog............................. 26 Practice 3-5: Backing up the Recovery Catalog ................................................... 29 Practices for Lesson 4 ....................................................................................................... 33 Practice 4-1:Setting the Date and Time Format for RMAN ................................ 33 Practice 4-2: Enabling Control File Autobackup.................................................. 35 Practice 4-3: Configuring Devices for Backup..................................................... 37 Practices for Lesson 5 .......................................................................................................39 Practice 5-1: Creating Fast Incremental Backups................................................. 39 Practice 5-2: Cross-Checking Backups................................................................. 42 Practice 5-3: Listing Backup Files and Creating Archival Backup ...................... 47 Practices for Lesson 6....................................................................................................... 58 Practice 6-1: Backing up the Database ................................................................. 58 Practice 6-2: Recovering from the Loss of a Data File......................................... 61 Practice 6-3: Recovering from the Loss of all Control Files ................................ 66 Practice 6-4: Recovering from the Loss of a Redo Log Group............................ 71 Practices for Lesson 7 ....................................................................................................... 75 Practice 7-1: Recovering Image Copies................................................................ 75 Practice 7-2: Performing Fast Recovery ............................................................... 83 Practices for Lesson 8....................................................................................................... 90 Practice 8-1: Monitoring RMAN Jobs.................................................................. 90 Practices for Lesson 9 ....................................................................................................... 93 Practice 9-1: DiagnosticScenario......................................................................... 94 Practice 9-2: Repairing Block Corruption .......................................................... 109 Practices for Lesson 10 ................................................................................................... 116 Practice 10-1: Flashback Transaction Backout................................................... 117 Practices for Lesson 11...