ora-600 ktugct: corruption detected---惜分飛

接手一個oracle 21c的庫恢復請求,通過Oracle數據庫異常恢復檢查腳本(Oracle Database Recovery Check)腳本檢測之后,發現undo文件offline之后,做了resetlogs操作,導致該文件目前處于WRONG RESETLOGS狀態
?

21c

wrong-resetlogs

嘗試恢復數據庫ORA-16433錯誤

SQL> recover datafile 1;

ORA-00283: recovery session canceled due to errors

ORA-16433: The database must be opened in read/write mode.

2025-03-11T12:07:43.381296+08:00

ALTER DATABASE RECOVER? datafile 1?

2025-03-11T12:07:43.381296+08:00

Media Recovery Start

2025-03-11T12:07:43.381296+08:00

Media Recovery failed with error 16433

ORA-283 signalled during: ALTER DATABASE RECOVER? datafile 1? ...

官方對于該錯誤的解釋

[oracle@iZbp11c0qyuuo1gr7j98upZ ~]$ oerr ora 16433

16433, 00000, "The database must be opened in read/write mode."

// *Cause:? An attempt was made to open the database in read-only mode after an

//????????? operation that requires that the database be opened in read/write

//????????? mode.

// *Action: Open the database in read/write mode. The database can then be

//????????? opened in read-only mode.

對于該錯誤,可以通過rectl進行解決,但是由于undo文件的resetlog 信息不對,無法直接重建ctl,這種情況下,通過Oracle Recovery Tools小工具對undo文件的resetlogs信息今星期修改

ora-recovery

然后重建ctl成功

C:\Users\XFF>sqlplus / as sysdba

SQL*Plus: Release 21.0.0.0.0 - Production on 星期二 3月 11 12:15:00 2025

Version 21.3.0.0.0

連接到:

Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production

Version 21.3.0.0.0

SQL> CREATE CONTROLFILE REUSE DATABASE "ORCLCDB" NORESETLOGS? NOARCHIVELOG

??2???????? MAXLOGFILES 50

??3???????? MAXLOGMEMBERS 5

??4???????? MAXDATAFILES 5000

??5???????? MAXINSTANCES 8

??6???????? MAXLOGHISTORY 2920

??7? LOGFILE

??8???????? group 1?? 'H:\TEMP\ORCLCDB\REDO01.LOG' size 200M,

??9???????? group 3?? 'H:\TEMP\ORCLCDB\REDO03.LOG' size 200M,

?10???????? group 2?? 'H:\TEMP\ORCLCDB\REDO02.LOG' size 200M

?11? DATAFILE

?12????????? 'H:\TEMP\ORCLCDB\SYSTEM01.DBF',

?13????????? 'H:\TEMP\ORCLCDB\SYSAUX01.DBF',

?14????????? 'H:\TEMP\ORCLCDB\UNDOTBS01.DBF',

?15????????? 'H:\TEMP\ORCLCDB\PDBSEED\SYSTEM01.DBF',

?16????????? 'H:\TEMP\ORCLCDB\PDBSEED\SYSAUX01.DBF',

?17????????? 'H:\TEMP\ORCLCDB\USERS01.DBF',

?18????????? 'H:\TEMP\ORCLCDB\PDBSEED\UNDOTBS01.DBF',

?19????????? 'H:\TEMP\ORCLCDB\ORCLPDB1\SYSTEM01.DBF',

?20????????? 'H:\TEMP\ORCLCDB\ORCLPDB1\UNDOTBS01.DBF',

?21????????? 'H:\TEMP\ORCLCDB\ORCLPDB1\USERS01.DBF'

?22? CHARACTER SET? AL32UTF8 ;

控制文件已創建。

嘗試open庫報ORA-600 ktugct: corruption detected錯誤

SQL> recover database;

完成介質恢復。

SQL> alter database open;

alter database open

*

第 1 行出現錯誤:

ORA-00603: ORACLE server session terminated by fatal error

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00600: internal error code, arguments: [ktugct: corruption detected], [],

[], [], [], [], [], [], [], [], [], []

進程 ID: 8372

會話 ID: 978 序列號: 21772

通過對啟動過程進行分析,確認是在seq$表訪問的時候報錯

PARSING IN CURSOR #2238117495280 len=102 dep=1 uid=0 oct=3 lid=0 tim=821317050254

?hv=3967354608 ad='7ff9048c41b8' sqlid='axmdf8vq7k1rh'

select increment$,minvalue,maxvalue,cycle#,order$,cache,highwater,audit$,flags from seq$ where obj#=:1

END OF STMT

PARSE #2238117495280:c=6253,e=6253,p=5,cr=90,cu=0,mis=1,r=0,dep=1,og=4,plh=0,tim=821317050254

BINDS #2238117156016:

?Bind#0

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0

??kxsbbbfp=1a33f610? bln=22? avl=02? flg=05

??value=100

?Bind#1

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24

??kxsbbbfp=1a33f628? bln=22? avl=02? flg=01

??value=1

EXEC #2238117156016:c=95,e=95,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=2239883476,tim=821317050580

FETCH #2238117156016:c=8,e=8,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,plh=2239883476,tim=821317050600

CLOSE #2238117156016:c=3,e=3,dep=2,type=3,tim=821317050619

BINDS #2238117156016:

?Bind#0

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0

??kxsbbbfp=1a33f610? bln=22? avl=02? flg=05

??value=100

?Bind#1

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24

??kxsbbbfp=1a33f628? bln=22? avl=02? flg=01

??value=2

EXEC #2238117156016:c=87,e=87,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=2239883476,tim=821317050746

FETCH #2238117156016:c=7,e=7,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,plh=2239883476,tim=821317050764

CLOSE #2238117156016:c=3,e=3,dep=2,type=3,tim=821317050781

BINDS #2238117156016:

?Bind#0

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0

??kxsbbbfp=1a33f610? bln=22? avl=02? flg=05

??value=100

?Bind#1

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24

??kxsbbbfp=1a33f628? bln=22? avl=02? flg=01

??value=3

EXEC #2238117156016:c=84,e=84,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=2239883476,tim=821317050885

FETCH #2238117156016:c=6,e=6,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,plh=2239883476,tim=821317050902

CLOSE #2238117156016:c=2,e=2,dep=2,type=3,tim=821317050917

BINDS #2238117156016:

?Bind#0

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0

??kxsbbbfp=1a33f610? bln=22? avl=02? flg=05

??value=100

?Bind#1

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24

??kxsbbbfp=1a33f628? bln=22? avl=02? flg=01

??value=4

EXEC #2238117156016:c=83,e=83,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=2239883476,tim=821317051019

FETCH #2238117156016:c=5,e=5,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,plh=2239883476,tim=821317051035

CLOSE #2238117156016:c=3,e=2,dep=2,type=3,tim=821317051050

BINDS #2238117156016:

?Bind#0

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0

??kxsbbbfp=1a33f610? bln=22? avl=02? flg=05

??value=100

?Bind#1

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24

??kxsbbbfp=1a33f628? bln=22? avl=02? flg=01

??value=5

EXEC #2238117156016:c=88,e=88,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=2239883476,tim=821317051158

FETCH #2238117156016:c=5,e=5,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,plh=2239883476,tim=821317051174

CLOSE #2238117156016:c=2,e=2,dep=2,type=3,tim=821317051190

BINDS #2238117156016:

?Bind#0

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0

??kxsbbbfp=1a33f610? bln=22? avl=02? flg=05

??value=100

?Bind#1

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24

??kxsbbbfp=1a33f628? bln=22? avl=02? flg=01

??value=6

EXEC #2238117156016:c=83,e=83,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=2239883476,tim=821317051292

FETCH #2238117156016:c=5,e=6,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,plh=2239883476,tim=821317051308

CLOSE #2238117156016:c=2,e=2,dep=2,type=3,tim=821317051323

BINDS #2238117156016:

?Bind#0

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0

??kxsbbbfp=1a33f610? bln=22? avl=02? flg=05

??value=100

?Bind#1

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24

??kxsbbbfp=1a33f628? bln=22? avl=02? flg=01

??value=7

EXEC #2238117156016:c=83,e=83,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=2239883476,tim=821317051425

FETCH #2238117156016:c=5,e=5,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,plh=2239883476,tim=821317051440

CLOSE #2238117156016:c=3,e=3,dep=2,type=3,tim=821317051456

BINDS #2238117156016:

?Bind#0

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0

??kxsbbbfp=1a33f610? bln=22? avl=02? flg=05

??value=100

?Bind#1

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24

??kxsbbbfp=1a33f628? bln=22? avl=02? flg=01

??value=8

EXEC #2238117156016:c=83,e=83,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=2239883476,tim=821317051558

FETCH #2238117156016:c=5,e=5,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,plh=2239883476,tim=821317051573

CLOSE #2238117156016:c=2,e=2,dep=2,type=3,tim=821317051588

BINDS #2238117156016:

?Bind#0

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0

??kxsbbbfp=1a33f610? bln=22? avl=02? flg=05

??value=100

?Bind#1

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24

??kxsbbbfp=1a33f628? bln=22? avl=02? flg=01

??value=9

EXEC #2238117156016:c=82,e=82,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=2239883476,tim=821317051688

FETCH #2238117156016:c=5,e=5,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,plh=2239883476,tim=821317051704

CLOSE #2238117156016:c=2,e=2,dep=2,type=3,tim=821317051719

BINDS #2238117156016:

?Bind#0

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=48 off=0

??kxsbbbfp=1a33f610? bln=22? avl=02? flg=05

??value=100

?Bind#1

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24

??kxsbbbfp=1a33f628? bln=22? avl=02? flg=01

??value=10

EXEC #2238117156016:c=82,e=82,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=2239883476,tim=821317051821

FETCH #2238117156016:c=5,e=5,p=0,cr=3,cu=0,mis=0,r=1,dep=2,og=3,plh=2239883476,tim=821317051837

CLOSE #2238117156016:c=2,e=2,dep=2,type=3,tim=821317051852

BINDS #2238117508144:

?Bind#0

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=72 off=0

??kxsbbbfp=1a33f5f8? bln=22? avl=02? flg=05

??value=100

?Bind#1

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=24

??kxsbbbfp=1a33f610? bln=22? avl=02? flg=01

??value=10

?Bind#2

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=0 off=48

??kxsbbbfp=1a33f628? bln=22? avl=01? flg=01

??value=0

EXEC #2238117508144:c=144,e=144,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=3,plh=3312420081,tim=821317052013

FETCH #2238117508144:c=164,e=164,p=1,cr=3,cu=0,mis=0,r=3,dep=2,og=3,plh=3312420081,tim=821317052189

CLOSE #2238117508144:c=4,e=4,dep=2,type=3,tim=821317052208

BINDS #2238117495280:

?Bind#0

??oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00

??oacflg=00 fl2=1000001 frm=00 csi=00 siz=24 off=0

??kxsbbbfp=1a33f628? bln=22? avl=03? flg=05

??value=1749

EXEC #2238117495280:c=2211,e=2211,p=1,cr=33,cu=0,mis=1,r=0,dep=1,og=4,plh=2203911306,tim=821317052521

WAIT #2238117495280: nam='db file sequential read' ela= 82 file#=1 block#=1201 blocks=1 obj#=105 tim=821317052620

WAIT #2238117495280: nam='db file sequential read' ela= 78 file#=1 block#=1202 blocks=1 obj#=105 tim=821317052723

WAIT #2238117495280: nam='db file sequential read' ela= 77 file#=1 block#=1161 blocks=1 obj#=100 tim=821317052824

ktuisc detected lost changes to transaction table:

?xid of interest:? xid: 0x0003.00c.0006e788 xid from block :? xid: 0x0003.00c.0006e785

2025-03-11T12:18:43.210707+08:00

Incident 25673 created, dump file: C:\APP\XFF\diag\rdbms\orclcdb\o21c\incident\incdir_25673\o21c_ora_12976_i25673.trc

ORA-00600: 內部錯誤代碼, 參數: [ktugct: corruption detected], [], [], [], [], [], [], [], [], [], [], []

FETCH #2238117495280:c=1350284,e=1359602,p=3,cr=4,cu=0,mis=0,r=0,dep=1,og=4,plh=2203911306,tim=821318412135

STAT #2238117495280 id=1 cnt=0 pid=0 pos=1 obj=100

??op='TABLE ACCESS BY INDEX ROWID SEQ$ (cr=0 pr=0 pw=0 str=1 time=1 us cost=2 size=73 card=1)'

STAT #2238117495280 id=2 cnt=1 pid=1 pos=1 obj=105

??op='INDEX UNIQUE SCAN I_SEQ1 (cr=2 pr=2 pw=0 str=1 time=209 us cost=1 size=0 card=1)'

<error barrier> at 0x0000003197FF21D8 placed dbsdrv.c@5035

ORA-00600: 內部錯誤代碼, 參數: [ktugct: corruption detected], [], [], [], [], [], [], [], [], [], [], []

<error barrier> at 0x0000003197FF21D8 placed dbsdrv.c@5035

ORA-00600: 內部錯誤代碼, 參數: [ktugct: corruption detected], [], [], [], [], [], [], [], [], [], [], []

2025-03-11T12:18:44.572180+08:00

Incident 25674 created, dump file: C:\APP\XFF\diag\rdbms\orclcdb\o21c\incident\incdir_25674\o21c_ora_12976_i25674.trc

ORA-00603: ORACLE 服務器會話因致命錯誤而終止

ORA-01092: ORACLE 實例終止。強制斷開連接

ORA-00600: 內部錯誤代碼, 參數: [ktugct: corruption detected], [], [], [], [], [], [], [], [], [], [], []

進一步分析trace信息

[TOC00001]

ORA-00600: 內部錯誤代碼, 參數: [ktugct: corruption detected], [], [], [], [], [], [], [], [], [], [], []

[TOC00001-END]

[TOC00002]

========= Dump for incident 25673 (ORA 600 [ktugct: corruption detected]) ========

[TOC00003]

----- Beginning of Customized Incident Dump(s) -----

Corruption or lost changes detected in transaction table

Cleanout struct - flg: 0x00000000 ne = 1 cu: 0 cv: 1 cec:0 actcnt:0

xids being resolved:

?xid: 0x0003.00c.0006e788 sit: 2

inverse itl idx to cleanout entry mapping:

Dump of memory from 0x000002091036B32A to 0x000002091036B429

Block cleanout record, scn: 0xffffffffffffffff ver: 0x01 opt: 0x01

, entries follow...

-- Start of buffer-cache dump for undo segment header --

Dump of buffer cache at level 10 for pdb=1 tsn=2 rdba=16777376

BH (0x7ffaccf5e9e0) file#: 4 rdba: 0x010000a0 (4/160) class: 21 ba: 0x7ffacc17c000

??set: 57 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 0,0

??dbwrid: 0 obj: -1 objn: 0 tsn: [1/2] afn: 4 hint: f

??hash: [0x7ff91759e230,0x7ff91759e230] lru: [0x7ffaccf5ec30,0x7ffaccf5e960]

??ckptq: [NULL] fileq: [NULL]

??objq: [0x7ff9041e1708,0x7ff9041e1708] objaq: [0x7ff9041e16f8,0x7ff9041e16f8] qhead: 0x7ff9041e16e8

??st: XCURRENT md: NULL fpin: 'ktuwh117: ktugus:kturec' fscn: 0x1a321837 tch: 1

??flags:

??LRBA: [0x0.0.0] LSCN: [0x0] HSCN: [0x0] HSUB: [65535]

??Printing buffer operation history (latest change first): (cnt 10)

??01. sid:14 L353:gcur:set:MEXCL????? 02. sid:14 L145:zib:mk:EXCL??????

??03. sid:14 L212:zib:bic:FSQ???????? 04. sid:14 L122:zgb:set:st???????

??05. sid:14 L830:olq1:clr:WRT+CKT??? 06. sid:14 L951:zgb:lnk:objq?????

??07. sid:14 L372:zgb:set:MEXCL?????? 08. sid:14 L123:zgb:no:FEN???????

??09. sid:14 L083:zgb:ent:fn????????? 10. sid:00 L203:w_ini_dc:bic:FVB?

??buffer tsn: 2 rdba: 0x010000a0 (4/160)

??scn: 0x192ea609 seq: 0x01 flg: 0x04 tail: 0xa6092601

??frmt: 0x02 chkval: 0x3395 type: 0x26=KTU SMU HEADER BLOCK

Hex dump of block: st=0, typ_found=1

Dump of memory from 0x00007FFACC17C000 to 0x00007FFACC17E000

7FFACC17C000 0000A226 010000A0 192EA609 04010000? [&...............]

7FFACC17C010 00003395 00000000 00000000 00000000? [.3..............]

7FFACC17C020 00000000 00000004 0000010F 00000FF0? [................]

7FFACC17C030 00000000 00000000 00000007 010000A1? [................]

7FFACC17C040 00000000 00000000 00000000 00000000? [................]

7FFACC17C050 00000000 00000000 00000000 00000004? [................]

7FFACC17C060 00000000 00000000 40000000 010000A1? [...........@....]

7FFACC17C070 00000007 010000B8 00000008 01000780? [................]

7FFACC17C080 00000080 01000180 00000080 00000000? [................]

7FFACC17C090 00000000 00000000 00000000 00000000? [................]

????????Repeat 246 times

7FFACC17D000 00000000 67770DDD 6776D1BB 6776EEC1? [......wg..vg..vg]

7FFACC17D010 67770DDD 6775F337 6775F337 6775F34B? [..wg7.ug7.ugK.ug]

7FFACC17D020 67734C0B 676F7532 676CB861 6734082B? [.Lsg2uoga.lg+.4g]

7FFACC17D030 6734082B 671AD100 671AD100 671AD100? [+.4g...g...g...g]

7FFACC17D040 671AD100 671AA6DC 67014F31 67014F31? [...g...g1O.g1O.g]

7FFACC17D050 67014F31 67014F31 67014F31 62BB38EE? [1O.g1O.g1O.g.8.b]

7FFACC17D060 62BB38EE 62BB38EE 62BB38EE 62BB38EE? [.8.b.8.b.8.b.8.b]

????????Repeat 1 times

7FFACC17D080 62BB38EE 62BB38EE 62BB0EE3 62BB0EE3? [.8.b.8.b...b...b]

7FFACC17D090 62BB0EE3 62BB0EE3 62BB0EE3 62BB0EE3? [...b...b...b...b]

????????Repeat 14 times

7FFACC17D180 62BB0EE3 00000000 00000000 00000000? [...b............]

7FFACC17D190 00000000 00000000 00000000 00000000? [................]

????????Repeat 99 times

7FFACC17D7D0 192EA31E 00000000 010000A1 001E3150? [............P1..]

7FFACC17D7E0 31500001 00000001 00000000 00080004? [..P1............]

7FFACC17D7F0 0001B000 00000068 7FFFFFFE 010000A1? [....h...........]

7FFACC17D800 001E3150 055E0000 00000000 0007314E? [P1....^.....N1..]

7FFACC17D810 0CEC0002 00000000 000B3146 1A180002? [........F1......]

7FFACC17D820 00000000 00173103 12B40002 00000000? [.....1..........]

7FFACC17D830 00000000 00000000 0006E7A0 010000A1? [................]

7FFACC17D840 192EA53E 00000000 00100009 00000000? [>...............]

7FFACC17D850 00000000 00000000 00000001 67770DEE? [..............wg]

7FFACC17D860 0006E7AF 010000A1 192EA4E4 00000000? [................]

7FFACC17D870 000F0009 00000000 00000000 00000000? [................]

7FFACC17D880 00000001 67770DE8 0006E790 010000A1? [......wg........]

7FFACC17D890 192EA58D 00000000 001F0009 00000000? [................]

7FFACC17D8A0 00000000 00000000 00000001 67770DF3? [..............wg]

7FFACC17D8B0 0006E797 010001FF 192EA431 00000000? [........1.......]

7FFACC17D8C0 000B0009 00000000 00000000 00000000? [................]

7FFACC17D8D0 00000001 67770DDC 0006E795 010001FF? [......wg........]

7FFACC17D8E0 192EA33D 00000000 000D0009 00000000? [=...............]

7FFACC17D8F0 00000000 00000000 00000001 67770DCC? [..............wg]

7FFACC17D900 0006E79A 010000A1 192EA4D1 00000000? [................]

7FFACC17D910 00160009 00000000 00000000 00000000? [................]

7FFACC17D920 00000001 67770DE6 0006E792 010000A1? [......wg........]

7FFACC17D930 192EA472 00000000 000A0009 00000000? [r...............]

7FFACC17D940 00000000 00000000 00000001 67770DE0? [..............wg]

7FFACC17D950 0006E7A6 010001FF 192EA3FB 00000000? [................]

7FFACC17D960 00090009 00000000 00000000 00000000? [................]

7FFACC17D970 00000001 67770DD8 0006E7A7 010000A1? [......wg........]

7FFACC17D980 192EA609 00000000 FFFF0009 00000000? [................]

7FFACC17D990 00000000 00000000 00000001 67770DFB? [..............wg]

7FFACC17D9A0 0006E79C 010001FF 192EA41A 00000000? [................]

7FFACC17D9B0 00030009 00000000 00000000 00000000? [................]

7FFACC17D9C0 00000001 67770DDA 0006E79E 010000A1? [......wg........]

7FFACC17D9D0 192EA481 00000000 00150009 00000000? [................]

7FFACC17D9E0 00000000 00000000 00000001 67770DE1? [..............wg]

7FFACC17D9F0 0006E7A3 010000A1 192EA44C 00000000? [........L.......]

7FFACC17DA00 00190009 00000000 00000000 00000000? [................]

7FFACC17DA10 00000002 67770DDD 0006E785 010001FF? [......wg........]

7FFACC17DA20 192EA391 00000000 00180009 00000000? [................]

7FFACC17DA30 00000000 00000000 00000001 67770DD1? [..............wg]

7FFACC17DA40 0006E7AB 010001FF 192EA355 00000000? [........U.......]

7FFACC17DA50 001A0009 00000000 00000000 00000000? [................]

7FFACC17DA60 00000001 67770DCD 0006E793 010000A1? [......wg........]

7FFACC17DA70 192EA51F 00000000 00000009 00000000? [................]

7FFACC17DA80 00000000 00000000 00000001 67770DEC? [..............wg]

7FFACC17DA90 0006E7AD 010000A1 192EA4FA 00000000? [................]

7FFACC17DAA0 000E0009 00000000 00000000 00000000? [................]

7FFACC17DAB0 00000001 67770DE9 0006E794 010000A1? [......wg........]

7FFACC17DAC0 192EA550 00000000 00130009 00000000? [P...............]

7FFACC17DAD0 00000000 00000000 00000001 67770DEF? [..............wg]

7FFACC17DAE0 0006E792 010000A1 192EA5DF 00000000? [................]

7FFACC17DAF0 00210009 00000000 00000000 00000000? [..!.............]

7FFACC17DB00 00000001 67770DF9 0006E766 010000A1? [......wgf.......]

7FFACC17DB10 192EA5C2 00000000 001E0009 00000000? [................]

7FFACC17DB20 00000000 00000000 00000001 67770DF7? [..............wg]

7FFACC17DB30 0006E787 010000A1 192EA561 00000000? [........a.......]

7FFACC17DB40 001C0009 00000000 00000000 00000000? [................]

7FFACC17DB50 00000001 67770DF0 0006E7A3 010001FF? [......wg........]

7FFACC17DB60 192EA3D2 00000000 00070009 00000000? [................]

7FFACC17DB70 00000000 00000000 00000001 67770DD6? [..............wg]

7FFACC17DB80 0006E7A5 010000A1 192EA498 00000000? [................]

7FFACC17DB90 00200009 00000000 00000000 00000000? [.. .............]

7FFACC17DBA0 00000001 67770DE2 0006E791 010000A1? [......wg........]

7FFACC17DBB0 192EA4DD 00000000 00010009 00000000? [................]

7FFACC17DBC0 00000000 00000000 00000001 67770DE7? [..............wg]

7FFACC17DBD0 0006E79F 010000A1 192EA5F6 00000000? [................]

7FFACC17DBE0 00080009 00000000 00000000 00000000? [................]

7FFACC17DBF0 00000001 67770DFA 0006E78A 010001FF? [......wg........]

7FFACC17DC00 192EA3A7 00000000 001D0009 00000000? [................]

7FFACC17DC10 00000000 00000000 00000001 67770DD3? [..............wg]

7FFACC17DC20 0006E797 010000A1 192EA45D 00000000? [........].......]

7FFACC17DC30 00060009 00000000 00000000 00000000? [................]

7FFACC17DC40 00000001 67770DDF 0006E796 010001FF? [......wg........]

7FFACC17DC50 192EA368 00000000 001B0009 00000000? [h...............]

7FFACC17DC60 00000000 00000000 00000001 67770DCF? [..............wg]

7FFACC17DC70 0006E78E 010001FF 192EA37D 00000000? [........}.......]

7FFACC17DC80 000C0009 00000000 00000000 00000000? [................]

7FFACC17DC90 00000001 67770DD0 0006E798 010000A1? [......wg........]

7FFACC17DCA0 192EA56F 00000000 00020009 00000000? [o...............]

7FFACC17DCB0 00000000 00000000 00000001 67770DF1? [..............wg]

7FFACC17DCC0 0006E7A1 010001FF 192EA3B5 00000000? [................]

7FFACC17DCD0 00140009 00000000 00000000 00000000? [................]

7FFACC17DCE0 00000001 67770DD4 0006E7A2 010000A1? [......wg........]

7FFACC17DCF0 192EA5CE 00000000 00110009 00000000? [................]

7FFACC17DD00 00000000 00000000 00000001 67770DF7? [..............wg]

7FFACC17DD10 0006E794 010000A1 192EA5A0 00000000? [................]

7FFACC17DD20 00120009 00000000 00000000 00000000? [................]

7FFACC17DD30 00000001 67770DF4 0006E7A2 010000A1? [......wg........]

7FFACC17DD40 192EA4A5 00000000 00050009 00000000? [................]

7FFACC17DD50 00000000 00000000 00000001 67770DE3? [..............wg]

7FFACC17DD60 0006E7A5 010000A1 192EA5E9 00000000? [................]

7FFACC17DD70 00170009 00000000 00000000 00000000? [................]

7FFACC17DD80 00000001 67770DF9 00000003 00000000? [......wg........]

7FFACC17DD90 00000000 00000000 00000000 00000000? [................]

????????Repeat 1 times

7FFACC17DDB0 00000001 00000000 00000000 00000000? [................]

????????Repeat 33 times

7FFACC17DFD0 00000000 00000000 00000000 00000000? [................]

????????Repeat 1 times

7FFACC17DFF0 00000000 00000000 00000000 A6092601? [.............&..]

??Extent Control Header

??-----------------------------------------------------------------

??Extent Header:: spare1: 0????? spare2: 0????? #extents: 4????? #blocks: 271??

??????????????????last map? 0x00000000? #maps: 0????? offset: 4080?

??????Highwater::? 0x010000a1? ext#: 0????? blk#: 0????? ext size: 7????

??#blocks in seg. hdr's freelists: 0????

??#blocks below: 0????

??mapblk? 0x00000000? offset: 0????

???????????????????Unlocked

?????Map Header:: next? 0x00000000? #extents: 4??? obj#: 0????? flag: 0x40000000

??Extent Map

??-----------------------------------------------------------------

???0x010000a1? length: 7????

???0x010000b8? length: 8????

???0x01000780? length: 128??

???0x01000180? length: 128??

???

?Retention Table

??-----------------------------------------------------------

?Extent Number:0? Commit Time: 1735855581

?Extent Number:1? Commit Time: 1735840187

?Extent Number:2? Commit Time: 1735847617

?Extent Number:3? Commit Time: 1735855581

???

??TRN CTL:: seq: 0x3150 chd: 0x0004 ctl: 0x0008 inc: 0x00000000 nfb: 0x0001

????????????mgc: 0xb000 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)

????????????uba: 0x010000a1.3150.1e scn: 0x00000000192ea31e

Version: 0x01

??FREE BLOCK POOL::

????uba: 0x010000a1.3150.1e ext: 0x0? spc: 0x55e??

????uba: 0x00000000.314e.07 ext: 0x2? spc: 0xcec??

????uba: 0x00000000.3146.0b ext: 0x2? spc: 0x1a18?

????uba: 0x00000000.3103.17 ext: 0x2? spc: 0x12b4?

????uba: 0x00000000.0000.00 ext: 0x0? spc: 0x0????

??TRN TBL::

??

??index? state cflags? wrap#??? uel???????? scn??????????? dba??????????? parent-xid??? nub???? stmt_num??? cmt

??-----------------------------------------------------------------------------------------

???0x00? 9 0x00? 0x6e7a0? 0x0010? 0x00000000192ea53e? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855598

???0x01? 9 0x00? 0x6e7af? 0x000f? 0x00000000192ea4e4? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855592

???0x02? 9 0x00? 0x6e790? 0x001f? 0x00000000192ea58d? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855603

???0x03? 9 0x00? 0x6e797? 0x000b? 0x00000000192ea431? 0x010001ff 0x0000.000.00000000? 0x00000001 0x00000000 1735855580

???0x04? 9 0x00? 0x6e795? 0x000d? 0x00000000192ea33d? 0x010001ff 0x0000.000.00000000? 0x00000001 0x00000000 1735855564

???0x05? 9 0x00? 0x6e79a? 0x0016? 0x00000000192ea4d1? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855590

???0x06? 9 0x00? 0x6e792? 0x000a? 0x00000000192ea472? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855584

???0x07? 9 0x00? 0x6e7a6? 0x0009? 0x00000000192ea3fb? 0x010001ff 0x0000.000.00000000? 0x00000001 0x00000000 1735855576

???0x08? 9 0x00? 0x6e7a7? 0xffff? 0x00000000192ea609? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855611

???0x09? 9 0x00? 0x6e79c? 0x0003? 0x00000000192ea41a? 0x010001ff 0x0000.000.00000000? 0x00000001 0x00000000 1735855578

???0x0a? 9 0x00? 0x6e79e? 0x0015? 0x00000000192ea481? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855585

???0x0b? 9 0x00? 0x6e7a3? 0x0019? 0x00000000192ea44c? 0x010000a1 0x0000.000.00000000? 0x00000002 0x00000000 1735855581

???0x0c? 9 0x00? 0x6e785? 0x0018? 0x00000000192ea391? 0x010001ff 0x0000.000.00000000? 0x00000001 0x00000000 1735855569

???0x0d? 9 0x00? 0x6e7ab? 0x001a? 0x00000000192ea355? 0x010001ff 0x0000.000.00000000? 0x00000001 0x00000000 1735855565

???0x0e? 9 0x00? 0x6e793? 0x0000? 0x00000000192ea51f? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855596

???0x0f? 9 0x00? 0x6e7ad? 0x000e? 0x00000000192ea4fa? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855593

???0x10? 9 0x00? 0x6e794? 0x0013? 0x00000000192ea550? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855599

???0x11? 9 0x00? 0x6e792? 0x0021? 0x00000000192ea5df? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855609

???0x12? 9 0x00? 0x6e766? 0x001e? 0x00000000192ea5c2? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855607

???0x13? 9 0x00? 0x6e787? 0x001c? 0x00000000192ea561? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855600

???0x14? 9 0x00? 0x6e7a3? 0x0007? 0x00000000192ea3d2? 0x010001ff 0x0000.000.00000000? 0x00000001 0x00000000 1735855574

???0x15? 9 0x00? 0x6e7a5? 0x0020? 0x00000000192ea498? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855586

???0x16? 9 0x00? 0x6e791? 0x0001? 0x00000000192ea4dd? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855591

???0x17? 9 0x00? 0x6e79f? 0x0008? 0x00000000192ea5f6? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855610

???0x18? 9 0x00? 0x6e78a? 0x001d? 0x00000000192ea3a7? 0x010001ff 0x0000.000.00000000? 0x00000001 0x00000000 1735855571

???0x19? 9 0x00? 0x6e797? 0x0006? 0x00000000192ea45d? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855583

???0x1a? 9 0x00? 0x6e796? 0x001b? 0x00000000192ea368? 0x010001ff 0x0000.000.00000000? 0x00000001 0x00000000 1735855567

???0x1b? 9 0x00? 0x6e78e? 0x000c? 0x00000000192ea37d? 0x010001ff 0x0000.000.00000000? 0x00000001 0x00000000 1735855568

???0x1c? 9 0x00? 0x6e798? 0x0002? 0x00000000192ea56f? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855601

???0x1d? 9 0x00? 0x6e7a1? 0x0014? 0x00000000192ea3b5? 0x010001ff 0x0000.000.00000000? 0x00000001 0x00000000 1735855572

???0x1e? 9 0x00? 0x6e7a2? 0x0011? 0x00000000192ea5ce? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855607

???0x1f? 9 0x00? 0x6e794? 0x0012? 0x00000000192ea5a0? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855604

???0x20? 9 0x00? 0x6e7a2? 0x0005? 0x00000000192ea4a5? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855587

???0x21? 9 0x00? 0x6e7a5? 0x0017? 0x00000000192ea5e9? 0x010000a1 0x0000.000.00000000? 0x00000001 0x00000000 1735855609

??EXT TRN CTL::

??usn: 3

??sp1:0x00000000 sp2:0x00000000 sp3:0x00000000 sp4:0x00000000

??sp5:0x00000000 sp6:0x00000000 sp7:0x00000000 sp8:0x00000000

??EXT TRN TBL::

??index????? extflag??? extHash??? extPdbid/Spare1 extSpare2

??-----------------------------------------------------------

???0x00??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x01??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x02??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x03??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x04??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x05??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x06??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x07??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x08??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x09??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x0a??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x0b??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x0c??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x0d??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x0e??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x0f??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x10??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x11??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x12??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x13??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x14??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x15??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x16??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x17??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x18??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x19??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x1a??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x1b??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x1c??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x1d??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x1e??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x1f??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x20??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

???0x21??? 0x00000000?? 0x00000000?? 0x00000001??? 0x00000000

Dump of buffer cache for pdb 1 tsn 2 rdba 0x10000a0 at level 10 done.

基于上述信息基本上可以確認是由于我們修復的undo文件和seq$中的file#=1 block#=1161不匹配導致該問題,對其進行處理之后,數據庫open成功

2025-03-11T13:12:52.837511+08:00

alter database open

2025-03-11T13:12:52.860336+08:00

Smart fusion block transfer is disabled:

??instance mounted in exclusive mode.

Buffer Cache Full DB Caching mode changing from FULL CACHING DISABLED to FULL CACHING ENABLED

2025-03-11T13:12:52.864333+08:00

Crash Recovery excluding pdb 2 which was cleanly closed.

2025-03-11T13:12:52.864333+08:00

Crash Recovery excluding pdb 3 which was cleanly closed.

Endian type of dictionary set to little

2025-03-11T13:12:52.886321+08:00

Redo log for group 1, sequence 7 is not located on DAX storage

Thread 1 opened at log sequence 7

??Current log# 1 seq# 7 mem# 0: H:\TEMP\ORCLCDB\REDO01.LOG

Successful open of redo thread 1

2025-03-11T13:12:52.894310+08:00

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Stopping change tracking

Undo initialization recovery: Parallel FPTR complete: start:824531531 end:824531531 diff:0 ms (0.0 seconds)

Undo initialization recovery: err:0 start: 824531531 end: 824531531 diff: 0 ms (0.0 seconds)

[13696] Successfully onlined Undo Tablespace 5.

Undo initialization online undo segments: err:0 start: 824531531 end: 824531609 diff: 78 ms (0.1 seconds)

Undo initialization finished serial:0 start:824531531 end:824531609 diff:78 ms (0.1 seconds)

Database Characterset is AL32UTF8

No Resource Manager plan active

Starting background process RCBG

2025-03-11T13:12:53.502478+08:00

RCBG started with pid=48, OS id=17560_12292

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process AQPC

2025-03-11T13:12:53.724661+08:00

AQPC started with pid=49, OS id=17560_12948

PDB$SEED(2):Pluggable database PDB$SEED opening in read only

PDB$SEED(2):Autotune of undo retention is turned on.

PDB$SEED(2):Endian type of dictionary set to little

PDB$SEED(2):Undo initialization finished serial:0 start:824532375 end:824532375 diff:0 ms (0.0 seconds)

PDB$SEED(2):Database Characterset for PDB$SEED is AL32UTF8

PDB$SEED(2):*********************************************************************

PDB$SEED(2):WARNING: The following temporary tablespaces in container(PDB$SEED)

PDB$SEED(2):???????? contain no files.

PDB$SEED(2):???????? This condition can occur when a backup controlfile has

PDB$SEED(2):???????? been restored.? It may be necessary to add files to these

PDB$SEED(2):???????? tablespaces.? That can be done using the SQL statement:

PDB$SEED(2):

PDB$SEED(2):???????? ALTER TABLESPACE <tablespace_name> ADD TEMPFILE

PDB$SEED(2):

PDB$SEED(2):???????? Alternatively, if these temporary tablespaces are no longer

PDB$SEED(2):???????? needed, then they can be dropped.

PDB$SEED(2):?????????? Empty temporary tablespace: TEMP

PDB$SEED(2):*********************************************************************

2025-03-11T13:12:53.936415+08:00

PDB$SEED(2):SUPLOG: Set PDB SUPLOG SGA at PDB OPEN, old 0x0, new 0x0 (no suplog)

PDB$SEED(2):Opening pdb with no Resource Manager plan active

Starting background process CJQ0

2025-03-11T13:12:54.249096+08:00

CJQ0 started with pid=77, OS id=17560_17968

Completed: alter database open

所幸客戶需要的數據直接在cdb中,直接使用expdp導出客戶需要的數據,完成本次恢復

ora-600 ktugct: corruption detected---惜分飛

相關文章

20. Excel 自動化：Excel 對象模型

IIS 服務器日志和性能監控

jenkins pipline 自動化測試

APP測試

12 File文件對象：創建、獲取基本信息、遍歷文件夾、查找文件；字符集的編解碼（黑馬Java視頻筆記）

oracle 基礎知識之多表查詢

服務器防火墻根據什么特征來過濾數據包?

Prims region.Views 為null

reconstruct_3d_object_model_for_matching例子

軟件安全性測試的重要性和常用工具介紹，軟件測試服務公司推薦

Redis項目：短信驗證碼登錄

Docker下載，包含Win、Mac

使用 ESP8266 和 Android 應用程序實現基于 IOT 的語音控制家庭自動化

【HarmonyOS Next】鴻蒙中自定義彈框OpenCustomDialog、CustomDialog與DialogHub的區別詳解

【C++】stack和queue的使用及模擬實現（含deque的簡單介紹）

Leetcode 刷題筆記1 圖論part01

《基于Workspace.java的Launcher3改造：HotSeat區域動態阻斷文件夾生成機制》

重生之我在學Vue--第14天 Vue 3 國際化(i18n)實戰指南

開源PACS（dcm4che-arc-light）部署教程，源碼方式

java使用（Preference、Properties、XML、JSON）實現處理（讀寫）配置信息或者用戶首選項的方式的代碼示例和表格對比