[转载]如何解决Ora-00600 4194错误(页 1) - 常用数据库类{ Database Security } - 巨人脚下[ Oracle ] - 邪恶八进制信息安全团队技术讨论组努力为祖国的信息安全撑起一片蓝天

pub!1c 2006-2-16 17:54

[转载]如何解决Ora-00600 4194错误

信息来源:邪恶八进制信息安全团队
启动数据库出现Ora-00600 4194错误，观察alert文件，主要错误日志如下:

<TABLE>
<TBODY>
<TR>
<TD width=500 bgColor=#999999><PRE>Sat Jan 21 13:55:21 2006 Errors in file /opt/oracle/admin/conner/bdump/conner_smon_17113.trc: ORA-00600: internal error code, arguments: [4194], [43], [46], [], [], [], [], [] Sat Jan 21 13:55:21 2006 Errors in file /opt/oracle/admin/conner/udump/conner_ora_17121.trc: ORA-00600: internal error code, arguments: [4194], [45], [44], [], [], [], [], []</PRE></TD></TR></TBODY></TABLE>
4194错误通常说明UNDO段出现问题,最好的办法是通过备份进行恢复,如果没有备份,那么可以通过特殊的初始化参数进行强制启动,本文就Oracle的<A href="http://www.eygle.com/archives/2005/02/ecinaoracleaeoi.html">隐含参数</A>进行恢复说明(由于实际情况可能各不相同，进行测试前请先行备份)，仅供参考。 
首先确定当前回滚段名称，这可以从alert文件中获得:

<TABLE>
<TBODY>
<TR>
<TD width=500 bgColor=#999999><PRE>Sat Jan 21 13:55:21 2006 Undo Segment 11 Onlined Undo Segment 12 Onlined Undo Segment 13 Onlined Successfully onlined Undo Tablespace 16.</PRE></TD></TR></TBODY></TABLE>
对应的AUM (auto undo management) 下的回滚段名称为:

<TABLE>
<TBODY>
<TR>
<TD width=500 bgColor=#999999><PRE>'_SYSSMU11$','_SYSSMU12$','_SYSSMU13$'</PRE></TD></TR></TBODY></TABLE>
修改init<sid>.ora参数文件，使用Oracle隐含参数_corrupted_rollback_segments将回滚段标记为损坏，此时启动数据库，Oracle会跳过对于这些回滚段的相关操作，强制启动数据库。

<TABLE>
<TBODY>
<TR>
<TD width=500 bgColor=#999999><PRE>._corrupted_rollback_segments='_SYSSMU11$','_SYSSMU12$','_SYSSMU13$'</PRE></TD></TR></TBODY></TABLE>
<DIV id=a000657more>
<DIV id=more>
使用init<sid>.ora参数文件启动数据库:
<TABLE>
<TBODY>
<TR>
<TD width=500 bgColor=#999999><PRE>[oracle@jumper dbs]$ sqlplus "/ as sysdba"</PRE><PRE>SQL*Plus: Release 9.2.0.4.0 - Production on Sat Jan 21 13:56:47 2006</PRE><PRE>Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.</PRE><PRE>Connected to an idle instance.</PRE><PRE>SQL> startup pfile=initconner.ora ORACLE instance started.</PRE><PRE>Total System Global Area 97588504 bytes Fixed Size 451864 bytes Variable Size 33554432 bytes Database Buffers 62914560 bytes Redo Buffers 667648 bytes Database mounted. Database opened.</PRE></TD></TR></TBODY></TABLE>
此时数据库正常Open。
观察alert文件可以获得如下信息:
<TABLE>
<TBODY>
<TR>
<TD width=500 bgColor=#999999><PRE>Sat Jan 21 13:57:03 2006 SMON: enabling tx recovery SMON: about to recover undo segment 11 SMON: mark undo segment 11 as needs recovery SMON: about to recover undo segment 12 SMON: mark undo segment 12 as needs recovery SMON: about to recover undo segment 13 SMON: mark undo segment 13 as needs recovery Sat Jan 21 13:57:03 2006 Database Characterset is ZHS16GBK Sat Jan 21 13:57:03 2006 SMON: about to recover undo segment 11 SMON: mark undo segment 11 as needs recovery SMON: about to recover undo segment 12 SMON: mark undo segment 12 as needs recovery SMON: about to recover undo segment 13 SMON: mark undo segment 13 as needs recovery Sat Jan 21 13:57:04 2006 Created Undo Segment _SYSSMU1$ Undo Segment 1 Onlined Completed: ALTER DATABASE OPEN aSat Jan 21 14:02:11 2006 SMON: about to recover undo segment 11 SMON: mark undo segment 11 as needs recovery SMON: about to recover undo segment 12 SMON: mark undo segment 12 as needs recovery SMON: about to recover undo segment 13 SMON: mark undo segment 13 as needs recovery</PRE></TD></TR></TBODY></TABLE>
此时可以重新创建新的UNDO表空间，删除出现问题的表空间，修改参数文件，由参数文件生成新的spfile，重新启动数据库：
<TABLE>
<TBODY>
<TR>
<TD width=500 bgColor=#999999><PRE>SQL> create undo tablespace undotbs1 2 datafile '/opt/oracle/oradata/conner/undotbs1.dbf' size 10M;</PRE><PRE>Tablespace created.</PRE><PRE>SQL> alter system set undo_tablespace=undotbs1;</PRE><PRE>System altered.</PRE><PRE> SQL> drop tablespace undotbs2;</PRE><PRE>Tablespace dropped.</PRE></TD></TR></TBODY></TABLE>
此时的alert文件记录的:
<TABLE>
<TBODY>
<TR>
<TD width=500 bgColor=#999999><PRE>Sat Jan 21 14:03:29 2006 create undo tablespace undotbs1 datafile '/opt/oracle/oradata/conner/undotbs1.dbf' size 10M Sat Jan 21 14:03:29 2006 Created Undo Segment _SYSSMU2$ Created Undo Segment _SYSSMU3$ Created Undo Segment _SYSSMU4$ Created Undo Segment _SYSSMU5$ Created Undo Segment _SYSSMU6$ Created Undo Segment _SYSSMU7$ Created Undo Segment _SYSSMU8$ Created Undo Segment _SYSSMU9$ Created Undo Segment _SYSSMU10$ Created Undo Segment _SYSSMU14$ Starting control autobackup Control autobackup written to DISK device handle '/opt/oracle/product/9.2.0/dbs/c-3152029224-20060121-00' Completed: create undo tablespace undotbs1 datafile '/opt/ora Sat Jan 21 14:03:43 2006 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 Undo Segment 14 Onlined Successfully onlined Undo Tablespace 1. Undo Segment 1 Offlined Undo Tablespace 16 successfully switched out. Sat Jan 21 14:03:43 2006 ALTER SYSTEM SET undo_tablespace='UNDOTBS1' SCOPE=MEMORY; Sat Jan 21 14:07:18 2006 SMON: about to recover undo segment 11 SMON: mark undo segment 11 as needs recovery SMON: about to recover undo segment 12 SMON: mark undo segment 12 as needs recovery SMON: about to recover undo segment 13 SMON: mark undo segment 13 as needs recovery Sat Jan 21 14:08:06 2006 drop tablespace undotbs2 Sat Jan 21 14:08:07 2006 Starting control autobackup Control autobackup written to DISK device handle '/opt/oracle/product/9.2.0/dbs/c-3152029224-20060121-01' Completed: drop tablespace undotbs2</PRE></TD></TR></TBODY></TABLE>
修改参数文件，变更undo表空间，并取消_corrupted_rollback_segments设置:
<TABLE>
<TBODY>
<TR>
<TD width=500 bgColor=#999999><PRE>*.undo_tablespace='UNDOTBS1'</PRE></TD></TR></TBODY></TABLE>
由参数文件创建spfile文件。
<TABLE>
<TBODY>
<TR>
<TD width=500 bgColor=#999999><PRE>SQL> create spfile from pfile;</PRE><PRE>File created.</PRE><PRE>SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started.</PRE><PRE>Total System Global Area 97588504 bytes Fixed Size 451864 bytes Variable Size 33554432 bytes Database Buffers 62914560 bytes Redo Buffers 667648 bytes Database mounted. Database opened.</PRE></TD></TR></TBODY></TABLE>
重起数据库，观察alert文件:
<TABLE>
<TBODY>
<TR>
<TD width=500 bgColor=#999999><PRE>Sat Jan 21 14:08:36 2006 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 Undo Segment 14 Onlined Successfully onlined Undo Tablespace 1.</PRE></TD></TR></TBODY></TABLE>
此时数据库恢复正常，通常建议立即全库exp，然后重新建库，再imp恢复数据库。
最后附上几次启动数据库的日志供参考:
<TABLE>
<TBODY>
<TR>
<TD width=500 bgColor=#999999><PRE>Starting ORACLE instance (normal) Sat Jan 21 13:55:15 2006 WARNING: EINVAL creating segment of size 0x0000000007400000 fix shm parameters in /etc/system or equivalent LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.4.0. System parameters with non-default values: _latch_class_1 = 10000 _latch_classes = 98:1 processes = 150 timed_statistics = FALSE event = shared_pool_size = 20971520 large_pool_size = 16777216 java_pool_size = 0 _kghdsidx_count = 1 control_files = /opt/oracle/oradata/conner/control01.ctl, /opt/oracle/oradata/conner/control02.ctl, /opt/oracle/oradata/conner/control03.ctl db_block_size = 8192 db_2k_cache_size = 20971520 db_cache_size = 41943040 compatible = 9.2.0.0.0 log_archive_start = TRUE log_archive_dest = /opt/oracle/oradata/conner/archive _disable_logging = TRUE db_files = 8 db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 _allow_resetlogs_corruption= TRUE _corrupted_rollback_segments= undo_management = AUTO undo_tablespace = UNDOTBS2 undo_retention = 10800 remote_login_passwordfile= EXCLUSIVE db_domain = global_names = TRUE instance_name = conner utl_file_dir = /tmp job_queue_processes = 0 _system_trig_enabled = FALSE hash_join_enabled = TRUE background_dump_dest = /opt/oracle/admin/conner/bdump user_dump_dest = /opt/oracle/admin/conner/udump core_dump_dest = /opt/oracle/admin/conner/cdump audit_trail = DB sort_area_size = 524288 db_name = conner open_cursors = 300 sql_trace = FALSE optimizer_mode = CHOOSE star_transformation_enabled= FALSE optimizer_index_cost_adj = 10000 query_rewrite_enabled = FALSE _left_nested_loops_random= FALSE _use_nosegment_indexes = FALSE pga_aggregate_target = 20480000 aq_tm_processes = 0 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Sat Jan 21 13:55:16 2006 ARCH: STARTING ARCH PROCESSES ARC0 started with pid=8 ARC0: Archival started Sat Jan 21 13:55:16 2006 ARCH: STARTING ARCH PROCESSES COMPLETE Sat Jan 21 13:55:16 2006 ARC0: Thread not mounted ARC1 started with pid=9 ARC1: Archival started ARC1: Thread not mounted Sat Jan 21 13:55:16 2006 ALTER DATABASE MOUNT Sat Jan 21 13:55:20 2006 Successful mount of redo thread 1, with mount id 3192212932. Sat Jan 21 13:55:20 2006 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Sat Jan 21 13:55:20 2006 ALTER DATABASE OPEN Sat Jan 21 13:55:20 2006 Beginning crash recovery of 1 threads Sat Jan 21 13:55:20 2006 Started first pass scan Sat Jan 21 13:55:21 2006 Completed first pass scan 0 redo blocks read, 0 data blocks need recovery Sat Jan 21 13:55:21 2006 Started recovery at Thread 1: logseq 42, block 3, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 1 Seq 42 Reading mem 0 Mem# 0 errs 0: /opt/oracle/oradata/conner/redo01.log Sat Jan 21 13:55:21 2006 Completed redo application Sat Jan 21 13:55:21 2006 Ended recovery at Thread 1: logseq 42, block 3, scn 2073.1734548 0 data blocks read, 0 data blocks written, 0 redo blocks read Crash recovery completed successfully Sat Jan 21 13:55:21 2006 Thread 1 advanced to log sequence 43 Thread 1 opened at log sequence 43 Current log# 3 seq# 43 mem# 0: /opt/oracle/oradata/conner/redo03.log Successful open of redo thread 1. Sat Jan 21 13:55:21 2006 ARC0: Media recovery disabled Sat Jan 21 13:55:21 2006 SMON: enabling cache recovery Sat Jan 21 13:55:21 2006 Undo Segment 11 Onlined Undo Segment 12 Onlined Undo Segment 13 Onlined Successfully onlined Undo Tablespace 16. Sat Jan 21 13:55:21 2006 SMON: enabling tx recovery Sat Jan 21 13:55:21 2006 Database Characterset is ZHS16GBK Sat Jan 21 13:55:21 2006 Errors in file /opt/oracle/admin/conner/bdump/conner_smon_17113.trc: ORA-00600: internal error code, arguments: [4194], [43], [46], [], [], [], [], [] Sat Jan 21 13:55:21 2006 Errors in file /opt/oracle/admin/conner/udump/conner_ora_17121.trc: ORA-00600: internal error code, arguments: [4194], [45], [44], [], [], [], [], [] Sat Jan 21 13:55:26 2006 Recovery of Online Redo Log: Thread 1 Group 3 Seq 43 Reading mem 0 Mem# 0 errs 0: /opt/oracle/oradata/conner/redo03.log Sat Jan 21 13:55:26 2006 Recovery of Online Redo Log: Thread 1 Group 3 Seq 43 Reading mem 0 Mem# 0 errs 0: /opt/oracle/oradata/conner/redo03.log Sat Jan 21 13:55:26 2006 Recovery of Online Redo Log: Thread 1 Group 3 Seq 43 Reading mem 0 Mem# 0 errs 0: /opt/oracle/oradata/conner/redo03.log Sat Jan 21 13:55:26 2006 Recovery of Online Redo Log: Thread 1 Group 3 Seq 43 Reading mem 0 Mem# 0 errs 0: /opt/oracle/oradata/conner/redo03.log Sat Jan 21 13:55:26 2006 Errors in file /opt/oracle/admin/conner/bdump/conner_smon_17113.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: [4194], [43], [46], [], [], [], [], [] Sat Jan 21 13:55:26 2006 Errors in file /opt/oracle/admin/conner/udump/conner_ora_17121.trc: ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [4194], [45], [44], [], [], [], [], [] Error 607 happened during db open, shutting down database USER: terminating instance due to error 607 Instance terminated by USER, pid = 17121 ORA-1092 signalled during: ALTER DATABASE OPEN...</PRE><PRE>Sat Jan 21 13:56:58 2006 Starting ORACLE instance (normal) Sat Jan 21 13:56:58 2006 WARNING: EINVAL creating segment of size 0x0000000006400000 fix shm parameters in /etc/system or equivalent LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.4.0. System parameters with non-default values: _latch_class_1 = 10000 _latch_classes = 98:1 processes = 150 timed_statistics = FALSE shared_pool_size = 20971520 large_pool_size = 0 java_pool_size = 0 _kghdsidx_count = 1 control_files = /opt/oracle/oradata/conner/control01.ctl, /opt/oracle/oradata/conner/control02.ctl, /opt/oracle/oradata/conner/control03.ctl db_block_size = 8192 db_2k_cache_size = 20971520 db_cache_size = 41943040 compatible = 9.2.0.0.0 log_archive_start = TRUE log_archive_dest = /opt/oracle/oradata/conner/archive _disable_logging = TRUE db_files = 8 db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 _allow_resetlogs_corruption= TRUE _corrupted_rollback_segments= _SYSSMU11$, _SYSSMU12$, _SYSSMU13$ undo_management = AUTO undo_tablespace = UNDOTBS2 undo_retention = 10800 remote_login_passwordfile= EXCLUSIVE db_domain = global_names = TRUE instance_name = conner utl_file_dir = /tmp job_queue_processes = 0 _system_trig_enabled = FALSE hash_join_enabled = TRUE background_dump_dest = /opt/oracle/admin/conner/bdump user_dump_dest = /opt/oracle/admin/conner/udump core_dump_dest = /opt/oracle/admin/conner/cdump audit_trail = DB sort_area_size = 524288 db_name = conner open_cursors = 300 sql_trace = FALSE optimizer_mode = CHOOSE star_transformation_enabled= FALSE optimizer_index_cost_adj = 10000 query_rewrite_enabled = FALSE _left_nested_loops_random= FALSE _use_nosegment_indexes = FALSE pga_aggregate_target = 20480000 aq_tm_processes = 0 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 Sat Jan 21 13:56:58 2006 ARCH: STARTING ARCH PROCESSES RECO started with pid=7 ARC0 started with pid=8 ARC0: Archival started ARC1 started with pid=9 Sat Jan 21 13:56:58 2006 ARCH: STARTING ARCH PROCESSES COMPLETE Sat Jan 21 13:56:58 2006 ARC1: Archival started ARC1: Thread not mounted Sat Jan 21 13:56:58 2006 ARC0: Thread not mounted Sat Jan 21 13:56:58 2006 ALTER DATABASE MOUNT Sat Jan 21 13:57:03 2006 Successful mount of redo thread 1, with mount id 3192214826. Sat Jan 21 13:57:03 2006 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Sat Jan 21 13:57:03 2006 ALTER DATABASE OPEN Sat Jan 21 13:57:03 2006 Beginning crash recovery of 1 threads Sat Jan 21 13:57:03 2006 Started first pass scan Sat Jan 21 13:57:03 2006 Completed first pass scan 0 redo blocks read, 0 data blocks need recovery Sat Jan 21 13:57:03 2006 Started recovery at Thread 1: logseq 44, block 2, scn 2073.1754552 Recovery of Online Redo Log: Thread 1 Group 4 Seq 44 Reading mem 0 Mem# 0 errs 0: /opt/oracle/oradata/conner/redo04.log Sat Jan 21 13:57:03 2006 Completed redo application Sat Jan 21 13:57:03 2006 Ended recovery at Thread 1: logseq 44, block 2, scn 2073.1774553 0 data blocks read, 0 data blocks written, 0 redo blocks read Crash recovery completed successfully Sat Jan 21 13:57:03 2006 Thread 1 advanced to log sequence 45 Thread 1 opened at log sequence 45 Current log# 2 seq# 45 mem# 0: /opt/oracle/oradata/conner/redo02.log Successful open of redo thread 1. Sat Jan 21 13:57:03 2006 ARC0: Media recovery disabled Sat Jan 21 13:57:03 2006 SMON: enabling cache recovery Sat Jan 21 13:57:03 2006 Successfully onlined Undo Tablespace 16. Sat Jan 21 13:57:03 2006 SMON: enabling tx recovery SMON: about to recover undo segment 11 SMON: mark undo segment 11 as needs recovery SMON: about to recover undo segment 12 SMON: mark undo segment 12 as needs recovery SMON: about to recover undo segment 13 SMON: mark undo segment 13 as needs recovery Sat Jan 21 13:57:03 2006 Database Characterset is ZHS16GBK Sat Jan 21 13:57:03 2006 SMON: about to recover undo segment 11 SMON: mark undo segment 11 as needs recovery SMON: about to recover undo segment 12 SMON: mark undo segment 12 as needs recovery SMON: about to recover undo segment 13 SMON: mark undo segment 13 as needs recovery Sat Jan 21 13:57:04 2006 Created Undo Segment _SYSSMU1$ Undo Segment 1 Onlined Completed: ALTER DATABASE OPEN aSat Jan 21 14:02:11 2006 SMON: about to recover undo segment 11 SMON: mark undo segment 11 as needs recovery SMON: about to recover undo segment 12 SMON: mark undo segment 12 as needs recovery SMON: about to recover undo segment 13 SMON: mark undo segment 13 as needs recovery Sat Jan 21 14:03:29 2006 create undo tablespace undotbs1 datafile '/opt/oracle/oradata/conner/undotbs1.dbf' size 10M Sat Jan 21 14:03:29 2006 Created Undo Segment _SYSSMU2$ Created Undo Segment _SYSSMU3$ Created Undo Segment _SYSSMU4$ Created Undo Segment _SYSSMU5$ Created Undo Segment _SYSSMU6$ Created Undo Segment _SYSSMU7$ Created Undo Segment _SYSSMU8$ Created Undo Segment _SYSSMU9$ Created Undo Segment _SYSSMU10$ Created Undo Segment _SYSSMU14$ Starting control autobackup Control autobackup written to DISK device handle '/opt/oracle/product/9.2.0/dbs/c-3152029224-20060121-00' Completed: create undo tablespace undotbs1 datafile '/opt/ora Sat Jan 21 14:03:43 2006 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 Undo Segment 14 Onlined Successfully onlined Undo Tablespace 1. Undo Segment 1 Offlined Undo Tablespace 16 successfully switched out. Sat Jan 21 14:03:43 2006 ALTER SYSTEM SET undo_tablespace='UNDOTBS1' SCOPE=MEMORY; Sat Jan 21 14:07:18 2006 SMON: about to recover undo segment 11 SMON: mark undo segment 11 as needs recovery SMON: about to recover undo segment 12 SMON: mark undo segment 12 as needs recovery SMON: about to recover undo segment 13 SMON: mark undo segment 13 as needs recovery Sat Jan 21 14:08:06 2006 drop tablespace undotbs2 Sat Jan 21 14:08:07 2006 Starting control autobackup Control autobackup written to DISK device handle '/opt/oracle/product/9.2.0/dbs/c-3152029224-20060121-01' Completed: drop tablespace undotbs2 Sat Jan 21 14:08:23 2006 Shutting down instance: further logons disabled Shutting down instance (immediate) License high water mark = 1 Sat Jan 21 14:08:23 2006 ALTER DATABASE CLOSE NORMAL Sat Jan 21 14:08:23 2006 SMON: disabling tx recovery SMON: disabling cache recovery Sat Jan 21 14:08:23 2006 Shutting down archive processes Archiving is disabled Sat Jan 21 14:08:23 2006 ARCH shutting down ARC0: Archival stopped Sat Jan 21 14:08:23 2006 ARCH shutting down ARC1: Archival stopped Sat Jan 21 14:08:23 2006 Thread 1 closed at log sequence 45 Successful close of redo thread 1. Sat Jan 21 14:08:23 2006 Completed: ALTER DATABASE CLOSE NORMAL Sat Jan 21 14:08:23 2006 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archiving is disabled Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active Sat Jan 21 14:08:30 2006 Starting ORACLE instance (normal) Sat Jan 21 14:08:31 2006 WARNING: EINVAL creating segment of size 0x0000000006400000 fix shm parameters in /etc/system or equivalent LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.4.0. System parameters with non-default values: _latch_class_1 = 10000 _latch_classes = 98:1 processes = 150 timed_statistics = FALSE shared_pool_size = 20971520 large_pool_size = 0 java_pool_size = 0 _kghdsidx_count = 1 control_files = /opt/oracle/oradata/conner/control01.ctl, /opt/oracle/oradata/conner/control02.ctl, /opt/oracle/oradata/conner/control03.ctl db_block_size = 8192 db_2k_cache_size = 20971520 db_cache_size = 41943040 compatible = 9.2.0.0.0 log_archive_start = TRUE log_archive_dest = /opt/oracle/oradata/conner/archive _disable_logging = TRUE db_files = 8 db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 _allow_resetlogs_corruption= TRUE _corrupted_rollback_segments= undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 remote_login_passwordfile= EXCLUSIVE db_domain = global_names = TRUE instance_name = conner utl_file_dir = /tmp job_queue_processes = 0 _system_trig_enabled = FALSE hash_join_enabled = TRUE background_dump_dest = /opt/oracle/admin/conner/bdump user_dump_dest = /opt/oracle/admin/conner/udump core_dump_dest = /opt/oracle/admin/conner/cdump audit_trail = DB sort_area_size = 524288 db_name = conner open_cursors = 300 sql_trace = FALSE optimizer_mode = CHOOSE star_transformation_enabled= FALSE optimizer_index_cost_adj = 10000 query_rewrite_enabled = FALSE _left_nested_loops_random= FALSE _use_nosegment_indexes = FALSE pga_aggregate_target = 20480000 aq_tm_processes = 0 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Sat Jan 21 14:08:31 2006 ARCH: STARTING ARCH PROCESSES ARC0 started with pid=8 ARC0: Archival started Sat Jan 21 14:08:31 2006 ARCH: STARTING ARCH PROCESSES COMPLETE Sat Jan 21 14:08:31 2006 ARC0: Thread not mounted ARC1 started with pid=9 ARC1: Archival started ARC1: Thread not mounted Sat Jan 21 14:08:31 2006 ALTER DATABASE MOUNT Sat Jan 21 14:08:36 2006 Successful mount of redo thread 1, with mount id 3192249311. Sat Jan 21 14:08:36 2006 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Sat Jan 21 14:08:36 2006 ALTER DATABASE OPEN Sat Jan 21 14:08:36 2006 Thread 1 opened at log sequence 45 Current log# 2 seq# 45 mem# 0: /opt/oracle/oradata/conner/redo02.log Successful open of redo thread 1. Sat Jan 21 14:08:36 2006 ARC1: Media recovery disabled Sat Jan 21 14:08:36 2006 SMON: enabling cache recovery Sat Jan 21 14:08:36 2006 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 Undo Segment 14 Onlined Successfully onlined Undo Tablespace 1. Sat Jan 21 14:08:36 2006 SMON: enabling tx recovery Sat Jan 21 14:08:36 2006 Database Characterset is ZHS16GBK Completed: ALTER DATABASE OPEN</PRE></TD></TR></TBODY></TABLE>----- </DIV></DIV>

页: [1]

邪恶八进制信息安全团队技术讨论组's Archiver

[转载]如何解决Ora-00600 4194错误