[oracle@primary ~]$ sqlplus / as sysdba

　　SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 16 22:13:18 2012

　　Copyright (c) 1982, 2005, Oracle. All rights reserved.

　　Connected to an idle instance.

　　SQL> startup;

　　ORACLE instance started.

　　Total System Global Area 650117120 bytes

　　Fixed Size 1221108 bytes

　　Variable Size 239078924 bytes

　　Database Buffers 406847488 bytes

　　Redo Buffers 2969600 bytes

　　Database mounted.

　　ORA-01092: ORACLE instance terminated. Disconnection forced

　　Alert日志中出现：

　　LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2

　　******************************************************************

　　Sun Sep 16 22:13:42 2012

　　Errors in file /db/oracle/oracle/admin/xiaoyu/udump/xiaoyu_ora_3140.trc:

　　ORA-00704: bootstrap process failure

　　ORA-00604: error occurred at recursive SQL level 1

　　ORA-01013: user requested cancel of current operation

　　Sun Sep 16 22:13:42 2012

　　Error 704 happened during db open, shutting down database

　　USER: terminating instance due to error 704

　　Instance terminated by USER, pid = 3140

　　ORA-1092 signalled during: ALTER DATABASE OPEN...

　　Bootstrap$初始化错误，如果在mount状态做sql_trace跟踪，可以看见数据库的第一次初始化是在内存中创建bootstrap$基表，然后和数据文件创建各种object,感觉还是很奇怪的，虽然这是本机的虚拟机，上面是一个db的primary db，不过并没有手动修改过bootstrap$基表，而且没有进行数据库的升降级。

　　[root@primary ~]# less /db/oracle/oracle/admin/xiaoyu/udump/xiaoyu_ora_3140.trc

　　…..

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

　　----- Recovery Hash Table Statistics ---------

　　Hash table buckets = 32768

　　Longest hash chain = 1

　　Average hash chain = 23/23 = 1.0

　　Max compares per lookup = 1

　　Avg compares per lookup = 72/80 = 0.9

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

　　tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)

　　tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)

　　ORA-00704: bootstrap process failure

　　ORA-00604: error occurred at recursive SQL level 1

　　ORA-01013: user requested cancel of current operation

　　(END)

　　Bug 4704334 - ''TKCRRSARC: (WARN) '

　　This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

　　Applies to:

　　Oracle Server - Enterprise Edition - Version: 10.2.0.1

　　This problem can occur on any platform.

　　Symptoms

　　- After starting the database receive the following errors in trace file:>

　　tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)

　　tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)

　　<<

　　- After manual performing log switches the following messages occur in the alert.log:>

　　Shutting down archive processes

　　Wed Oct 19 14:13:22 2005

　　ARCH shutting down

　　ARC2: Archival stopped

　　<<

　　Cause

　　Bug 4704334 - ''TKCRRSARC: (WARN) FAILED TO FIND ARCH FOR MESSAGE (MESSAGE:0X1)''

　　These messages are warning messages and are a consequence of the internal archive process spawning and releasing.

　　There can be different reasons for this message to appear, but it is in fact related to internal work.

　　Solution

　　These are only diagnostic messages and can be safely ignored.

　　However, there are two options:

　　Option 1

　　Ignore the messages.

　　Option 2

　　Increase the log_archive_max_processes equal to/or greater than 10

　　按照mos的建议手动增加了原来的log_archive_max_processes参数到4，再次启动正常。

　　SQL> show parameter log_archive_max_processes;

　　NAME TYPE

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

　　VALUE

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

　　log_archive_max_processes integer

　　2

　　SQL> alter system set log_archive_max_processes=4;

　　System altered.

　　SQL> startup force ;

　　ORACLE instance started.

　　Total System Global Area 650117120 bytes

　　Fixed Size 1221108 bytes

　　Variable Size 239078924 bytes

　　Database Buffers 406847488 bytes

　　Redo Buffers 2969600 bytes

　　Database mounted.

　　Database opened.

[@more@]