dataguard的一个问题:应用日志出错,
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 1413759 change 124620401774 time 06/12/2009 18:57:46
ORA-00334: archived log: '/data/oracle9/arch/1_7966.dbf'
Recovery interrupted.
Recovered data files restored to a consistent state at change 124620401767.
但在备份机上执行
RMAN> backup validate archivelog from sequence 7966 until sequence 7968;
Starting backup at 16-JUN-09
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=17 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=7966 recid=6 stamp=689620475
input archive log thread=1 sequence=7967 recid=7 stamp=689620647
input archive log thread=1 sequence=7968 recid=8 stamp=689620680
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:36
Finished backup at 16-JUN-09
可以看出并没有坏块!
不知道各位有什么好的意见
为什么验证是否有坏块时显示正常,应用的时候说有坏块?
linux as 4 oracle 9i
[ 本帖最后由 microsoft_fly 于 2009-6-16 14:59 编辑 ]
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 1413759 change 124620401774 time 06/12/2009 18:57:46
ORA-00334: archived log: '/data/oracle9/arch/1_7966.dbf'
Recovery interrupted.
Recovered data files restored to a consistent state at change 124620401767.
但在备份机上执行
RMAN> backup validate archivelog from sequence 7966 until sequence 7968;
Starting backup at 16-JUN-09
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=17 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=7966 recid=6 stamp=689620475
input archive log thread=1 sequence=7967 recid=7 stamp=689620647
input archive log thread=1 sequence=7968 recid=8 stamp=689620680
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:36
Finished backup at 16-JUN-09
可以看出并没有坏块!
不知道各位有什么好的意见
为什么验证是否有坏块时显示正常,应用的时候说有坏块?
linux as 4 oracle 9i
[ 本帖最后由 microsoft_fly 于 2009-6-16 14:59 编辑 ]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/751051/viewspace-731742/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/751051/viewspace-731742/