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

The purpose of this white paper is to document the procedures necessary for an end-to-end backup andrecovery solution of an Oracle 10g R2 database according to these criteria:

1. The database implements disk sharing using Automatic Storage Management (ASM).

2. The FlashCopy capability of the IBM System Storage DS6000™ or DS8000™ is utilized to makea point-in-time copy of the production database volumes.

3. The combination of Oracle Recovery Manager (RMAN) and IBM Tivoli® Storage Managerproducts implement the backup and recovery of the database.

a.Full backups will be made to tape without shutting down the Production database.

b. The Archive Logs will be backed up as well as the datafiles.

c. Backups can be made whenever a new Archive Log is created or as frequent as databaseactivity dictates.

4. The Database point-in-time recovery (DBPITR) will be performed from tape, back to theProduction server.

NOTE: Some of the configuration details in this document may not be well suited for other scenarios suchas point-in-time restore from the FlashCopy.

The general outline of this document is as follows:

1. Install the software: AIX®, Oracle Database, IBM Tivoli Storage Manager Server, Data Protection for Oracle, Backup-Archive Clients and the DS6800 command line interface (dscli).

2. Create and Configure the database.3. Configure TSM.

4. FlashCopy the volumes and backup the database. This step is performed on a regular basis (eg.daily).

5. Recover the database.

Steps 1-3 will be summarized, while steps 4 and 5 will be documented in detail.

Throughout this document, the IBM Tivoli Storage Manager for Databases: Data Protection for Oracleproduct will be referred to as Data Protection for Oracle.

The IBM Tivoli Storage Manager Backup-Archive Client for AIX will be referred to as the BA Client.

Click link below…




Leave a Reply

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

You are commenting using your 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