当前位置: 代码迷 >> Oracle认证考试 >> ORA-00704: 引导程序进程失败
  详细解决方案

ORA-00704: 引导程序进程失败

热度:6177   发布时间:2013-02-26 00:00:00.0
数据库无法启动。附带log
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned off. 
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes = 300
  sessions = 335
  __shared_pool_size = 184549376
  __large_pool_size = 4194304
  __java_pool_size = 4194304
  __streams_pool_size = 0
  nls_language = SIMPLIFIED CHINESE
  nls_territory = CHINA
  sga_target = 612368384
  control_files = D:\ORACLE\PRODUCT\10.2.0\ORADATA\GXYSFMISCS\CONTROL01.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\GXYSFMISCS\CONTROL02.CTL, D:\ORACLE\PRODUCT\10.2.0\ORADATA\GXYSFMISCS\CONTROL03.CTL
  db_block_size = 16384
  __db_cache_size = 411041792
  compatible = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest = D:\oracle\product\10.2.0\flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management = MANUAL
  undo_tablespace = system
  remote_login_passwordfile= EXCLUSIVE
  db_domain = 
  dispatchers = (PROTOCOL=TCP) (SERVICE=GXYSFMISCSXDB)
  job_queue_processes = 4
  audit_file_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\GXYSFMISCS\ADUMP
  background_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\GXYSFMISCS\BDUMP
  user_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\GXYSFMISCS\UDUMP
  core_dump_dest = D:\ORACLE\PRODUCT\10.2.0\ADMIN\GXYSFMISCS\CDUMP
  db_name = GXYSFMIS
  db_unique_name = GXYSFMISCS
  open_cursors = 300
  pga_aggregate_target = 203423744
PMON started with pid=2, OS id=5736
PSP0 started with pid=3, OS id=4636
MMAN started with pid=4, OS id=4264
DBW0 started with pid=5, OS id=1528
LGWR started with pid=6, OS id=3988
CKPT started with pid=7, OS id=3168
SMON started with pid=8, OS id=3836
RECO started with pid=9, OS id=5988
CJQ0 started with pid=10, OS id=4180
MMON started with pid=11, OS id=4732
Fri Jun 04 07:17:34 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=3888
Fri Jun 04 07:17:34 2010
starting up 1 shared server(s) ...
Fri Jun 04 07:17:35 2010
ALTER DATABASE MOUNT
Fri Jun 04 07:17:39 2010
Setting recovery target incarnation to 1
Fri Jun 04 07:17:39 2010
Successful mount of redo thread 1, with mount id 3550467151
Fri Jun 04 07:17:39 2010
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Fri Jun 04 07:18:04 2010
alter database open
Fri Jun 04 07:18:04 2010
Beginning crash recovery of 1 threads
 parallel recovery started with 3 processes
Fri Jun 04 07:18:04 2010
Started redo scan
Fri Jun 04 07:18:05 2010
Completed redo scan
 1 redo blocks read, 0 data blocks need recovery
Fri Jun 04 07:18:05 2010
Started redo application at
 Thread 1: logseq 1954, block 2, scn 63476066
Fri Jun 04 07:18:05 2010
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1954 Reading mem 0
  Mem# 0 errs 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\GXYSFMISCS\REDO01.LOG
Fri Jun 04 07:18:05 2010
Completed redo application
Fri Jun 04 07:18:05 2010
Completed crash recovery at
  相关解决方案