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

原创

于 2025-03-18 22:30:53 发布 · 1k 阅读

10 ·

CC 4.0 BY-SA版权

文章标签：

#oracle恢复

接手一个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信息今星期修改

然后重建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

最低0.47元/天解锁文章