Restoring SAP data with RMAN
Backup Exec integrates with RMAN, an Oracle
utility that does the following:
To restore SAP data using
RMAN, the Backup Exec Oracle Agent is required, and the Remote
Agent Utility must be run first.
See The Remote Agent
Utility for Windows Systems.
You must modify the
rman_send parameters in the Init<SID>.sap file as
rman_send = ( "channel sbt_1 'NBBSA_SAP_AGENT_CONFIG_PATH=<INI file
where <INI Path >
is the full path for the biparam.ini. For example:
See Configuring biparam.ini
for the SAP Agent.
Ensure that the ini file
path mentioned in the parameter 'util_par_file' in the
init<sid>.sap is the same path specified in the rman_send
For restores done using
RMAN, Symantec Backup Exec does not honor the configuration
parameter (-r option) passed from BRBACKUP or BRRESTORE.
init<SID>.ora as follows:
control_file_record_keep_time <n>, (say n = 45)
This parameter controls
the minimum number of days that a reusable record is kept in the
When BRRESTORE is used to
run full restores via RMAN, the database should be in mount
The command for restoring
database files only is as follows:
brrestore -d rman_util -b last -m full
For restoring the control
files, use the -m 0 [,00] option
For example, to restore
the .ctl files type the following on the command line:
brrestore -d rman_util -b last -m 0
To restore the .dbf
files, type the following on the command line:
brrestore -d rman_util -b last -m 00
When restoring with RMAN,
make sure that the media server specified in the biparam.ini file
is the media server on which the backup job was done.