standby问题，有兴趣来看看

显示全部楼层 · 2008-1-2 17:35:53

physical standby database
通过脚本清传过来的arch文件，从V$archived_log视图中completion_time判断是否需要清除。
前些日子发现无法清除从Feb 28号23点35分complete的归档文件，
原因是select SEQUENCE#,COMPLETION_TIME from v$archived_log where sequence#=41226;这条语句在standby库上无法执行成功，报错ERROR at line 1:
ORA-01861: literal does not match format string
语句中只要有completion_time字段，就无法正常查询成功，应该是这条记录上的该字段的值出现了问题。比如：select SEQUENCE#,FIRST_TIME from v$archived_log where sequence#=41226；是能够成功查询的。
检查standby库的alertlog，发现如下信息：
Media Recovery Waiting for thread 1 seq# 41226 (in transit)
Wed Feb 28 23:35:00 2007
ARC3: Evaluating archive log 11 thread 1 sequence 41226
ARC3: Beginning to archive log 11 thread 1 sequence 41226
Creating archive destination LOG_ARCHIVE_DEST_1: '/opt/oracle/arch/ORCL/1_41226.dbf'
Wed Feb 28 23:35:00 2007
RFS: Successfully opened standby logfile 10: '/opt/oracle/db02/oradata/ORCL/redo10.log'
Wed Feb 28 23:35:05 2007
ARC3: Archive log thread 1 sequence 41226 available 02/29/2007 00:05:05
ARC3: Completed archivinglog 11 thread 1 sequence 41226
Wed Feb 28 23:35:10 2007
Media Recovery Delayed for thread 1 seq# 41226 until 02/29/2007 00:05:05
Media Recovery Log /opt/oracle/arch/ORCL/1_41226.dbf
估计上面黑体字段为问题发生的原因。07年2月份是没有29号的，怎么standby会计算出来completion_time应该填写02/29/2007 00:05:05呢？各位有没有遇到过类似问题？
primary database配置：log_archive_dest_2='service=standbyLGWR ASYNC=20480 NOAFFIRM DELAY=30 REOPEN=3'
Media Recovery Delayed 30mins[B]Media Recovery Delayed for thread 1 seq# 41226 until 02/29/2007 00:05:05[/B]

千问 · 2008-1-2 17:35:53

到standby上看一下最后应用到哪个日志，可能中间断掉了，另外fal_server,fal_client有没有设置？
也有可能是遇到了bug，呵呵