做dg的两台机器,都重启了,现在不能够同步:
在主机上执行:
select sequence#,applied,first_time,next_time from v$archived_log order by sequence#;
SEQUENCE# APPLIED FIRST_TIM NEXT_TIME
---------- --------- --------- ---------
4114 NO 12-AUG-14 12-AUG-14
4115 NO 12-AUG-14 12-AUG-14
4115 NO 12-AUG-14 12-AUG-14
4116 NO 12-AUG-14 12-AUG-14
4116 NO 12-AUG-14 12-AUG-14
4117 NO 12-AUG-14 12-AUG-14
4117 NO 12-AUG-14 12-AUG-14
4118 NO 12-AUG-14 12-AUG-14
4118 NO 12-AUG-14 12-AUG-14
在主机上执行:
archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /RECO/cqsj/arch
Oldest online log sequence 4117
Next log sequence to archive 4119
Current log sequence 4119
在备机上执行:
archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /RECO/cqsj/arch
Oldest online log sequence 4118
Next log sequence to archive 0
Current log sequence 4119
------解决方案--------------------
REGISTRAR 的值是什么?
standby的apply进程是否打开了
------解决方案--------------------
可能和这个没关系。如果fal设置有问题,日志不会传输到备库
而且没记错的话,fal_client参数在10g后的版本已经不需要了
Data Guard重启后,需要时间来查找、传输日志、应用,可能有几分钟时间会处于不同步的状态