萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 資料庫 >> Oracle 教學

Oracle Data Guard 物理備庫建置完整教學

環境規劃

項目主節點備節點
主機名a1a2
IP192.168.1.10192.168.1.20
Net Service Namea1a2
SIDa1a2
DB_UNIQUE_NAMEa1a2

注意:主節點建立資料庫 a1,備節點僅安裝 Oracle 軟體,不建立資料庫。

1. 設定 listener.ora

主節點

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = a1)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = a1)
    )
  )
LISTENER =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.1.10)(PORT = 1521))
    (ADDRESS = (PROTOCOL = ipc)(KEY = PNPKEY))
  )

備節點

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = a1)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = a1)
    )
  )
LISTENER =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.1.20)(PORT = 1521))
    (ADDRESS = (PROTOCOL = ipc)(KEY = PNPKEY))
  )

2. 設定 tnsnames.ora (主備相同)

a1 =
  (DESCRIPTION =
    (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.10)(PORT = 1521)))
    (CONNECT_DATA = (SERVICE_NAME = a1))
  )
a2 =
  (DESCRIPTION =
    (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.20)(PORT = 1521)))
    (CONNECT_DATA = (SERVICE_NAME = a2))
  )

3. 啟用主庫歸檔模式

ALTER DATABASE FORCE LOGGING;
ARCHIVE LOG LIST;

-- 在 MOUNT 狀態下
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
ARCHIVE LOG LIST;

4. 建立密碼文件

orapwd file='/u01/app/oracle/product/11.2.0/db_1/dbs/orapwa1.ora' password=xyc entries=10

5. 建立 Standby Redo Log

ALTER DATABASE ADD STANDBY LOGFILE
  GROUP 4 ('/u01/app/oracle/oradata/a1/standby_redo04a.log',
           '/u01/app/oracle/oradata/a1/standby_redo04b.log') SIZE 50M,
  GROUP 5 ('/u01/app/oracle/oradata/a1/standby_redo05a.log',
           '/u01/app/oracle/oradata/a1/standby_redo05b.log') SIZE 50M,
  GROUP 6 ('/u01/app/oracle/oradata/a1/standby_redo06a.log',
           '/u01/app/oracle/oradata/a1/standby_redo06b.log') SIZE 50M,
  GROUP 7 ('/u01/app/oracle/oradata/a1/standby_redo07a.log',
           '/u01/app/oracle/oradata/a1/standby_redo07b.log') SIZE 50M;

建議:Standby Redo Log 群組數與大小宜參考 Online Redo Log 規劃,並採用多路徑多重化。

copyright © 萬盛學電腦網 all rights reserved