不可轻言放弃,否则对不起自己!
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)
)
)
收藏
举报
TAG: