PowerProtect Data Manager 19.14 Oracle RMAN User Guide

Restore Oracle Incremental Merge backups

Learn how to perform the self-service restore of an Oracle Incremental Merge backup by using a self-service RMAN restore script.

1. Run the ddutil -s command from the $RMAN_AGENT_HOME/bin directory to identify the storage unit, DD hostname, and top-level directory, as used for the Oracle Incremental backup. Considerations for all self-service backups provides more details.

   For example, the ddutil -s command provides the following type of information:

   $RMAN_AGENT_HOME/bin/ddutil -s
   
   PowerProtect DD hostname: 10.118.204.107
   
           FC service name: None
           FC service enabled: false
   
           Storage Unit: orcl_plc_232-blrv041a201-96ecd
           Top Level Path: PLCTLP-852e9c4b-f73f-44ab-8bbc-e469d1a59aaa
           Protection Policy Name: plc_oim_232
   
                   User: orcl_plc_232-blrv041a201-96ecd
                   Type: PROTECTION
   
                            Asset DBID: 440982799
                            Asset Tag: be240fd6

2. Retrieve the password of the storage unit that was used for the Oracle Incremental Merge backup. View the storage unit password provides more details.
3. Run the following ddutil -C command from the $RMAN_AGENT_HOME/bin directory to register the target client lockbox to the source client storage unit:

   ./ddutil -C -a BOOSTFS=TRUE -a USER_TYPE=DD_BOOST_USER -a DD_SERVER_NAME=<DD_server_IP_or_FQDN> -a USERNAME=<storage_unit_username> -a DD_STORAGE_UNIT=<storage_unit>

   For example:

   ./ddutil -C -a BOOSTFS=TRUE -a USER_TYPE=DD_BOOST_USER -a DD_SERVER_NAME=10.118.204.107 -a USERNAME=orcl_plc_232-blrv041a201-96ecd -a DD_STORAGE_UNIT=orcl_plc_232-blrv041a201-96ecd

4. Create the RMAN script for the self-service restore of the Oracle Incremental Merge backup, such as a database restore script. The following example shows an RMAN script for an archive logs restore:

   connect target /
   run {
   ALLOCATE CHANNEL CH0 TYPE 'SBT_TAPE' TRACE 2 PARMS 'SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so, ENV=(STORAGE_UNIT=orcl_plc_232-blrv041a201-96ecd, BACKUP_HOST=10.118.204.107, RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent)';
   ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' TRACE 2 PARMS 'SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so, ENV=(STORAGE_UNIT=orcl_plc_232-blrv041a201-96ecd, BACKUP_HOST=10.118.204.107, RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent)';
   ALLOCATE CHANNEL CH2 TYPE 'SBT_TAPE' TRACE 2 PARMS 'SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so, ENV=(STORAGE_UNIT=orcl_plc_232-blrv041a201-96ecd, BACKUP_HOST=10.118.204.107, RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent)';
   ALLOCATE CHANNEL CH3 TYPE 'SBT_TAPE' TRACE 2 PARMS 'SBT_LIBRARY=/home/oracle/opt/dpsapps/rmanagent/lib/libddobk.so, ENV=(STORAGE_UNIT=orcl_plc_232-blrv041a201-96ecd, BACKUP_HOST=10.118.204.107, RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent)';
   RESTORE ARCHIVELOG ALL;
   RELEASE CHANNEL CH0;
   RELEASE CHANNEL CH1;
   RELEASE CHANNEL CH2;
   RELEASE CHANNEL CH3;
   }

5. Set the Oracle environment variables ORACLE_HOME, ORACLE_SID, and PATH. For example:

   export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
   export ORACLE_SID=orcl19
   export PATH=$PATH:$ORACLE_HOME/bin

6. Run the following ddbmoim command from the $RMAN_AGENT_HOME/bin directory to perform the self-service restore of the Oracle Incremental Merge backup. The latest PowerProtect Oracle RMAN Agent Administration Guide (for the stand-alone Oracle RMAN agent) provides details about the ddbmoim command and its options:

   ./ddbmoim --dbname <Oracle_SID> -o restore -d <DD_server_name> -m <mount_path> -s <DD_storage_unit_name> -a RMAN_AGENT_HOME=<RMAN_agent_home_pathname> -a BOOSTFS_INSTALL_DIR=<BoostFS_install_directory> -a ORACLE_HOME=<Oracle_home_pathname> -a SCRIPT_PATH=<RMAN_script_complete_pathname> -a BACKUP_PATH=<snapshot_backup_image_folder_complete_pathname_on_DD>

   For example:

   ./ddbmoim --dbname orcl19 -o restore -d 10.118.204.107 -m /home/oracle/be240fd6 -s orcl_plc_232-blrv041a201-96ecd -a RMAN_AGENT_HOME=/home/oracle/opt/dpsapps/rmanagent -a BOOSTFS_INSTALL_DIR=/opt/emc/boostfs -a ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 -a SCRIPT_PATH=/home/oracle/opt/dpsapps/rmanagent/tmp/archive_log_rman_script_287f51916fb04dfbb746dd700f782498.rman -a BACKUP_PATH=/orcl_plc_232-blrv041a201-96ecd/PLCTLP-852e9c4b-f73f-44ab-8bbc-e469d1a59aaa/440982799_be240fd6/full/fastcopy/datafile.be240fd6_06202023123836