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

Zusammenfassung: 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

Dieser Artikel gilt für Dieser Artikel gilt nicht für Dieser Artikel ist nicht an ein bestimmtes Produkt gebunden. In diesem Artikel werden nicht alle Produktversionen aufgeführt.
Andere Ressourcen ansehen

Weisungen

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;
}

Betroffene Produkte

NetWorker

Produkte

Data Backup & Protection Software, Data Protection Suite, NetWorker Family
Artikeleigenschaften
Artikelnummer: 000185676
Artikeltyp: How To
Zuletzt geändert: 19 Sep. 2023
Version:  2
Antworten auf Ihre Fragen erhalten Sie von anderen Dell NutzerInnen
Support Services
Prüfen Sie, ob Ihr Gerät durch Support Services abgedeckt ist.