Leveraging DS8000 Series Advanced Copy Services for Oracle User-Managed Backup and Recovery

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:

Ora DB RAC ASM Bkup Recovery using DS8k Adv Copy Services

Enjoy

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s