请问一下各位有关 dataguard的maximize protection资料同步问题
时间:2011-09-06
来源:互联网
请问一下各位有关 dataguard的maximize protection资料同步问题
现在发现如commit完后,立即 shutdown abort,发现 standby db会有少资料,有办法可解决吗?
db : 10.2.0.4
os : redhat 4.8
测试结果如下:
-- standby db 如停止运作,primary db 会卡在 commit
-- 于 primary db 上 insert 一笔资料,commit,再马上 shutdown abort,发现 standby db 会有少资料
-- 于 primary db 上 insert 一笔资料,commit,等一些时间,大约1分钟内,在standby db 上查寻,发现资料已有同步过来了
(于 standby db : sora10g 操作如下)
SQL> alter database recover managed standby database cancel;
SQL> ALTER DATABASE OPEN READ ONLY;
SQL> select * from x01;
SQL> alter database recover managed standby database using current logfile disconnect from session;
SQL> SELECT PROTECTION_MODE, PROTECTION_LEVEL FROM V$DATABASE;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM PROTECTION MAXIMUM PROTECTION
primary db : sora10g
*.db_name='ora10g'
*.db_unique_name='sora10g'
*.fal_client='sora10g'
*.fal_server='ora10g'
*.log_archive_config='DG_CONFIG=(sora10g,ora10g)'
*.log_archive_dest_1='LOCATION=/app/oradata/ora10g/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=sora10g'
*.log_archive_dest_2='SERVICE=ora10g LGWR SYNC AFFIRM NET_TIMEOUT=5 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora10g'
standby db : ora10g
*.db_name='ora10g'
*.fal_client='ora10g'
*.fal_server='sora10g'
*.job_queue_processes=10
*.log_archive_config='DG_CONFIG=(ora10g,sora10g)'
*.log_archive_dest_1='LOCATION=/app/oradata/ora10g/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ora10g'
*.log_archive_dest_2='SERVICE=sora10g LGWR SYNC AFFIRM NET_TIMEOUT=5 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=sora10g'
现在发现如commit完后,立即 shutdown abort,发现 standby db会有少资料,有办法可解决吗?
db : 10.2.0.4
os : redhat 4.8
测试结果如下:
-- standby db 如停止运作,primary db 会卡在 commit
-- 于 primary db 上 insert 一笔资料,commit,再马上 shutdown abort,发现 standby db 会有少资料
-- 于 primary db 上 insert 一笔资料,commit,等一些时间,大约1分钟内,在standby db 上查寻,发现资料已有同步过来了
(于 standby db : sora10g 操作如下)
SQL> alter database recover managed standby database cancel;
SQL> ALTER DATABASE OPEN READ ONLY;
SQL> select * from x01;
SQL> alter database recover managed standby database using current logfile disconnect from session;
SQL> SELECT PROTECTION_MODE, PROTECTION_LEVEL FROM V$DATABASE;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM PROTECTION MAXIMUM PROTECTION
primary db : sora10g
*.db_name='ora10g'
*.db_unique_name='sora10g'
*.fal_client='sora10g'
*.fal_server='ora10g'
*.log_archive_config='DG_CONFIG=(sora10g,ora10g)'
*.log_archive_dest_1='LOCATION=/app/oradata/ora10g/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=sora10g'
*.log_archive_dest_2='SERVICE=ora10g LGWR SYNC AFFIRM NET_TIMEOUT=5 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora10g'
standby db : ora10g
*.db_name='ora10g'
*.fal_client='ora10g'
*.fal_server='sora10g'
*.job_queue_processes=10
*.log_archive_config='DG_CONFIG=(ora10g,sora10g)'
*.log_archive_dest_1='LOCATION=/app/oradata/ora10g/arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=ora10g'
*.log_archive_dest_2='SERVICE=sora10g LGWR SYNC AFFIRM NET_TIMEOUT=5 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=sora10g'
作者: binhu 发布时间: 2011-09-06
有点儿延时 应该算是正常的我觉得
作者: iori809 发布时间: 2011-09-06
但文件是说没有资料损失,如这时 primary db是整台挂了,那standby db就会少资料了
作者: binhu 发布时间: 2011-09-06
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28