您好,欢迎访问一九零五行业门户网

Oracle 10g物理DG详细配置方法及步骤

--测试环境: os:redhat linux(64) primary: ip:192.168.94.198 sid:dgdb1 hostname:dg1 db_unique_name
--测试环境:
    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 =
        (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)
      )
    )
其它类似信息

推荐信息