NetWorker: Restore Oracle RMAN or DDBEA backups from primary or secondary Data Domain

Summary: This article provides a way of restoring database from a primary or a secondary Data Domain using product such as Oracle Recovery Manager (RMAN) Agent and DDBEA.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Instructions

Prerequisite:

1. Set up Data Domain replication. The following knowledgebase articles can be used for guidance:

2. Assign the ddboost user to the replicated mtree.

ddboost storage-unit modify "MTREE NAME" user "DDBoost User"
Get a list of storage-units run: ddboost storage-unit show
Get a list of DD Boost users run: ddboost user show

Oracle RMAN Agent:

1. Register lockbox for both Data Domains and respective storage-units:

RUN {
ALLOCATE CHANNEL C1 TYPE 'SBT_TAPE' TRACE 5 PARMS 'BLKSIZE=1048576,
SBT_LIBRARY=/home/oracle1/rman_agent_home/lib/libddobk.so,
ENV=(BACKUP_HOST=DD1.lss.emc.com,
RMAN_AGENT_HOME=/home/oracle1/rman_agent_home)';
send 'set username q_ost password 1X3quest servername DD1.lss.emc.com storageunit rman_su1';
send 'set username q_ost password 1X3quest servername DD2.lss.emc.com storageunit rman_su1_dr';
RELEASE CHANNEL C1;
}


2. Backup the database using RMAN script to the primary Data Domain 

RUN {
ALLOCATE CHANNEL CH1 TYPE 'SBT_TAPE' TRACE 5 PARMS
'BLKSIZE=1048576,
SBT_LIBRARY=/home/oracle1/rman_agent_home/lib/libddobk.so,
ENV=(STORAGE_UNIT=rman_su1,
BACKUP_HOST=DD1.lss.emc.com,
RMAN_AGENT_HOME=/home/oracle1/rman_agent_home)';
BACKUP DATABASE FORMAT './testdir/%u_%p';
RELEASE CHANNEL CH1;
}


3. Perform database restore from the primary Data Domain. 

RUN {
ALLOCATE CHANNEL C1 TYPE 'SBT_TAPE' TRACE 5 PARMS 'BLKSIZE=1048576,
SBT_LIBRARY=/home/oracle1/rman_agent_home/lib/libddobk.so,
ENV=(STORAGE_UNIT=rman_su1,
BACKUP_HOST=DD1.lss.emc.com,
RMAN_AGENT_HOME=/home/oracle1/rman_agent_home)';
RESTORE DATABASE;
RECOVER DATABASE;
RELEASE CHANNEL CH1;
}


4. Perform database restore from the secondary Data Domain. 

RUN {
ALLOCATE CHANNEL C1 TYPE 'SBT_TAPE' TRACE 5 PARMS 'BLKSIZE=1048576,
SBT_LIBRARY=/home/oracle1/rman_agent_home/lib/libddobk.so,
ENV=(STORAGE_UNIT=rman_su1_dr,
BACKUP_HOST=DD2.lss.emc.com,
RMAN_AGENT_HOME=/home/oracle1/rman_agent_home)';
RESTORE DATABASE;
RECOVER DATABASE;
RELEASE CHANNEL CH1;
}

DDBEA

CFG configuration_file1 for primary Data Domain

DDBOOST_USER = ddboost
DEVICE_HOST = DD1.lss.emc.com
DEVICE_PATH = /rman_su1
CLIENT = orahost1

CFG configuration_file2 for secondary Data Domain

DDBOOST_USER = ddboost
DEVICE_HOST = DD2.lss.emc.com
DEVICE_PATH = /rman_su1_dr
CLIENT = orahost1

1. Register lockbox for the primary Data Domain.

/opt/dpsapps/dbappagent/bin/ddbmadmin -P -z configuration_file1


2. Backup the database using RMAN script to the primary Data Domain 

RUN {
ALLOCATE CHANNEL C1 DEVICE TYPE SBT_TAPE PARMS 'BLKSIZE=1048576, 
SBT_LIBRARY=/opt/dpsapps/dbappagent/lib/lib64/libddboostora.so, 
SBT_PARMS=(CONFIG_FILE=/orasnb/configuration_file1)'
FORMAT '%d_%U';
BACKUP DATABASE;
RELEASE CHANNEL CH1;
}


3. Perform database restore from the primary Data Domain. 

RUN {
ALLOCATE CHANNEL DEVICE TYPE SBT_TAPE PARMS
'SBT_LIBRARY=/opt/dpsapps/dbappagent/lib/lib64/libddboostora.so,
SBT_PARMS=(CONFIG_FILE=/orasnb/configuration_file1)';
RESTORE DATABASE;
RECOVER DATABASE;
RELEASE CHANNEL CH1;
}


4. Perform database restore from the secondary Data Domain.

i) Register lockbox for the secondary Data Domain:
/opt/dpsapps/dbappagent/bin/ddbmadmin -P -z configuration_file2

ii) Perform database recovery: 
RUN {
ALLOCATE CHANNEL C1 DEVICE TYPE SBT_TAPE PARMS 'BLKSIZE=1048576, 
SBT_LIBRARY=/opt/dpsapps/dbappagent/lib/lib64/libddboostora.so, 
SBT_PARMS=(CONFIG_FILE=/orasnb/configuration_file2)';
RESTORE DATABASE;
RECOVER DATABASE;
RELEASE CHANNEL CH1;
}

Affected Products

Database App Agent, NetWorker, NetWorker Module for Databases and Applications

Products

Data Backup & Protection Software, Data Protection Suite, NetWorker Family, NetWorker Module
Article Properties
Article Number: 000185676
Article Type: How To
Last Modified: 13 شوال 1447
Version:  3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.