Leveraging DS8000 Series Advanced Copy Services for Oracle User-Managed Backup and RecoveryPosted: 13/05/2011 | |
This white paper documents the use of IBM® System Storage™ DS8000™ Series Advanced Copy Services for backing up and recovering Oracle Real Application Clusters 10g (RAC) databases using Oracle Automatic Storage Management (ASM). Both Oracle RAC and ASM technologies introduce some differences with regard to Oracle Backup and Recovery when using IBM FlashCopy® technologies, as compared to single-instance, filesystem-based Oracle configurations. Deploying DS8000 Advanced Copy Services can be highly effective in any production shop that runs Oracle RAC 10g databases on ASM.
This white paper shows the robustness, speed, and ease with which you can backup, restore and recover databases, no matter their size.
The procedures are based on an Oracle User Group white paper that is titled Backup and Recovery Generic Guidelines with Point-in-Time Copy Solutions and Automatic Storage Management (located at: http://ioug.itconvergence.com/pls/apex/CILOUG.download_my_file?p_file=403).
This white paper demonstrates the use of Advanced Copy Services FlashCopy and Metro Mirror to do the following:
• Backup and restore an Oracle RAC database with Oracle Database 10g ASM
• Clone an Oracle RAC database with Oracle ASM to a local Oracle RAC
• Clone an Oracle RAC database with Oracle ASM to a remote DS8000 and Oracle RAC
• Backup and recover the Oracle RAC cluster services information
For demonstration purposes, 4-node Oracle RAC clusters were used. The process was repeated on the Linux and AIX® operating systems to demonstrate the operating-system (OS)-independence of the procedures. On all of the test beds, Oracle Clusterware, ASM and database binaries were installed in separate local directories. On the DS8000, volumes were allocated for the Oracle Cluster Registry, voting disks and the ASM diskgroups. The volumes were created by using a consistent naming convention for understanding the relationships between DS8000 volumes, DS8000 copy relationships and the ASM diskgroups. One DS8000 volume was allocated for each Oracle RAC cluster to serve as the mountable backup disk. Consistent naming allows the user to know at a glance what portion of the database is being acted upon in the backup and recovery scenarios.
Click on link below:
- Click to share on Facebook (Opens in new window)
- Click to share on Twitter (Opens in new window)
- Click to share on Google+ (Opens in new window)
- Click to email this to a friend (Opens in new window)
- Click to share on Reddit (Opens in new window)
- Click to share on Tumblr (Opens in new window)
- Click to share on Pinterest (Opens in new window)
- Click to print (Opens in new window)