NetWorker：從主要或次要 Data Domain 還原 Oracle RMAN 或 DDBEA 備份

Summary: 本文提供一種方式，可使用 Oracle RMAN Agent 和 DDBEA 等產品，從主要或次要 Data Domain 還原資料庫

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

先決條件：

1.設定 Data Domain 複製。下列 KB 可用於指導：
2.將 ddboost 使用者指派給複製的 mtree。 
ddboost storage-unit modify "MTREE NAME" user "DDBoost User"
若要取得執行儲存裝置的清單：ddboost storage-unit show
To get a list of ddboost users run： ddboost user show
 

Oracle RMAN Agent：

1.為 Data Domains 和個別儲存裝置註冊 Lockbox： 
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.使用 RMAN 腳本將資料庫備份至主要 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.從主要 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.從次要 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

主要 Data Domain 的 CFG configuration_file1 
DDBOOST_USER = ddboost
DEVICE_HOST = DD1.lss.emc.com
DEVICE_PATH = /rman_su1
CLIENT = orahost1
次要 Data Domain 的 CFG configuration_file2 
DDBOOST_USER = ddboost
DEVICE_HOST = DD2.lss.emc.com
DEVICE_PATH = /rman_su1_dr
CLIENT = orahost1
1.註冊主要 Data Domain 的鎖定框 
/opt/dpsapps/dbappagent/bin/ddbmadmin -P -z configuration_file1

2.使用 RMAN 腳本將資料庫備份至主要 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.從主要 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.從次要 Data Domain 執行資料庫還原
i） 為次要 Data Domain 註冊鎖定框 
/opt/dpsapps/dbappagent/bin/ddbmadmin -P -z configuration_file2

ii） 執行資料庫復原： 
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

NetWorker

Products

Data Backup & Protection Software, Data Protection Suite, NetWorker Family
Article Properties
Article Number: 000185676
Article Type: How To
Last Modified: 19 Sep 2023
Version:  2
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.