目標:利用RMAN Duplicate 建立Standby
ENV:
Oracle9i + Suse9 + DataGuard + 預設的最大效能模式

Primary 192.168.1.101 ORACLE_SID=dupdb
Standby 192.168.1.102 ORACLE_SID=dupdb

此文件要求讀者具備RMAN,DataGuard的基本知識. 更多的內容參考官方文件<>

操作步驟

1 Make a backup of the primary database and Create a standby control file(Primary)

BACKUP DATABASE
INCLUDE CURRENT CONTROLFILE FOR STANDBY
PLUS ARCHIVELOG;

2 將備份Piece, 引數檔案,密碼檔案打包傳過去,引數檔案包在Backup Piece中(Standby)
或透過NFS共享

注意:在將備份檔案複製到Standby上時,存放備份檔案的目錄必須與Primary備份檔案所在的目錄結構一樣,
這樣控制檔案才能找到備份檔案

3 配置Primary NET

3.1 配置tnsnames.ora(Primary)
standby =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = dupdb)
    )
)

3.2 手工註冊監聽(Primary)
SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/9ir2)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = dupdb)
      (ORACLE_HOME = /opt/oracle/product/9ir2)
      (SID_NAME = dupdb)
    )
)

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
      )
    )
)

3.3 lsnrctl start 開啟監聽

3.4 tnsping standby 測試連線

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 29-JAN-2010 14:03:54

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))) (CONNECT_DATA = (SID = dupdb)))
OK (10 msec)

4 配置Standby NET

4.1 配置tnsnames.ora(Standby)
dupdb =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = dupdb)
    )
)

4.2 手工註冊監聽(Standby)
SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/9ir2)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = dupdb)
      (ORACLE_HOME = /opt/oracle/product/9ir2)
      (SID_NAME = dupdb)
    )
)

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))
      )
    )
)

4.3 lsnrctl start 開啟監聽

4.4 tnsping dupdb

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 29-JAN-2010 13:14:17

Used parameter files:
/opt/oracle/product/9ir2/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))) (CONNECT_DATA = (SID = dupdb)))
OK (10 msec)

5 編輯引數檔案

5.1 編輯Primary引數檔案

pfile='/opt/oracle/product/9ir2/dbs/pfile_20100202.ora';
去掉log_archive_dest

新增
*.log_archive_dest_1='LOCATION=/opt/oracle/archive'
*.log_archive_dest_state_1=enable
*.log_archive_dest_2='SERVICE=standby LGWR'
*.log_archive_dest_state_2=enable

5.1 編輯Standby引數檔案
修改standby的pfile_20100202.ora 引數檔案,即從Primay傳過來的
加入以下行
*.fal_server='dupdb'
*.fal_client='standby'
#DB_FILE_NAME_CONVERT=('/opt/oracle/oradata/dupdb','/opt/oracle/oradata/dupdb') 如果路徑不一致才用
#LOG_FILE_NAME_CONVERT=('/opt/oracle/oradata/dupdb','/opt/oracle/oradata/dupdb')
*.standby_file_management=auto
*.standby_archive_dest='/opt/oracle/archive'
#LOG_ARCHIVE_DEST_1='LOCATION=/opt/oracle/archive'
#LOG_ARCHIVE_DEST_STATE_1=ENABLE

6 啟動例項

#以修改後的引數檔案 startup Primary Instance;(Primary)

#恢復Spfile:
Create spfile from pfile='/opt/oracle/product/9ir2/dbs/pfile_20100202.ora';
startup;

#以修改後的引數檔案Start Standby Instance (Standby)
Create spfile from pfile='/opt/oracle/product/9ir2/dbs/pfile_20100202.ora';
startup nomount

不開啟控制檔案,控制檔案透過Duplicate 來傳輸

7 Duplicate Standby

rman target / catalog auxiliary
RUN
{
# If desired, issue a SET command to terminate recovery at a specified point.
# SET UNTIL SCN 143508;
DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK
DORECOVER;
}

#NOFILENAMECHECK 表示主備的資料檔案路徑一致

8 Duplicate 完成後Standby只處於正常的Mount狀態.應開啟Recover

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

RMAN學習筆記_ Duplicate建立DataGuard

相關文章