如果搭建dg 先安装主库database 并建库,同时建备库database 软件,不需要建库。
1 主库打开归档功能
启动到mount状态下,打开归档功能
alter database archivelog;
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 17
Next log sequence to archive 19
Current log sequence 19
# 检查已经打开归档功能
2 配置主库监听和tnsnames文件
# listener.ora Network Configuration File: /u01/oracle/11g/network/admin/listene
r.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/oracle/11g)
(SID_NAME = orcl)
)
(SID_DESC =
(GLOBAL_DBNAME = porcl)
(ORACLE_HOME = /u01/oracle/11g)
(SID_NAME = orcl)
)
(SID_DESC =
(GLOBAL_DBNAME = porcl_DGMGRL)
(ORACLE_HOME = /u01/oracle/11g)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dghost)(PORT = 1521))
)
ADR_BASE_LISTENER = /u01/oracle
[oracle@dghost root]$ cat /u01/oracle/11g/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/oracle/11g/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
SORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dgstandby)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = sorcl)
)
)
PORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dghost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = porcl)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dghost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.dghost)
)
)
备库也配置监听
注意主库和备库配置完监听要用tnsping测试都能ping通
[oracle@dghost root]$ tnsping porcl
TNS Ping Utility for Linux: Version