Learn how to perform the self-service restore of an Oracle Incremental Merge backup by using a self-service RMAN restore script.
About this task
As required for the self-service restore of the Oracle Incremental Merge backup, you must obtain details about the storage unit and DD host, register the target client lockbox, and create an RMAN restore script. To run the self-service restore, you must use the
ddbmoim command with the appropriate options. Complete the following procedure to perform the self-service restore.
Steps
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
Retrieve the password of the storage unit that was used for the Oracle Incremental Merge backup.
View the storage unit password provides more details.
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
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:
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 standalone 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
Data is not available for the Topic
Please provide ratings (1-5 stars).
Please provide ratings (1-5 stars).
Please provide ratings (1-5 stars).
Please select whether the article was helpful or not.
Comments cannot contain these special characters: <>()\