ORA-00317: file type 0 in header is not log file的解决

oracle@kzsun490b ~$oerr ora 317
00317, 00000, “file type %s in header is not log file”
// *Cause: This is not an archived log file.
// *Action: Find the correct file and try again.

前段时间配置了两台SUN490机器的STANDBY,为了避免主数据库(已经运行的生产机)重起,没有使用ORACLE的recover managed模式,而是采用手工的RECOVER的方式实现,运行1个月安全，今天中午查看日志发现报ORA-00317file type 0 in header is not log file的错误:

Errors in file /opt/oracle/admin/MEDIA/udump/media_ora_24485.trc:
ORA-00317: file type 0 in header is not log file
ORA-00334: archived log: ‘/opt/oracle/admin/MEDIA/arch/arch_1_953.arc’
ORA-317 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT …
Wed Apr 19 15:40:03 2006
ALTER DATABASE RECOVER CANCEL
Media Recovery Cancelled
Completed: ALTER DATABASE RECOVER CANCEL

查看PRIMARY跟STANDBY上’/opt/oracle/admin/MEDIA/arch/arch_1_953.arc’文件确实都存在,而且大小一样,但是这个arch log在standby上死活不认,查看metalink跟asktom没有什么好的解决办法,后来猜想应该是rsync同步文件也许有问题,重新删除standby机器上的该文件,重新rsync,再执行ALTER DATABASE RECOVER automatic standby database .问题解决:

ALTER DATABASE RECOVER automatic standby database
Media Recovery Start
Media Recovery Log
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_953.arc
Wed Apr 19 16:03:21 2006
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_954.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_955.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_956.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_957.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_958.arc
Wed Apr 19 16:04:04 2006
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_959.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_960.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_961.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_962.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_963.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_964.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_965.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_966.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_967.arc
Wed Apr 19 16:05:20 2006
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_968.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_969.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_970.arc
Media Recovery Log /opt/oracle/admin/MEDIA/arch/arch_1_971.arc

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28419/viewspace-604017/，如需转载，请注明出处，否则将追究法律责任。