数据库启动问题

今天早上本来想马上看数据库视图练习
无奈数据库老是启动不起来
没有任何错误信息

*.log
Sun May 03 09:07:28 2009
Setting recovery target incarnation to 2
Sun May 03 09:07:28 2009
Successful mount of redo thread 1, with mount id 1213632972
Sun May 03 09:07:28 2009
Database mounted in Exclusive Mode
Completed: alter database mount
Sun May 03 09:07:43 2009
alter database mount
Sun May 03 09:07:43 2009
ORA-1100 signalled during: alter database mount...
Sun May 03 09:07:51 2009
alter database open
Sun May 03 09:07:51 2009
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=16, OS id=3028
Sun May 03 09:07:51 2009
ARC0: Archival started
ARC1 started with pid=17, OS id=4032
Sun May 03 09:07:51 2009
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Sun May 03 09:07:51 2009
ARC0: STARTING ARCH PROCESSES
Sun May 03 09:07:51 2009
Thread 1 opened at log sequence 6
Sun May 03 09:07:51 2009
ARC1: Becoming the 'no FAL' ARCH
Sun May 03 09:07:51 2009
Current log# 2 seq# 6 mem# 0: E:ORACLEPRODUCT10.2.0ORADATAORCLREDO02.LOG
Sun May 03 09:07:51 2009
ARC1: Becoming the 'no SRL' ARCH
Sun May 03 09:07:51 2009
Successful open of redo thread 1
Sun May 03 09:07:51 2009
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sun May 03 09:07:51 2009
SMON: enabling cache recovery
Sun May 03 09:07:51 2009
ARC2: Archival started
ARC2 started with pid=18, OS id=2348
Sun May 03 09:07:51 2009
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
Sun May 03 09:07:51 2009
Successfully onlined Undo Tablespace 1.
Sun May 03 09:07:51 2009
SMON: enabling tx recovery
Sun May 03 09:07:51 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=19, OS id=2292
Sun May 03 09:07:52 2009
db_recovery_file_dest_size of 2048 MB is 0.55% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Sun May 03 09:07:53 2009
Completed: alter database open
Sun May 03 09:09:23 2009
Starting background process EMN0
EMN0 started with pid=29, OS id=3908
Sun May 03 09:09:23 2009
Shutting down instance: further logons disabled
Sun May 03 09:09:30 2009
Stopping background process CJQ0
Sun May 03 09:09:30 2009
Stopping background process QMNC
Sun May 03 09:09:30 2009
Stopping background process MMNL
Sun May 03 09:09:31 2009
Stopping background process MMON
Sun May 03 09:09:32 2009
Shutting down instance (immediate)
License high water mark = 8
Sun May 03 09:09:33 2009
Stopping Job queue slave processes
Sun May 03 09:09:33 2009
Job queue slave processes stopped
All dispatchers and shared servers shutdown
Sun May 03 09:09:49 2009
alter database close normal
Sun May 03 09:09:51 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Sun May 03 09:09:51 2009
Shutting down archive processes
Archiving is disabled
Sun May 03 09:09:57 2009
ARCH shutting down
ARC2: Archival stopped
Sun May 03 09:10:02 2009
ARCH shutting down
ARC1: Archival stopped
Sun May 03 09:10:07 2009
ARCH shutting down
ARC0: Archival stopped
Sun May 03 09:10:08 2009
Thread 1 closed at log sequence 6
Successful close of redo thread 1
Sun May 03 09:10:08 2009
Completed: alter database close normal
Sun May 03 09:10:08 2009
alter database dismount
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active

跟踪文件
Dump file e:oracleproduct10.2.0adminorcludumporcl_ora_428.trc
Sun May 03 08:59:29 2009
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows XP Version V5.1 Service Pack 3
CPU : 1 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:254M/991M, Ph+PgF:1412M/2388M, VA:1542M/2047M
Instance name: orcl

Redo thread mounted by this instance: 0

Oracle process number: 23

Windows thread id: 428, image: ORACLE.EXE (SHAD)

*** 2009-05-03 08:59:29.296
*** SERVICE NAME:() 2009-05-03 08:59:29.281
*** SESSION ID:(141.4) 2009-05-03 08:59:29.281
*** 2009-05-03 08:59:29.281 60680 kcrr.c
ARCH: Archival disabled due to shutdown: 1089
*** 2009-05-03 08:59:30.312 60680 kcrr.c
ARCH: Archival disabled due to shutdown: 1089

跟踪文件信息也很无奈！！
最后发现原来是监听坏了和实例坏了！！
不过解决问题多多了个思路（系统日志和数据库日志要结合起来）

[@more@]

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

转载于:http://blog.itpub.net/9879835/viewspace-1021613/