数据库版本10.2.0.4 windows2008r2
最近频繁宕机,事发时间都是下班以后,凌晨,该时间段也没有备份或是其他定时任务。保存如下
The controlfile header block returned by the OS
has a sequence number that is too old.
The controlfile might be corrupted.
PLEASE DO NOT ATTEMPT TO START UP THE INSTANCE
without following the steps below.
RE-STARTING THE INSTANCE CAN CAUSE SERIOUS DAMAGE
TO THE DATABASE, if the controlfile is truly corrupted.
In order to re-start the instance safely,
please do the following:
(1) Save all copies of the controlfile for later
analysis and contact your OS vendor and Oracle support.
(2) Mount the instance and issue:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
(3) Unmount the instance.
(4) Use the script in the trace file to
RE-CREATE THE CONTROLFILE and open the database.
网上看了很多说是io问题,官方文档也看了,也是这么说的,隐藏参数没敢改,今天去现场检查下存储看看,
不知到还有没有别的处理思路。
墨值悬赏

评论
