Skip to main content

Techdocs Library > White papers >

Oracle 10g R2 with Automatic Storage Management and IBM System Storage FlashCopy Backup and Recovery Procedures



Document Author:
Additional Author(s):

Ravisankar Shanmugam
Erik Salander


Document ID:

WP101022


Doc. Organization:

Advanced Technical Sales


Document Revised:

06/13/2012


Product(s) covered:

Oracle







Abstract: This white paper documents the procedures necessary to backup and recover an Oracle 10g R2 database in the use case defined by these criteria:

This paper documents a process for backing up and recovering a Oracle 10gR2 database that was implemented using disk sharing with Oracle's Automatic Storage Management (ASM) feature.

For this example IBM System Storage FlashCopy is used to make a point-in-time copy of the production database volumes. The combination of Oracle Recovery Manager (RMAN) and IBM Tivoli Storage Manager are used to implement the backup and recovery of the database. Full backups were made to tapes without shutting down the Oracle database. The Archive Logs and all datafiles were backup up as part of the process. The backups can be made whenever a new Archive Log is created or as frequent as once a day, depending on database activity. The recovery of the database is from tape to the server.

NOTE: Some of the configuration details in this document may not be well suited for other scenarios such as point-in-time restore from the FlashCopy. For example, the procedure will change if you want to use the recovery command to have the FlashCopy target become a restored copy of the database. The use of FlashCopy in this document is only to create a second copy of the database so RMAN can run from the second copy not from the primary copy where the database is located.

ORA DB ASM FlashCopy 050907.pdf



Classification:

Solutions

Category:

Installation and Migration

Solution(s):

ISV Applications

ISV(s):

Oracle

Platform(s):

IBM System Storage



O/S:

Windows

Keywords:

IBM, Oracle, 10gR2, FlashCopy, Database, ASM, Automatic Source Management, FlashCopy, Backup


The Techdocs Library
Is this your first visit to Techdocs (the Technical Sales Library)?

Learn more


Techdocs QuickSearch

: