344: Leveraging RMAN using the Flash Recovery Area

Objectives: Advantages of using the the FRA with RMAN over non-FRA disk saves.
Configuring RMAN to use the FRA disk and tape saves, and as an archivelog destination.
Monitoring and managing the FRA using SQL and RMAN.
Abstract: Oracle 10g leveraged 9i's "Flashback Technology" allowing RMAN to use the Flash Recovery Area (FRA) as a "self-cleaning" area to cache disk saves for use in database recovery, database duplication, even allowing the DBA to immediately replace damaged database files by "pointing" the database instance at the FRA. This presentation introduces use of the FRA with RMAN by showing the DBA how to configure the FRA, and then RMAN to use the FRA for both disk, and subsequent tape saves. Using a case study, we demonstrate a method to size the FRA, then establish a disk and tape save routine using Oracle's 10g "incremental update" technology to "roll forward" an image copy of the database using incremental database saves and Block Change Tracking (BCT). Tape saves via Veritas Netbackup show FRA space-pressure relief and complete our save architecture. Use of RMAN CONFIGURE commands and Oracle Managed Files show how the FRA is managed and cleared. Scripts to monitor FRA usage complete our talk.

Audiernce Focus: DBA
Expertise: Intermediate
Track: Database
Date: Tuesday, April 15, 2008
Time: 3:30 PM - 4:30 PM