« Oracle队列等待: enq: IS - contention 阻塞启动 | Blog首页 | Oracle等待事件: resmgr:cpu quantum引发CPU冲高 »

Oracle数据恢复:ORA-600 4097错误解决案例一则

Tue Jul 12 09:26:09 2011

Errors in file /oracle/socl/admin/bdump/socl_smon_909326.trc:

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

Tue Jul 12 09:26:10 2011

Non-fatal internal error happenned while SMON was doing logging scn->time mapping.

SMON encountered 1 out of maximum 100 non-fatal internal errors.

Tue Jul 12 09:31:12 2011

Errors in file /oracle/socl/admin/bdump/socl_smon_909326.trc:

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

Tue Jul 12 09:31:13 2011

Non-fatal internal error happenned while SMON was doing logging scn->time mapping.

SMON encountered 2 out of maximum 100 non-fatal internal errors.

rem

rem create the scn<->time tracking table that smon will maintain

rem as a circular queue - notice that we populate the entire

rem table with at least 144000 entries (enough for 5 days).

rem

rem -"thread" is for backward compatibility and is always 0

rem -"orig_thread" is for upgrade/downgrade

rem - scn_wrp, scn_bas, and time_dp are for backward compatibility

rem   and not queried by the ktf layer.

rem

create cluster smon_scn_to_time (

  thread number                         /* thread, compatibility */

)

/

create index smon_scn_to_time_idx on cluster smon_scn_to_time

/

create table smon_scn_time (

  thread number,                         /* thread, compatibility */

  time_mp number,                        /* time this recent scn represents */

  time_dp date,                          /* time as date, compatibility */

  scn_wrp number,                        /* scn.wrp, compatibility */

  scn_bas number,                        /* scn.bas, compatibility */

  num_mappings number,

  tim_scn_map raw(1200),

  scn number default 0,                  /* scn */

  orig_thread number default 0           /* for downgrade */

) cluster smon_scn_to_time (thread)

/

create unique index smon_scn_time_tim_idx on smon_scn_time(time_mp)

/

create unique index smon_scn_time_scn_idx on smon_scn_time(scn)

/

soclrac01:oracle:[/oracle/socl/admin/bdump]#sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 12 09:41:09 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from smon_scn_time;

  COUNT(*)

----------

      1743

SQL> truncate table smon_scn_time;

truncate table smon_scn_time

               *

ERROR at line 1:

ORA-03292: Table to be truncated is part of a cluster

SQL> delete from smon_scn_time ;

delete from smon_scn_time

            *

ERROR at line 1:

ORA-08102: index key not found, obj# 577, file 1, block 69410 (2)

SQL> truncate cluster smon_scn_to_time;

Cluster truncated.

SQL> select count(*) from smon_scn_time;

  COUNT(*)

----------

         0

SQL> 

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1224736768 bytes

Fixed Size                  2083664 bytes

Variable Size             318768304 bytes

Database Buffers          889192448 bytes

Redo Buffers               14692352 bytes

Database mounted.

Database opened.

SQL> select count(*) from smon_scn_time;

  COUNT(*)

----------

         1

By eygle on 2011-07-19 08:48 | Comments (0) | Backup&Recovery | 2838 |

oerrorora-600