Performing SAP restores using the SAPDBA utility (SAP on Oracle databases only)
To restore a partial database or full Oracle database, you must have a list of valid restores. Use the sapdba system to maintain the list of restores for specific tablespace or complete database restores.
When the user restores either individual tablespaces or full databases, the user is prompted before an existing copy of the target file is deleted. sapdba then invokes the brrestore command.
brrestore submits the BID and file name list to the NetBackup for SAP backint interface. The backint interface cross-references the exact date and time to when the backup was made and uses NetBackup to recover the file. The backint interface monitors the progress of the restore and reports status back to brrestore.
Upon completion, the backint interface saves a copy of the NetBackup restore logs for auditing purposes. sapdba then provides required database recovery, such as media recovery, and restarts the database server.
To use brrestore to restore database files
- In Oracle-based environments without RMAN, use the command with the following options:
brrestore -d util_file -b last -m full -c force
- In Oracle-based environments with RMAN, use the command with the following options:
brrestore -d rman_util -b last -m full -c force