dg容灾-5

上一篇 / 下一篇 2011-06-07 16:05:34 / 个人分类：数据库

220-IPv6 connections are also welcome on this server.
220 You will be disconnected after 15 minutes of inactivity.
Name (10.10.4.14:root): oracle
331 User oracle OK. Password required
Password:
230-User oracle has group access to: dba oinstall
230 OK. Current directory is /opt/oracle
Remote system type is UNIX.
Using binary mode to transfer files.
ftp> cd ~/product/11g/dbs
250 OK. Current directory is /opt/oracle/product/11g/dbs
ftp> ls
ftp> asc
200 TYPE is now ASCII
ftp> get initmmsgdb.ora
ftp> bin
ftp> get orapwmmsgdb
ftp> by

7、修改standby数据库参数文件
*.DB_UNIQUE_NAME=uqn_standby
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(uqn_primary,uqn_standby)'
*.LOG_ARCHIVE_DEST_2='SERVICE=primary ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=uqn_primary'
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.LOG_ARCHIVE_MAX_PROCESSES=30

#--------配置standby角色的参数用于角色转换
*.FAL_SERVER=primary
*.FAL_CLIENT=standby
*.STANDBY_FILE_MANAGEMENT=AUTO

8、修改listener及tns信息
配置primary数据库和standby数据库的listener及net service names(方式多样，不详述)
SID_LIST_LISTENER =
(SID_LIST =
   (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/11g)
      (PROGRAM = extproc)
)
    (SID_DESC =
        (GLOBAL_DBNAME = mmsgdb)
        (ORACLE_HOME = /opt/oracle/product/11g)
        (SID_NAME = mmsgdb)
     )
)