Integrating Oracle and Data Protector

Backing Up an Oracle Database

 

Start a backup on the Oracle server using either Oracle Recovery

 

 

Manager or Oracle Enterprise Manager. See “Starting Oracle Backup

 

 

Using RMAN” on page 62.

Backup Procedure

The following happens when you start a backup using the Data Protector

 

user interface:

 

1.

Data Protector executes ob2rman.pl on the client. This command

 

 

starts RMAN and sends the Oracle RMAN Backup Command Script

 

 

to the standard input of the RMAN command.

 

2.

The Oracle RMAN contacts the Oracle Server, which contacts Data

 

 

Protector via the MML interface and initiates a backup.

 

3.

During the backup session, the Oracle Server reads data from the

 

 

disk and sends it to Data Protector for writing to the backup device.

 

 

Messages from the Data Protector backup session and messages

 

 

generated by Oracle are logged to the Data Protector database.

 

A backup of the Oracle recovery catalog is performed automatically

 

following each Oracle target database backup, unless otherwise specified

 

in the backup specification. Using the standard Oracle export utility, the

 

Data Protector ob2rman.pl starts an export of the Oracle recovery

 

catalog to a file which is then backed up by Data Protector.

Deleting Data from When backing up an Oracle database using the recovery catalog

the Recovery

database, all information about the backup, restore, and recovery of the

Catalog

database is stored in the recovery catalog. This information is used by

 

RMAN during the restore. If you overwrite or format the media on which

 

this data is backed up, Data Protector exports the object from the Data

 

Protector database. You must manually delete the data from the recovery

 

catalog while logged on to RMAN. See the Oracle Recovery Manager

 

User’s Guide and References for detailed information about deleting data

 

from the recovery catalog.

Scheduling a Backup

For more information on scheduling, see the online Help index: “scheduled backups”.

A backup schedule can be tailored according to your business needs. If you have to keep the database online continuously, then you should back it up frequently, including the backup of the Archived Redo Logs, which is required in case you need a recovery to a particular point in time.

58

Chapter 1