Backing Up and Restoring SAP Data › Overview of SAPDBA

Overview of SAPDBA

SAPDBA is an Oracle database administration tool that lets you perform various database administration functions, including:

• Backing up, restoring, and recovering data
• Starting up and shutting down databases
• Extending tablespaces
• Monitoring and analyzing space on the database
• Reorganizing databases
• Recovering databases

SAPDBA uses BRBACKUP, BRARCHIVE, and BRRESTORE modules (which are embedded in the menu structure of SAPDBA) to integrate with the database backup, restore, and inquiry functions.

SAPDBA evaluates logs to decide if data can be recovered using the selected backups. SAPDBA evaluates the selected backup method and determines if it will prevent recovery between the time of the backup and the selected recovery end time (point in time). If SAPDBA cannot perform a recovery, it rejects the selected backup or recovery procedure.

In addition to the SAPDBA tool, BR* Tools let you execute commands to perform backup, restore, and inquire operations.

The following diagram illustrates how SAP R/3 databases are backed to local data mover servers:

The following diagram illustrates how SAP R/3 databases are backed up to remote Arcserve Backup servers: