--实施DG前的准备工作
--开启数据库logging及数据库archivelog
--开启数据库logging
SQL> alter database force logging;
--检查数据库是否开启archivelog
SQL> archive log list;
--如果数据库未开启archivelog，则要开启archivelog
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
--检查数据库是否开启archivelog
SQL> archive log list;
--修改或新增listener.ora 和tnsnames.ora（或者用GUI工具配置）
--注意：listener.ora 中新增的部分在括号内而非括号外
--primary端：
--listener.ora：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /export/home/oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dgdb1)
(ORACLE_HOME = /export/home/oracle/product/10.2.0)
(SID_NAME = dgdb1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
--tnsnames.ora
dgdb1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.94.198)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dgdb1)
)
)
dgdb1_s =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.94.199)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dgdb1)
)
)
--standby端：
--listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /export/home/oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dgdb1)
(ORACLE_HOME = /export/home/oracle/product/10.2.0)
(SID_NAME = dgdb1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
--tnsnames.ora
dgdb1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.94.198)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dgdb1)
)
)
dgdb1_s =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.94.199)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dgdb1)
)
)
--具体实施DG的步骤：
--在primary上生成pfile，并修改添加相应参数，生成standby需要的pfile
--primary端：
oracle$>sqlplus / as sysdba
SQL> CREATE PFILE='/export/home/oracle/standby.ora' FROM SPFILE;
--编辑生成的pfile文件('/export/home/oracle/standby.ora')，添加如下参数：
*.db_unique_name='dgdb_s'
*.fal_server='dgdb1'
*.fal_client='dgdb_s'
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(dgdb1,dgdb_s)'
*.log_archive_dest_1='LOCATION=/export/home/oracle/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dgdb_s'
*.LOG_ARCHIVE_DEST_2='SERVICE=dgdb1 LGWR ASYNC=40960 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=dgdb1'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.standby_archive_dest='/export/home/oracle/archive'
*.standby_file_management='AUTO'
--修改完后拷贝到standby端
Oracle$Scp /export/home/oracle/standby.ora oracle@192.168.94.199:/export/home/oracle/
--在standby端使用pfile启动实例
--在primary端用命令创建数据库密码文件，并接拷贝至standby端相同路径下（如已存在，可直接拷贝）
--primary端手工创建数据库密码文件
Oracle$orapwd file=... password=...
--primary端拷贝数据库密码文件至standby端
Oracle$Scp /e