ORA-00316 ORA-00312故障处理----惜分飞

标题：ORA-00316 ORA-00312故障处理

作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

数据库启动报ORA-00316,ORA-00312,无法正常启动

---

通过Oracle数据库异常恢复检查脚本(Oracle Database Recovery Check)分析,确认是当前redo损坏

---

对于这种情况,只能是屏蔽一致性,强制拉库,结果在拉库过程中报ORA-600 2662错误

---

这个错误相对比较简单,修改下相关scn即可,数据库open成功

 

SQL> startup nomount pfile='/tmp/pfile'

ORACLE instance started.

 

Total System Global Area 3.8482E+10 bytes

Fixed Size                  2261368 bytes

Variable Size            8187285128 bytes

Database Buffers         3.0199E+10 bytes

Redo Buffers               93593600 bytes

SQL> CREATE CONTROLFILE REUSE DATABASE "xifenfei" NORESETLOGS  NOARCHIVELOG

  2          MAXLOGFILES 50

  3         MAXLOGMEMBERS 5

  4         MAXDATAFILES 1000

  5         MAXINSTANCES 8

  6         MAXLOGHISTORY 2920

  7  LOGFILE

  8         group 1   '/u01/oracle/app/oradata/xifenfei/redo01.log' size 500M,

  9         group 2   '/u01/oracle/app/oradata/xifenfei/redo02.log' size 500M,

 10         group 6   '/u01/oracle/app/oradata/xifenfei/redo06.log' size 500M,

 11         group 4   '/u01/oracle/app/oradata/xifenfei/redo04.log' size 500M,

 12         group 5   '/u01/oracle/app/oradata/xifenfei/redo05.log' size 500M,

 13         group 3   '/u01/oracle/app/oradata/xifenfei/redo03.log' size 500M

 14  DATAFILE

 15          '/u01/oracle/app/oradata/xifenfei/system01.dbf',

 16          '/u01/oracle/app/oradata/xifenfei/sysaux01.dbf',

 17          '/u01/oracle/app/oradata/xifenfei/undotbs01.dbf',

 18          '/u01/oracle/app/oradata/xifenfei/users01.dbf',

………………

 49          '/u01/oracle/app/oradata/xifenfei/XIFENFEI.dbf'

 50  CHARACTER SET  ZHS16GBK ;

 

Control file created.

 

SQL> recover database;

ORA-10877: error signaled in parallel recovery slave

 

 

SQL> recover database until cancel;

ORA-00279: change 2290050101 generated at 09/30/2022 23:18:22 needed for thread

1

ORA-00289: suggestion : /u02/oracle/arch/1_2_1116803861.dbf

ORA-00280: change 2290050101 for thread 1 is in sequence #2

 

 

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

cancel

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/u01/oracle/app/oradata/xifenfei/system01.dbf'

 

 

ORA-01112: media recovery not started

 

 

SQL> alter database open resetlogs;

 

Database altered.

检查数据库字典一致性

SQL> @1

HCheck Version 07MAY18 on 01-OCT-2022 01:07:48

----------------------------------------------

Catalog Version 11.2.0.4.0 (1102000400)

db_name: XIFENFEI

 

                                   Catalog       Fixed

Procedure Name                     Version    Vs Release    Timestamp

Result

------------------------------ ... ---------- -- ---------- --------------

------

.- LobNotInObj                 ... 1102000400 <=  *All Rel* 10/01 01:07:48 PASS

.- MissingOIDOnObjCol          ... 1102000400 <=  *All Rel* 10/01 01:07:48 PASS

.- SourceNotInObj              ... 1102000400 <=  *All Rel* 10/01 01:07:48 PASS

.- OversizedFiles              ... 1102000400 <=  *All Rel* 10/01 01:07:48 PASS

.- PoorDefaultStorage          ... 1102000400 <=  *All Rel* 10/01 01:07:48 PASS

.- PoorStorage                 ... 1102000400 <=  *All Rel* 10/01 01:07:48 PASS

.- TabPartCountMismatch        ... 1102000400 <=  *All Rel* 10/01 01:07:48 PASS

.- OrphanedTabComPart          ... 1102000400 <=  *All Rel* 10/01 01:07:48 PASS

.- MissingSum$                 ... 1102000400 <=  *All Rel* 10/01 01:07:48 PASS

.- MissingDir$                 ... 1102000400 <=  *All Rel* 10/01 01:07:48 PASS

.- DuplicateDataobj            ... 1102000400 <=  *All Rel* 10/01 01:07:48 PASS

.- ObjSynMissing               ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- ObjSeqMissing               ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- OrphanedUndo                ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- OrphanedIndex               ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- OrphanedIndexPartition      ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- OrphanedIndexSubPartition   ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- OrphanedTable               ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- OrphanedTablePartition      ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- OrphanedTableSubPartition   ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- MissingPartCol              ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- OrphanedSeg$                ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- OrphanedIndPartObj#         ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- DuplicateBlockUse           ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- FetUet                      ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- Uet0Check                   ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- SeglessUET                  ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- BadInd$                     ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- BadTab$                     ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- BadIcolDepCnt               ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- ObjIndDobj                  ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- TrgAfterUpgrade             ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- ObjType0                    ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- BadOwner                    ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- StmtAuditOnCommit           ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- BadPublicObjects            ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- BadSegFreelist              ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- BadDepends                  ... 1102000400 <=  *All Rel* 10/01 01:07:49 PASS

.- CheckDual                   ... 1102000400 <=  *All Rel* 10/01 01:07:50 PASS

.- ObjectNames                 ... 1102000400 <=  *All Rel* 10/01 01:07:50 PASS

.- BadCboHiLo                  ... 1102000400 <=  *All Rel* 10/01 01:07:50 PASS

.- ChkIotTs                    ... 1102000400 <=  *All Rel* 10/01 01:07:50 PASS

.- NoSegmentIndex              ... 1102000400 <=  *All Rel* 10/01 01:07:50 PASS

.- BadNextObject               ... 1102000400 <=  *All Rel* 10/01 01:07:50 PASS

.- DroppedROTS                 ... 1102000400 <=  *All Rel* 10/01 01:07:50 PASS

.- FilBlkZero                  ... 1102000400 <=  *All Rel* 10/01 01:07:50 PASS

.- DbmsSchemaCopy              ... 1102000400 <=  *All Rel* 10/01 01:07:50 PASS

.- OrphanedObjError            ... 1102000400 >  1102000000 10/01 01:07:50 PASS

.- ObjNotLob                   ... 1102000400 <=  *All Rel* 10/01 01:07:50 PASS

.- MaxControlfSeq              ... 1102000400 <=  *All Rel* 10/01 01:07:50 PASS

.- SegNotInDeferredStg         ... 1102000400 >  1102000000 10/01 01:07:50 PASS

.- SystemNotRfile1             ... 1102000400 >   902000000 10/01 01:07:50 PASS

.- DictOwnNonDefaultSYSTEM     ... 1102000400 <=  *All Rel* 10/01 01:07:50 PASS

.- OrphanTrigger               ... 1102000400 <=  *All Rel* 10/01 01:07:50 PASS

.- ObjNotTrigger               ... 1102000400 <=  *All Rel* 10/01 01:07:50 PASS

---------------------------------------

01-OCT-2022 01:07:50  Elapsed: 2 secs

---------------------------------------

Found 0 potential problem(s) and 0 warning(s)

 

PL/SQL procedure successfully completed.

 

Statement processed.

数据库字典本身没有大问题,但是为了排除潜在风险,建议逻辑迁移到新库

• Oracle断电故障处理
• ORA-00333 ORA-01595 恢复
• 硬件故障导致ORA-600 2662错误处理
• ORA-600 ktbsdp2 处理
• ext3/ext4 超级块修复
• ORA 600 3005恢复
• win文件系统损坏oracle恢复
• 一键恢复ORA-01113 ORA-01110—Oracle Recovery Tools
• ORA-01110 ORA-17070 OSD-04006 故障恢复
• 因为人工误操作导致resetlogs scn不一致恢复
• ORA-00702一键恢复工具
• 修改oracle scn小工具(patch scn)