Oracle Database 11g: Administration Workshop II A-2
Table of Contents
Practices for Lesson 1 ......................................................................................................... 4
Practice 1-1: Upgrade the Database Storage to ASM..................................................... 5
Practice 1-2: ASM Fast Mirror Resync ........................................................................ 18
Practice 1-3: ASMCMD ............................................................................................... 23
Practices for Lesson 2 ....................................................................................................... 25
Practice 2-1: Configuring ARCHIVELOG Mode ........................................................ 26
Practice 2-2: Resizing the Flash Recovery Area........................................................... 28
Practice 2-3: Verifying the Backup Destination ........................................................... 30
Practice 2-4: Configuring the Retention Policy............................................................ 32
Practices for Lesson 3 ....................................................................................................... 33
Practice 3-1: Creating a Recovery Catalog................................................................... 34
Practice 3-2: Creating the Recovery Catalog Owner.................................................... 47
Practice 3-3: Creating the Recovery Catalog................................................................ 48
Practice 3-4: Registering a Database in the Recovery Catalog..................................... 49
Practice 3-5: Cataloging Additional Backup Files........................................................ 51
Practice 3-6: Backing Up the Recovery Catalog .......................................................... 53
Practices for Lesson 4 ....................................................................................................... 56
Practice 4-1: Setting the Date and Time Format for RMAN........................................ 57
Practice 4-2: Enabling Control File Autobackup.......................................................... 58
Practice 4-3: Configuring Devices for Backup............................................................. 60
Practices for Lesson 5 ....................................................................................................... 62
Practice 5-1: Creating Fast Incremental Backups......................................................... 63
Practice 5-2: Cross-Checking Backups......................................................................... 66
Practice 5-3: Listing Backup Files................................................................................ 70
Practices for Lesson 6 ....................................................................................................... 82
Practice 6-1: Backing Up a NOARCHIVELOG Database.............................................. 83
Practice 6-2: Recovering from the Loss of All Control File Copies............................. 87
Practice 6-3: Recovering from Loss of a Redo Log Group .......................................... 93
Practices for Lesson 7 ....................................................................................................... 96
Practice 7-1: Recovering Image Copies........................................................................ 97
Practice 7-2: Performing Fast Recovery..................................................................... 104
Practices for Lesson 8 ..................................................................................................... 111
Practice 8-1: Cloning a Database................................................................................ 112
Practices for Lesson 9 ..................................................................................................... 123
Practice 9-1: Performing Tablespace Point-in-Time Recovery.................................. 124
Practices for Lesson 10 ................................................................................................... 135
Practice 10-1: Monitoring RMAN Jobs...................................................................... 136
Practices for Lesson 11 ................................................................................................... 138
In these practices you use the recycle bin to flash back dropped objects. You also
explore the workings of Flashback Transaction. ........................................................ 138
Practice 11-1: Using the Recycle Bin ......................................................................... 139
Practice 11-2: Flashback Transaction Backout........................................................... 142
Practices for Lesson 12 ................................................................................................... 151
Oracle Internal & OAI Use Only