Integrating Oracle and Data Protector

Oracle RMAN Metadata and Data Protector Media Management Database Synchronization

Oracle RMAN Metadata and Data ProtectorMedia ManagementDatabase Synchronization

This section describes how to synchronize the Oracle RMAN metadata with the Data Protector Media Management Database.

The RMAN metadata contains information about the target database. RMAN uses this information for all backup, restore and maintenance operations. The metadata can be stored either in the recovery catalog database or in the control files.

Data Protector is the media manager that Oracle needs to perform tape storage backups and restores.

Data Protector has its own data protection policy that is not automatically synchronized with Oracle RMAN metadata. To have both catalogs synchronized, run the following command using RMAN:

allocate channel for maintenance type 'sbt_tape' parms 'ENV=(OB2MAINTENANCE=1)';

crosscheck backup completed after "TO_DATE(’01/13/06 10:30:00’,’MM/DD/YY HH24:MI:SS’)";

release channel;

RMAN checks every backup piece in the repository and queries the MMDB for the availability of that backup piece. RMAN then mark the backup piece as expired or available, depending on media availability. Note that in the above example, RMAN does not delete backup pieces that are reported as expired by the MMDB, but instead marks them as expired.

In order to delete expired backup objects from the recovery catalog database, run the following command using RMAN:

delete expired backup;

See the Oracle Recovery Manager User’s Guide and References for more details on recovery catalog maintenance.

114

Chapter 1