C/C++教程

又一例存储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-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

Thu Jul 22 16:08:49 EAT 2021

LOGSTDBY: Validating controlfile with logical metadata

Thu Jul 22 16:08:49 EAT 2021

ORACLE Instance xff1 (pid = 11) - Error 600 encountered while recovering transaction (1, 43).

Thu Jul 22 16:08:49 EAT 2021

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

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

Thu Jul 22 16:08:49 EAT 2021

Trace dumping is performing id=[cdmp_20210722160849]

Thu Jul 22 16:08:49 EAT 2021

LOGSTDBY: Validation complete

Completed: alter database open

该问题是由于undo异常,对undo进行处理,数据库无明显报错,安排导出数据

  • undo异常总结和恢复思路
  • ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], []
  • 记录一次比较棘手数据库恢复要点
  • 在数据库open过程中常遇到ORA-01555汇总
  • 创建控制文件遭遇ORA-600 kccscf_1
  • 10g数据库遭遇ORA-600 16703
  • ora-600 2662和ora-600 kclchkblk_4恢复
  • 记录一次ORA-00600[kdxlin:psno out of range]/ORA-00600[3020]/ORA-00600[4000]/ORA-00600[4193]的数据库恢复
  • tab$异常被处理之后报ORA-600 13304故障处理
  • 硬件故障导致ORA-600 2662错误处理
  • 数据库open过程遭遇ORA-1555对应sql语句补充
  • Oracle Recovery Tools恢复—ORA-00704 ORA-01555故障
这篇关于又一例存储cache丢失oracle数据库恢复---惜分飞的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!