又一例存储cache丢失oracle数据库恢复---xifenfei

2021/7/23 2:06:13

编程Tag： cache ora 2021 22 --- eat Jul Thu xifenfei

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

联系：手机/微信(+86 13429648788) QQ(107644445) QQ咨询惜分飞

标题：又一例存储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数据库恢复---xifenfei的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！

又一例存储cache丢失oracle数据库恢复---xifenfei

相关编程文章