又一例存储cache丢失oracle数据库恢复---惜分飞

本文主要是介绍又一例存储cache丢失oracle数据库恢复---惜分飞，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

10.2.0.5 hp unix rac,由于存储掉电导致cache丢失,数据库无法正常启动,客户要求我们介入处理
数据库mount报ORA-00600 kccpb_sanity_check_2错误

Thu Jul 22 14:52:06 EAT 2021

alter database mount

Thu Jul 22 14:52:10 EAT 2021

Errors in file /oracle/admin/xff/udump/xff1_ora_4611.trc:

ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [4697564], [4697561], [0x000000000], [], [], [], []

该错误是由于控制文件损坏,尝试重建控制文件报ORA-01163,ORA-01517

'/dev/oradata/rxff_ls94'

CHARACTER SET ZHS16GBK

WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command

Default Temporary Tablespace will be necessary for a locally managed database in future release

Thu Jul 22 14:54:02 EAT 2021

Errors in file /oracle/admin/xff/udump/xff1_ora_7283.trc:

ORA-01163: SIZE clause indicates 262144 (blocks), but should match header 204800

ORA-01517: log member: '/dev/oradata/rxff_redo1_1'

ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE "xff" NORESETLOGS NOARCHIVELOG

由于redo大小错误导致该问题,设置正确的redo大小继续重建

'/dev/oradata/rxff_ls94'

CHARACTER SET ZHS16GBK

WARNING: Default Temporary Tablespace not specified in CREATE DATABASE command

Default Temporary Tablespace will be necessary for a locally managed database in future release

Thu Jul 22 15:01:00 EAT 2021

Errors in file /oracle/admin/xff/udump/xff1_ora_14737.trc:

ORA-00600: internal error code, arguments: [kccsga_update_ckpt_4], [32], [8], [], [], [], [], []

Thu Jul 22 15:01:01 EAT 2021

Errors in file /oracle/admin/xff/udump/xff1_ora_14737.trc:

ORA-00600: internal error code, arguments: [kccsga_update_ckpt_4], [32], [8], [], [], [], [], []

ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE "xff" NORESETLOGS NOARCHIVELOG

报ORA-00600 kccsga_update_ckpt_4错误,导致控制文件失败,处理该错误之后,重建控制文件成功,分析文件头信息和redo信息,确认只能强制库,尝试强制open库

Thu Jul 22 16:02:05 EAT 2021

SMON: enabling cache recovery

Thu Jul 22 16:02:05 EAT 2021

ORA-01555 caused by SQL statement below (SQL ID: 4krwuz0ctqxdt, SCN: 0x0002.cdad19ed):

Thu Jul 22 16:02:05 EAT 2021

select ctime, mtime, stime from obj$ where obj# = :1

Thu Jul 22 16:02:05 EAT 2021

Errors in file /oracle/admin/xff/udump/xff1_ora_23219.trc:

ORA-00704: bootstrap process failure

ORA-00604: error occurred at recursive SQL level 1

ORA-01555: snapshot too old: rollback segment number 19 with name "_SYSSMU19$" too small

Error 704 happened during db open, shutting down database

USER: terminating instance due to error 704

Instance terminated by USER, pid = 23219

ORA-1092 signalled during: alter database open resetlogs...

这个问题比较常见:ORA-00704 ORA-00604 ORA-01555,参考类似文章:
在数据库open过程中常遇到ORA-01555汇总
数据库open过程遭遇ORA-1555对应sql语句补充
数据库open成功但是报ORA-00600 4137

Database Characterset is ZHS16GBK

Opening with internal Resource Manager plan

Thu Jul 22 16:08:48 EAT 2021

Errors in file /oracle/admin/xff/bdump/xff1_smon_27436.trc:

ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

QMNC started with pid=30, OS id=997