- 最后登录
- 2014-3-8
- 在线时间
- 38 小时
- 威望
- 121
- 金钱
- 945
- 注册时间
- 2011-10-26
- 阅读权限
- 50
- 帖子
- 38
- 精华
- 1
- 积分
- 121
- UID
- 70
|
1#
发表于 2012-3-31 10:14:18
|
查看: 5506 |
回复: 3
Windows 2008 + Oracle 10.2.0.4
1主库带2个逻辑备库的DG,其中A备库与主库的网络出现问题,但与B备库的网络正常,要如何设置才能让A备库从B备库中取日志?
目前设置参数如下:
主库:
DB_NAME=usaserver
DB_UNIQUE_NAME=usaserver
LOG_ARCHIVE_CONFIG='DG_CONFIG=(usaserver,usaserver2,usaserver3)'
LOG_ARCHIVE_DEST_1 = 'LOCATION=D:\oracle\product\10.2.0\oradata\archive\arc\
VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=usaserver'
LOG_ARCHIVE_DEST_2='SERVICE=usaserver2 LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=usaserver2'
LOG_ARCHIVE_DEST_3= 'LOCATION=D:\oracle\product\10.2.0\oradata\archive\std\ VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=usaserver'
LOG_ARCHIVE_DEST_4='SERVICE=usaserver3 LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=usaserver3 reopen=600'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=DEFER
LOG_ARCHIVE_DEST_STATE_3=ENABLE
LOG_ARCHIVE_DEST_STATE_4=ENABLE
FAL_SERVER='usaserver2','usaserver3'
FAL_CLIENT=usaserver
STANDBY_FILE_MANAGEMENT=AUTO
A备库:
DB_NAME=usaserver
DB_UNIQUE_NAME=usaserver2
LOG_ARCHIVE_CONFIG='DG_CONFIG=(usaserver,usaserver2,usaserver3)'
LOG_ARCHIVE_DEST_1 = 'LOCATION=D:\oracle\product\10.2.0\oradata\archive\arc\ VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=usaserver2'
LOG_ARCHIVE_DEST_2='SERVICE=usaserver LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=usaserver'
LOG_ARCHIVE_DEST_3= 'LOCATION=D:\oracle\product\10.2.0\oradata\archive\std\ VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=usaserver2'
LOG_ARCHIVE_DEST_4='SERVICE=usaserver3 LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=usaserver3 reopen=600'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_DEST_STATE_3=ENABLE
LOG_ARCHIVE_DEST_STATE_4=ENABLE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
FAL_SERVER=usaserver
FAL_CLIENT='usaserver2','usaserver3'
STANDBY_FILE_MANAGEMENT=AUTO
B备库:
*.db_name='usaserver'
*.DB_UNIQUE_NAME='usaserver3'
*.fal_client='usaserver3'
*.fal_server='usaserver','usaserver2'
*.log_archive_config='DG_CONFIG=(usaserver,usaserver2,usaserver3)'
*.LOG_ARCHIVE_DEST_1='LOCATION=D:\oracle\product\10.2.0\oradata\archive\arc\ VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=usaserver3'
*.LOG_ARCHIVE_DEST_2='SERVICE=usaserver LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=usaserver'
*.LOG_ARCHIVE_DEST_3='LOCATION=D:\oracle\product\10.2.0\oradata\archive\std\ VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=usaserver3'
*.LOG_ARCHIVE_DEST_4='SERVICE=usaserver2 LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=usaserver2 REOPEN=600'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_dest_state_3='ENABLE'
*.log_archive_dest_state_4='ENABLE'
STANDBY_FILE_MANAGEMENT=AUTO |
|