Oracle10g物理DG详细配置方法及步骤
--测试环境：
    OS：Redhat linux(64)
    Primary：
    IP：192.168.94.198
    SID：dgdb1
    Hostname：dg1
    DB_UNIQUE_NAME：dgdb1
    Database：10.2.0.1(64)
 
    Standby：
    IP：192.168.94.199
    SID：dgdb1
    Hostname：dg2
    DB_UNIQUE_NAME：dgdb1_s
    Database：10.2.0.1(64)


--实施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;


   --创建相应目录（根据具体情况，primary和standby端要一致）
       --Standby：
          mkdir –p /export/home/oracle/product/10.2.0/oradata/dgdb1
          mkdir –p /export/home/oracle/product/10.2.0/admin/dgdb1/adump
          mkdir –p /export/home/oracle/product/10.2.0/admin/dgdb1/bdump
          mkdir –p /export/home/oracle/product/10.2.0/admin/dgdb1/cdump
          mkdir –p /export/home/oracle/product/10.2.0/admin/dgdb1/udump
          mkdir –p /export/home/oracle/product/10.2.0/admin/dgdb1/dpdump
          mkdir –p /export/home/oracle/product/10.2.0/admin/dgdb1/pfile 
          mkdir –p /export/home/oracle/archive
          mkdir -p /export/home/oracle/bak
       --primary：
          mkdir –p /export/home/oracle/archive
          mkdir -p /export/home/oracle/bak


--修改或新增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 =
    &n