ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ora-600[2662]和[4193]错误处理

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

原创 Linux操作系统 作者:deitylee 时间:2013-09-25 15:59:08 0 删除 编辑
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

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

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

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

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

 

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

 

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

*.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='AUTO'

*.undo_retention=10800

*.undo_tablespace='UNDOTBS2'

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

 

SQL> shutdown immediate;

Database closed.

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;

 

Database altered.

 

SQL> show parameter undo

 

NAME                                 TYPE        VALUE

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

undo_management                      string      AUTO

undo_retention                       integer     10800

undo_suppress_errors                 boolean     FALSE

undo_tablespace                      string      UNDOTBS2

 

SQL> drop tablespace undotbs1 including contents and datafiles;

 

Tablespace dropped.

 

 

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16381228/viewspace-773362/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Linux时间同步
请登录后发表评论 登录
全部评论

注册时间:2011-10-27

最新文章