数据库启动打不开，高手帮忙看看。谢谢
本人有一个oracle11.1.0.7.0的数据库是装在WINDOWS2008下的，启动的时候发生错误。现在数据库打不开。错误信息如下。有高手帮忙看看是什么原因。谢谢
急。。。。。。
Instance terminated by PMON, pid = 3264
Thu Aug 09 14:10:47 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE=BR
ILAT =48
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 11.1.0.7.0.
Using parameter settings in server-side spfile D:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
processes = 400
sessions = 445
timed_statistics = TRUE
sga_max_size = 1504M
shared_pool_size = 80M
resource_manager_plan = "FORCE:PLAN_FOR_NDSC_JD_XS"
sga_target = 0
memory_target = 2G
memory_max_target = 2480M
control_files = "D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL01.CTL"
control_files = "D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL02.CTL"
control_files = "D:\APP\ADMINISTRATOR\ORADATA\ORCL\CONTROL03.CTL"
db_block_size = 8192
db_cache_size = 208M
compatible = "11.1.0.0.0"
db_recovery_file_dest = "D:\app\Administrator\flash_recovery_area"
db_recovery_file_dest_size= 4G
undo_tablespace = "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain = ""
global_names = FALSE
dispatchers = "(PROTOCOL=TCP) (SERVICE=ORCLXDB)"
job_queue_processes = 0
audit_file_dest = "D:\APP\ADMINISTRATOR\ADMIN\ORCL\ADUMP"
audit_trail = "NONE"
db_name = "ORCL"
open_cursors = 300
_complex_view_merging = FALSE
_optimizer_cost_based_transformation= "OFF"
pga_aggregate_target = 200M
diagnostic_dest = "D:\APP\ADMINISTRATOR"
Thu Aug 09 14:10:48 2012
PMON started with pid=3, OS id=3324
Thu Aug 09 14:10:48 2012
VKTM started with pid=5, OS id=3392 at elevated priority
VKTM running at (20)ms precision
Thu Aug 09 14:10:48 2012
DIAG started with pid=7, OS id=924
Thu Aug 09 14:10:48 2012
DBRM started with pid=9, OS id=3364
Thu Aug 09 14:10:48 2012
PSP0 started with pid=11, OS id=3316
Thu Aug 09 14:10:48 2012
DIA0 started with pid=13, OS id=796
Thu Aug 09 14:10:48 2012
MMAN started with pid=15, OS id=2248
Thu Aug 09 14:10:48 2012
DBW0 started with pid=2, OS id=3420
Thu Aug 09 14:10:48 2012
DBW1 started with pid=17, OS id=3860
Thu Aug 09 14:10:48 2012
LGWR started with pid=19, OS id=888
Thu Aug 09 14:10:48 2012
CKPT started with pid=21, OS id=3868
Thu Aug 09 14:10:48 2012
SMON started with pid=23, OS id=3536
Thu Aug 09 14:10:48 2012
RECO started with pid=25, OS id=3712
Thu Aug 09 14:10:48 2012
MMON started with pid=27, OS id=3636
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Aug 09 14:10:48 2012
MMNL started with pid=29, OS id=3528
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\app\Administrator
Thu Aug 09 14:10:49 2012
ALTER DATABASE MOUNT
Thu Aug 09 14:10:51 2012
Sweep Incident: completed
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 3553791146
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE MOUNT
Thu Aug 09 14:10:54 2012
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery started with 7 processes
Started redo scan
Completed redo scan
643 redo blocks read, 24 data blocks need recovery
Started redo application at
Thread 1: logseq 150861, block 3
Recovery of Online Redo Log: Thread 1 Group 4 Seq 150861 Reading mem 0
Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO04.LOG
Completed redo application of 0.22MB
Completed crash recovery at
Thread 1: logseq 150861, block 646, scn 12273697812941
24 data blocks read, 24 data blocks written, 643 redo blocks read
Thread 1 advanced to log sequence 150862 (thread open)
Thread 1 opened at log sequence 150862
Current log# 5 seq# 150862 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO05.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 2.
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Exception
Database Characterset is ZHS16GBK
Errors in file d:\app\administrator\diag\rdbms\ORCL\ORCL\trace\ORCL_smon_3536.trc (incident=561214):
ORA-07445: exception encountered: core dump []
Incident details in: d:\app\administrator\diag\rdbms\ORCL\ORCL\incident\incdir_561214\ORCL_smon_3536_i561214.trc
Opening with Resource Manager plan: PLAN_FOR_NDSC_JD_XS : on 2 X 4 NUMA system
Starting background process FBDA
Thu Aug 09 14:10:57 2012
FBDA started with pid=18, OS id=1900
replication_dependency_tracking turned off (no async multimaster replication found)
Thu Aug 09 14:10:58 2012
Trace dumping is performing id=
Starting background process QMNC
Thu Aug 09 14:10:59 2012
QMNC started with pid=20, OS id=3668
Thu Aug 09 14:11:00 2012
Errors in file d:\app\administrator\diag\rdbms\ORCL\ORCL\trace\ORCL_pmon_3324.trc:
ORA-00474: SMON process terminated with error
PMON (ospid: 3324): terminating the instance due to error 474
Thu Aug 09 14:11:00 2012
opidrv aborting process S000 ospid (1784_3728) due to error ORA-474
Instance terminated by PMON, pid = 3324
页:
[1]