Jerry Held

1
(No Transcript)
2
Oracle Recovery Manager (RMAN) 10g Reloaded
Session id 40104

• Tammy Bednar
• Sr. Product Manager
• Oracle Corporation

3
RMAN Reloaded
4
Agenda

• What is Recovery Manager?
• Automatic disk based recovery
• Optimized incremental backups
• Incrementally updated backups
• Just say no to shrinking backup windows
• A new twist to transportable tablespaces
• QA

5
Recovery Manager Oracles Backup Recovery
Utility

• Over 25 Man Years of Engineering Technology
  provides
• Intimate knowledge of database file formats and
  recovery procedures
• Manages and automates the backup, restore, and
  recovery process
• Creates and maintains backup policies
• Catalogs all backup and recovery activities
• Operates on-line and in parallel for fast
  processing
• Corrupt block detection during backup and restore
  and the ability to validate backups
• Integrated with Enterprise Manager 3rd party
  network backup products

Recovery Manager
Enterprise Manager 3rd Party Tools
Media Management Layer
Network
6
New World Disk Based Data Recovery

• Disk economics are close to tape
• Disk is better than tape
• Random access to any data
• We rearchitected our recovery strategy to take
  advantage of these economics
• Random access allows us to backup and recover
  just the changes to the database
• Backup and Recovery goes from hours to minutes

1980s - 200 MB
1000x increase
2000s - 200 GB
7
Flash Recovery Area

• Unified storage location for all recovery files
  and recovery related activities in an Oracle
  Database.
• Centralized location for control files, online
  redo logs, archive logs, flashback logs, backups
• A flash recovery area can be defined as a
  directory, file system, or ASM disk group
• A single recovery area can be shared by more than
  one database
• Minimize the number of initialization parameters
  to set when you create a database
• Define a database area and flash recovery area
  location
• Oracle creates and manages all files using OMF

Database Area
Flash Recovery Area
8
Flash Recovery Area Space Management
Disk limit is reached and a new file needs to be
written into the Flash Recovery Area
Oracle delete files that are no longer required
on disk.
Flash Recovery Area
Archive Logs Database File Backups
Space Pressure occurs
Warning Issued to user
1
RMAN updates list of files that may be deleted
2
Backup Files to be deleted
9
Benefits to Using a Flash Recovery Area

• Unifies the storage location of related recovery
  files
• Manages the disk space allocated for recovery
  files automatically
• Simplifies database administrator tasks
• Much faster backup
• Much faster restore
• Much more reliable due to inherent reliability of
  disks

10
Change Tracking File

• Optimizes incremental backups
• Track which blocks have changed since last backup
• Integrated change tracking file
• Changed blocks are tracked as redo is generated
• RMAN backup automatically uses changed block list

Flash RecoveryArea
1011001010110 0001110100101 1010101110011
Change Tracking File
11
Incremental Backup and Changed Tracking File
Benefits

• Faster
• Reduces the amount of time needed for daily
  backups
• Saves network bandwidth when backing up over a
  network
• Better
• Reduce the backup file storage
• Enables fast backups of changed blocks
• Simpler
• Automatically integrates with backup and recovery
  zero effort 

12
Incrementally Updated Backups
RMAN incremental backup
Incrementally Updated Backups
RMAN RECOVER COPY OF DATAFILE
Initiate Merge

• Eliminates the need to perform a whole database
  backup.
• Reduces the time required for media recovery
  since the image copy is updated with the latest
  block changes.

13
Eliminate Shrinking Backup Window Syndrome!

• Fully automatic disk based backup and recovery
• Set it and Forget it
• Nightly incremental backup rolls forward recovery
  area backup
• Changed blocks are tracked in production DB
• Full scan is never needed
• Dramatically faster (20x)
• Blocks validated to prevent corruption of backup
  copy
• Use low cost ATA disk array for recovery area

Flash RecoveryArea
Nightly Apply Validated Incremental
Weekly Archive To Tape
DatabaseArea
Two Independent Disk Systems
14
Oracle Suggested Strategy

• Easy Reliable
• Integrates the Oracle DB 10g features
• Fast Recovery Options
• Backup and Recovery goes from hours to minutes

15
Automated Disk Based Backup Recovery Benefits

• Much faster backup
• Just propagate changes to recovery area
• Dramatic difference for large databases
• Much faster restore
• Copy backup files from the Flash Recovery Area
• Or simply use the copy in the Flash Recovery Area
• Much more reliable due to inherent reliability of
  disks
• Tapes not needed for normal backup/recovery, only
  for archiving

16
Backup Management

• List RMAN backups
• View files included in a backup set
• Perform maintenance
• Remove obsolete backups with a single click

17
What is Transportable Tablespace?

• Mechanism to quickly move a tablespace across
  Oracle databases
• Most efficient means to move bulk data between
  databases.
• File is simply copied at OS level

24
18
Oracle10g Cross Platform Transportable Tablespace
19
Cross Platform Transportable Tablespace Benefits

• Fast data distribution in Data Warehousing
  environment (data marts)
• Used for publishing structured data (i.e.
  catalogs on CDs)
• Sharing of read only tablespaces by heterogeneous
  systems
• Allowing a database to be migrated from one
  platform to another

20
Other Oracle10g Backup Recovery Enhancements

• Compression of archive logs and backups
• Restore tolerates missing or corrupt backup
• Automatically fails over to previous backup
• Automated recovery through a previous point in
  time recovery
• Recovery through resetlogs
• Fully automated tablespace point-in-time recovery
• Automatic channel failover on backup or restore
• Time window based throttling of backups
• Tablespace Rename
• Drop Database

21
Unified storage location of related recovery
files Managed disk space for recovery files
automatically Simplified database administration
tasks
Much faster backup Much faster restore Much more
reliable due to inherent reliability of disks
Oracle Database 10g
22
Next StepsHigh Availability Sessions from Oracle
Wednesday in Moscone Room 304
Tuesday in Moscone Room 304

• 1100 AM
• How Oracle Database 10g Revolutionizes
  Availability and Enables the Grid
• 330 PM
• Oracle Recovery Manager (RMAN) 10g Reloaded
• 500 PM
• Proven Techniques for Maximizing Availability

• 830 AM
• Oracle Database 10g - RMAN and ATA Storage in
  Action
•  
• 1100 AM
• Oracle Data Guard Maximum Data Protection at
  Minimum Cost
•  
• 100 PM
• Oracle Database 10g Time Navigation Human-Error
  Correction
•  
• 430 PM
• Data Guard SQL Apply Back to the Future

For More Info On Oracle HA Go To
http//otn.oracle.com/deploy/availability/
23
Next StepsHigh Availability Sessions from Oracle
Thursday
830 AM in Moscone Room 304 Oracle Database 10g
Data Warehouse Backup and Recovery Automatic,
Simple, Reliable 830 AM in Moscone Room
104 Building RAC Clusters over InfiniBand
For More Info On Oracle HA Go To
http//otn.oracle.com/deploy/availability/
24
Resources

• HA OTN http//otn.oracle.com/deploy/availability
  
• RMAN Discussion Forum http// otn.oracle.com
• MetaLink http// MetaLink.oracle.com

25
Reminder please complete the OracleWorld
online session surveyThank you.
26
(No Transcript)