ora-600[2662]和[4193]错误处理

最新推荐文章于 2020-07-29 23:31:45 发布

csdnww1209

最新推荐文章于 2020-07-29 23:31:45 发布

阅读量331

点赞数

Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE

[oracle@jszg ~]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Sep 24 12:46:58 2013

SQL> conn / as sysdba

Connected.

SQL> select open_mode from v$database;

OPEN_MODE

----------

MOUNTED

SQL> alter database open;

alter database open

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

alter database open resetlogs

ERROR at line 1:

ORA-01113: file 1 needs media recovery

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

SQL> recover datafile 1;

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database using backup controlfile;

ORA-00279: change 6330749 generated at 09/09/2013 11:32:46 needed for thread 1

ORA-00289: suggestion : /u01/oracle/product/9.2.0/dbs/arch1_29.dbf

ORA-00280: change 6330749 for thread 1 is in sequence #29

Specify log: {=suggested | filename | AUTO | CANCEL}

auto

ORA-00308: cannot open archived log

'/u01/oracle/product/9.2.0/dbs/arch1_29.dbf'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

ORA-00308: cannot open archived log

'/u01/oracle/product/9.2.0/dbs/arch1_29.dbf'

ORA-27037: unable to obtain file status

Linux Error: 2: No such file or directory

Additional information: 3

SQL> alter database open;

alter database open

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open noresetlogs;

alter database open noresetlogs

ERROR at line 1:

ORA-01588: must use RESETLOGS option for database open

SQL> alter database open resetlogs;

alter database open resetlogs

ERROR at line 1:

ORA-01113: file 1 needs media recovery

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

SQL> recover datafile 1;

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;

System altered.

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS

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

FIRST_CHANGE# FIRST_TIM

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

1 1 35 104857600 1 NO INACTIVE

8425221 16-SEP-13

2 1 36 104857600 1 NO INACTIVE

8767741 17-SEP-13

3 1 37 104857600 1 NO CURRENT

9112821 18-SEP-13

SQL> recover database until cancel;

ORA-00283: recovery session canceled due to errors

ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> create pfile='/tmp/pfile' from spfile;

File created.

SQL> exit

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.4.0 - Production

[oracle@jszg ~]$ vi /tmp/pfile

*._allow_resetlogs_corruption=TRUE

*.aq_tm_processes=1

*.background_dump_dest='/u01/oracle//admin/NINVOICE/bdump'

*.compatible='9.2.0.0.0'

*.control_files='/u01/oracle/oradata/NINVOICE/control01.ctl','/u01/oracle/oradata/NINVOICE/control02.ctl','/u01/oracle/oradata/NINVOICE/control03.ctl'

*.core_dump_dest='/u01/oracle//admin/NINVOICE/cdump'

*.db_block_size=8192

*.db_cache_size=33554432

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='NINVOICE'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=NINVOICEXDB)'

*.fast_start_mttr_target=300

*.hash_join_enabled=TRUE

*.instance_name='NINVOICE'

*.java_pool_size=83886080

*.job_queue_processes=10

*.large_pool_size=16777216

*.open_cursors=300

*.pga_aggregate_target=25165824

*.processes=150

*.query_rewrite_enabled='FALSE'

*.remote_login_passwordfile='EXCLUSIVE'

*.shared_pool_size=83886080

[oracle@jszg ~]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Tue Sep 24 13:14:35 2013

SQL> conn / as sysdba

Connected.

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> startup pfile='/tmp/pfile' mount;

ORACLE instance started.

Total System Global Area 236000356 bytes

Fixed Size 451684 bytes

Variable Size 201326592 bytes

Database Buffers 33554432 bytes

Redo Buffers 667648 bytes

Database mounted.

SQL> alter database open;

alter database open

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

alter database open resetlogs

ERROR at line 1:

ORA-03113: end-of-file on communication channel

[root@jszg bdump]# vi alert_NINVOICE.log

Thu Aug 22 13:20:25 2013

alter database rename global_name to NINVOICE

Completed: alter database rename global_name to NINVOICE

Thu Aug 22 13:20:25 2013

ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oracle/oradata/NINVOICE/temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED

Completed: ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oracle/or

Thu Aug 22 13:20:25 2013

alter database character set INTERNAL_CONVERT AL32UTF8

Updating character set in controlfile to AL32UTF8

SYS.SNAP$ (REL_QUERY) - CLOB representation altered

SYS.METASTYLESHEET (STYLESHEET) - CLOB representation altered

SYS.EXTERNAL_TAB$ (PARAM_CLOB) - CLOB representation altered

XDB.XDB$RESOURCE (SYS_NC00027$) - CLOB representation altered

ODM.ODM_PMML_DTD (DTD) - CLOB representation altered

OE.WAREHOUSES (SYS_NC00003$) - CLOB representation altered

PM.ONLINE_MEDIA (SYS_NC00042$) - CLOB representation altered

PM.ONLINE_MEDIA (SYS_NC00062$) - CLOB representation altered

PM.ONLINE_MEDIA (PRODUCT_TEXT) - CLOB representation altered

PM.ONLINE_MEDIA (SYS_NC00080$) - CLOB representation altered

PM.PRINT_MEDIA (AD_SOURCETEXT) - CLOB representation altered

PM.PRINT_MEDIA (AD_FINALTEXT) - CLOB representation altered

Completed: alter database character set INTERNAL_CONVERT AL32

Thu Aug 22 13:20:35 2013

alter database national character set INTERNAL_CONVERT AL16UTF16

alter database open resetlogs

RESETLOGS is being done without consistancy checks. This may result

in a corrupted database. The database should be recreated.

RESETLOGS after incomplete recovery UNTIL CHANGE 6330749

Resetting resetlogs activation ID 0 (0x0)

Tue Sep 24 13:20:05 2013

Assigning activation ID 3433913633 (0xccad5d21)

Thread 1 opened at log sequence 1

Current log# 3 seq# 1 mem# 0: /u01/oracle/oradata/NINVOICE/redo03.log

Successful open of redo thread 1.

Tue Sep 24 13:20:05 2013

SMON: enabling cache recovery

Tue Sep 24 13:20:05 2013

Errors in file /u01/oracle/admin/NINVOICE/udump/ninvoice_ora_30056.trc:

ORA-00600: internal error code, arguments: [2662], [0], [6330754], [0], [9196449], [8388617], [], []

Tue Sep 24 13:20:10 2013

Errors in file /u01/oracle/admin/NINVOICE/udump/ninvoice_ora_30056.trc:

ORA-00600: internal error code, arguments: [2662], [0], [6330754], [0], [9196449], [8388617], [], []

Tue Sep 24 13:20:10 2013

Error 600 happened during db open, shutting down database

USER: terminating instance due to error 600

Instance terminated by USER, pid = 30056

ORA-1092 signalled during: alter database open resetlogs...

SQL> conn / as sysdba

Connected to an idle instance.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 236000356 bytes

Fixed Size 451684 bytes

Variable Size 201326592 bytes

Database Buffers 33554432 bytes

Redo Buffers 667648 bytes

Database mounted.

SQL> alter session set events '10015 trace name ADJUST_SCN level 1';

Session altered.

SQL> alter database open;

alter database open

ERROR at line 1:

ORA-01092: ORACLE instance terminated. Disconnection forced

[root@jszg bdump]# vi alert_NINVOICE.log

Tue Sep 24 13:58:22 2013

Recovery of Online Redo Log: Thread 1 Group 2 Seq 3 Reading mem 0

Mem# 0 errs 0: /u01/oracle/oradata/NINVOICE/redo02.log

Tue Sep 24 13:58:22 2013

Errors in file /u01/oracle/admin/NINVOICE/udump/ninvoice_ora_30240.trc:

ORA-00607: Internal error occurred while making a change to a data block

ORA-00600: internal error code, arguments: [4193], [221], [224], [], [], [], [], []

Error 607 happened during db open, shutting down database

USER: terminating instance due to error 607

Instance terminated by USER, pid = 30240

ORA-1092 signalled during: alter database open...

Tue Sep 24 14:00:49 2013

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

SCN scheme 2

Using log_archive_dest parameter default value

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up ORACLE RDBMS Version: 9.2.0.4.0.

System parameters with non-default values:

processes = 150

timed_statistics = TRUE

shared_pool_size = 83886080

Successfully onlined Undo Tablespace 1.

Tue Sep 24 14:09:53 2013

SMON: enabling tx recovery

Tue Sep 24 14:09:54 2013

Errors in file /u01/oracle/admin/NINVOICE/bdump/ninvoice_smon_30252.trc:

ORA-00600: internal error code, arguments: [4193], [221], [224], [], [], [], [], []

Tue Sep 24 14:09:54 2013

Database Characterset is AL32UTF8

Tue Sep 24 14:09:54 2013

Errors in file /u01/oracle/admin/NINVOICE/udump/ninvoice_ora_30264.trc:

ORA-00600: internal error code, arguments: [4193], [295], [257], [], [], [], [], []

Tue Sep 24 14:09:53 2013

SMON: enabling cache recovery

Tue Sep 24 14:09:53 2013

Undo Segment 1 Onlined

Undo Segment 2 Onlined

Undo Segment 3 Onlined

Undo Segment 4 Onlined

Undo Segment 5 Onlined

Undo Segment 6 Onlined

Undo Segment 7 Onlined

Undo Segment 8 Onlined

Undo Segment 9 Onlined

Undo Segment 10 Onlined

Successfully onlined Undo Tablespace 1.

Tue Sep 24 14:09:53 2013

SMON: enabling tx recovery

Tue Sep 24 14:09:54 2013

Errors in file /u01/oracle/admin/NINVOICE/bdump/ninvoice_smon_30252.trc:

ORA-00600: internal error code, arguments: [4193], [221], [224], [], [], [], [], []

Tue Sep 24 14:09:54 2013

Database Characterset is AL32UTF8

Tue Sep 24 14:09:54 2013

Errors in file /u01/oracle/admin/NINVOICE/udump/ninvoice_ora_30264.trc:

ORA-00600: internal error code, arguments: [4193], [295], [257], [], [], [], [], []

Tue Sep 24 14:10:09 2013

Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0

Mem# 0 errs 0: /u01/oracle/oradata/NINVOICE/redo03.log

Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0

Mem# 0 errs 0: /u01/oracle/oradata/NINVOICE/redo03.log

Tue Sep 24 14:10:10 2013

Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0

Mem# 0 errs 0: /u01/oracle/oradata/NINVOICE/redo03.log

Tue Sep 24 14:10:10 2013

Errors in file /u01/oracle/admin/NINVOICE/bdump/ninvoice_smon_30252.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-00607: Internal error occurred while making a change to a data block

ORA-00600: internal error code, arguments: [4193], [221], [224], [], [], [], [], []

Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0

Mem# 0 errs 0: /u01/oracle/oradata/NINVOICE/redo03.log

Tue Sep 24 14:10:10 2013

Errors in file /u01/oracle/admin/NINVOICE/udump/ninvoice_ora_30264.trc:

ORA-00607: Internal error occurred while making a change to a data block

ORA-00600: internal error code, arguments: [4193], [295], [257], [], [], [], [], []

Error 607 happened during db open, shutting down database

USER: terminating instance due to error 607

Instance terminated by USER, pid = 30264

ORA-1092 signalled during: alter database open ...

[oracle@jszg ~]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Sep 25 11:11:15 2013

SQL> conn / as sysdba

Connected.

SQL> create pfile='/tmp/pfile' from spfile;

File created.

SQL> show parameter undo

NAME TYPE VALUE

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

undo_management string AUTO

undo_retention integer 10800

undo_suppress_errors boolean FALSE

undo_tablespace string UNDOTBS1

SQL> shutdown immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

[root@jszg bdump]# vi /tmp/pfile

*.db_block_size=8192

*.db_cache_size=33554432

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='NINVOICE'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=NINVOICEXDB)'

*.fast_start_mttr_target=300

*.hash_join_enabled=TRUE

*.instance_name='NINVOICE'

*.java_pool_size=83886080

*.job_queue_processes=10

*.large_pool_size=16777216

*.open_cursors=300

*.pga_aggregate_target=25165824

*.processes=150

*.query_rewrite_enabled='FALSE'

*.remote_login_passwordfile='EXCLUSIVE'

*.shared_pool_size=83886080

*.sort_area_size=524288

*.star_transformation_enabled='FALSE'

*.timed_statistics=TRUE

*.undo_management='MANUAL'

*.undo_retention=10800

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/u01/oracle/admin/NINVOICE/udump'

"/tmp/pfile" 31L, 1057C written

SQL> startup pfile='/tmp/pfile' mount;

ORACLE instance started.

Total System Global Area 236000356 bytes

Fixed Size 451684 bytes

Variable Size 201326592 bytes

Database Buffers 33554432 bytes

Redo Buffers 667648 bytes

Database mounted.

SQL> alter database open;

Database altered.

SQL> create undo tablespace undotbs2 datafile '/u01/oracle/oradata/NINVOICE/udotbs02.dbf' size 100m;

Tablespace created.

SQL> show parameter undo

NAME TYPE VALUE

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

undo_management string MANUAL

undo_retention integer 10800

undo_suppress_errors boolean FALSE

undo_tablespace string UNDOTBS1

SQL> alter system set undo_management=AUTO;

alter system set undo_management=AUTO

ERROR at line 1:

ORA-02095: specified initialization parameter cannot be modified

[root@jszg bdump]# vi /tmp/pfile

*._allow_resetlogs_corruption=TRUE

*.aq_tm_processes=1

*.background_dump_dest='/u01/oracle/admin/NINVOICE/bdump'

*.compatible='9.2.0.0.0'

*.control_files='/u01/oracle/oradata/NINVOICE/control01.ctl','/u01/oracle/oradata/NINVOICE/control02.ctl','/u01/oracle/oradata/NINVOICE/control03.ctl'

*.core_dump_dest='/u01/oracle/admin/NINVOICE/cdump'

*.db_block_size=8192

*.db_cache_size=33554432

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='NINVOICE'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=NINVOICEXDB)'

*.fast_start_mttr_target=300

*.hash_join_enabled=TRUE

*.instance_name='NINVOICE'

*.java_pool_size=83886080

*.job_queue_processes=10