| 項目 | 主節點 | 備節點 |
|---|---|---|
| 主機名 | a1 | a2 |
| IP | 192.168.1.10 | 192.168.1.20 |
| Net Service Name | a1 | a2 |
| SID | a1 | a2 |
| DB_UNIQUE_NAME | a1 | a2 |
注意:主節點建立資料庫 a1,備節點僅安裝 Oracle 軟體,不建立資料庫。
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))
)
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))
)
ALTER DATABASE FORCE LOGGING;
ARCHIVE LOG LIST;
-- 在 MOUNT 狀態下
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;
ARCHIVE LOG LIST;
orapwd file='/u01/app/oracle/product/11.2.0/db_1/dbs/orapwa1.ora' password=xyc entries=10
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 規劃,並採用多路徑多重化。