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

Résumé: This article provides a way of restoring database from a primary or a secondary Data Domain using product such as Oracle RMAN Agent and DDBEA

Cet article concerne Cet article ne concerne pas Cet article n’est associé à aucun produit spécifique. Toutes les versions du produit ne sont pas identifiées dans cet article.
Consulter d’autres ressources

Instructions

Prerequisite:

1. Set up Data Domain replication. The following KBs can be used for guidance:
2. Assign the ddboost user to the replicated mtree. 
ddboost storage-unit modify "MTREE NAME" user "DDBoost User"
To get a list of storage-units run: ddboost storage-unit show
To get a list of ddboost 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. To 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. To 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. To 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. To 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;
}

Produits concernés

NetWorker

Produits

Data Backup & Protection Software, Data Protection Suite, NetWorker Family
Propriétés de l’article
Numéro d’article: 000185676
Type d’article: How To
Dernière modification: 19 sept. 2023
Version:  2
Trouvez des réponses à vos questions auprès d’autres utilisateurs Dell
Services de support
Vérifiez si votre appareil est couvert par les services de support.