使用duplicate搭建oracle 11.2.0.4.0数据库active dataguard (ADG)

1：配置情况（主库需要建立实例，从库只需要安装软件）

主库

Centos6.7

Oracle 11.2.0.4.0

IP:192.168.1.155  sid:orcl

 

备库

Centos6.7

Oracle 11.2.0.4.0软件

IP：192.168.1.156

 

2：关闭防火墙(两边都需要操作)

  lsnrctl iptables stop

  chkconfig iptables off

 

3:配置监听

主库

修改listener.ora

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = dg1)

      (ORACLE_HOME = /u01/oracle/11g)

      (SID_NAME = orcl)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))

      )

    )

  )

  

修改tnsnames.ora

dg1 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.155)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = dg1)

    )

  )

 

dg2 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.156)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = dg2)

    )

  )

 

for_db =

 (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.155)(PORT = 1521))

  )

备库

修改listener.ora

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = dg2)

      (ORACLE_HOME = /u01/oracle/11g)

      (SID_NAME = orcl)

    )

  )

 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = dg2)(PORT = 1521))

      )

    )

  )

修改tnsnames.ora

dg1 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.155)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = dg1)

    )

  )

 

dg2 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.156)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = dg2)

    )

  )

 

for_db =

 (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.156)(PORT = 1521))

Note:配置完，tnsping dg1，tnsping dg2出现下面信息，表示互通。

Attem