PowerProtect Data Manager 19.10 Oracle RMAN User Guide

Restore an Oracle application host

You can perform database restores directly to the Oracle application host by using the Oracle RMAN agent.

To perform an Oracle database restore, you must prepare the database and then run an RMAN script to restore the data. The RMAN documentation provides detailed information about how to prepare the database and create the RMAN restore script. The documentation also describes all the supported restore features.

To identify the storage unit and DD hostname, run the ddutil -s command on the Oracle client. For example, run the following command in the $RMAN_AGENT_HOME/bin directory:

./ddutil -s

Specify the storage unit, top-level pathname, and DD hostname in the RMAN restore script.

The following example shows an RMAN script that performs a complete restore of the database to the current time, after the database has been prepared:

connect target username/password;

run {
set CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO './ PLCTLP-4eb04bd9-b825-4e72-b668-14e9aacaa522/%F';

allocate channel c1 type SBT_TAPE parms 'SBT_LIBRARY=rman_agent_home/lib/libddobk.so, ENV=(RMAN_AGENT_HOME=rman_agent_home, STORAGE_UNIT=XYZ, BACKUP_HOST=bu-ddbealin-17.lss.emc.com)';

restore database;
recover database;

release channel c1;
}

The libddobk.so library location and the RMAN_AGENT_HOME, STORAGE_UNIT, and BACKUP_HOST settings must be specified in the allocate channel command. All other parts of the script are standard RMAN commands.

To increase the parallelism of the restore, you can allocate more channels:

connect target username/password;

run {
set CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO './ PLCTLP-4eb04bd9-b825-4e72-b668-14e9aacaa522/%F';

allocate channel c1 type SBT_TAPE parms 'SBT_LIBRARY=rman_agent_home/lib/libddobk.so, ENV=(RMAN_AGENT_HOME=rman_agent_home, STORAGE_UNIT=XYZ, BACKUP_HOST=bu-ddbealin-17.lss.emc.com)';
allocate channel c2 type SBT_TAPE parms 'SBT_LIBRARY=rman_agent_home/lib/libddobk.so, ENV=(RMAN_AGENT_HOME=rman_agent_home, STORAGE_UNIT=XYZ, BACKUP_HOST=bu-ddbealin-17.lss.emc.com)';
allocate channel c3 type SBT_TAPE parms 'SBT_LIBRARY=rman_agent_home/lib/libddobk.so, ENV=(RMAN_AGENT_HOME=rman_agent_home, STORAGE_UNIT=XYZ, BACKUP_HOST=bu-ddbealin-17.lss.emc.com)';
allocate channel c4 type SBT_TAPE parms 'SBT_LIBRARY=rman_agent_home/lib/libddobk.so, ENV=(RMAN_AGENT_HOME=rman_agent_home, STORAGE_UNIT=XYZ, BACKUP_HOST=bu-ddbealin-17.lss.emc.com)';

restore database;
recover database;

release channel c1;
release channel c2;
release channel c3;
release channel c4;
}