Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

121

积分

0

好友

2

主题
1#
发表于 2012-3-31 10:14:18 | 查看: 5565| 回复: 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
2#
发表于 2012-3-31 10:31:02
请将 A备库的 alert.log 和 RSF、ARCH进程的trace文件压缩打包后上传

回复 只看该作者 道具 举报

3#
发表于 2012-4-4 23:16:40
刚重启A备库,相关日志如附件。
RSF、ARCH进程的trace文件在备库重启后无相关trace产生。

alert_nodea.log.txt

1.74 KB, 下载次数: 801

nodea_mrp0_1864.trc.txt

3.53 KB, 下载次数: 775

回复 只看该作者 道具 举报

4#
发表于 2012-4-5 19:12:03
FOR STANDBY A :

Media Recovery Waiting for thread 1 sequence 22195
Fetching gap sequence in thread 1, gap sequence 22195-22294
Wed Apr 04 22:50:20 2012
Completed: alter database recover managed standby database disconnect from session
Wed Apr 04 22:53:23 2012
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 22195-22294
DBID 1342406147 branch 766797318
FAL[client]: All defined FAL servers have been attempted.


FAL_SERVER=usaserver
FAL_CLIENT='usaserver2','usaserver3'


尝试修改 FAL_SERVER='usaserver','usaserver3'
                 FAL_CLIENT='usaserver2'

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-24 10:46 , Processed in 0.068418 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569