dg容灾-6

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.4.14)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )
上面为primary数据库的listener信息，standby数据库同理。其中蓝色部分为新增信息，红色部分为primary数据库ip地址。

配置primary数据库和standby数据库的tnsnames.ora文件，修改成如下信息
PRIMARY =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.4.14)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mmsgdb)
    )
  )
 
STANDBY =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.4.17)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mmsgdb)
    )
  )

完成之后重启primary数据库和standby数据库的listener，并测试监听:
oracle@mmsg:~/product/11g/network/admin> lsnrctl stop
oracle@mmsg:~/product/11g/network/admin> lsnrctl start
oracle@mmsg:~/product/11g/network/admin> tnsping primary 10
oracle@mmsg:~/product/11g/network/admin> tnsping standby 10

执行ping操作，primary和standby互ping一下ip地址，如果能ping通，则继续执行下面的操作，如果ping不通，请检查配置。

9、 启动standby数据库
oracle@mmsg1:~/product/11g/dbs> sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on 星期二 8月 10 14:47:21 2010

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

已连接到空闲例程。

SQL> create spfile from pfile='/opt/oracle/product/11g/dbs/initmmsgdb.ora';