暂无图片
The controlfile header block returned by the OS has a sequence number that is too old
我来答
分享
暂无图片 匿名用户
The controlfile header block returned by the OS has a sequence number that is too old

oracle rac 11g频繁报以下错误,关闭数据库实例后又自动重启。请教一下各位大神,麻烦帮忙看下该怎么解决。

Tue Apr 23 03:02:53 2024
********************* ATTENTION: ********************
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.
*****************************************************
USER (ospid: 362960): terminating the instance
Tue Apr 23 03:02:55 2024
System state dump requested by (instance=1, osid=362960), summary=[abnormal instance termination].
System State dumped to trace file /u01/app/oracle/diag/rdbms/ora11g/ORA11G1/trace/ORA11G1_diag_214998_20240423030255.trc
Tue Apr 23 03:02:56 2024
ORA-1092 : opitsk aborting process
Instance terminated by USER, pid = 362960
Tue Apr 23 03:03:07 2024
Starting ORACLE instance (normal)
************************ Large Pages Information *******************
Per process system memlock (soft) limit = UNLIMITED

Total Shared Global Region in Large Pages = 120 GB (100%)

Large Pages used by this instance: 61441 (120 GB)
Large Pages unused system wide = 59 (118 MB)
Large Pages configured system wide = 61500 (120 GB)
Large Page size = 2048 KB
********************************************************************

我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
周伟

控制文件损坏了,不要去启动数据库。需要重建数据库,然后resetlog方式重启数据库。

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏