Oracle启动异常(00604错误)

风象南 发布于 2018/04/08 16:58
阅读 403
收藏 1

开源之夏第三届火热来袭,高校学生参与赢万元奖金!>>>

服务器异常断电后,启动Oracle出现如下错误,如何解决?

日志文件

Starting up:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options.
Using parameter settings in server-side spfile E:\DAASAN_SERVER_ENV\DSSERVER\ORACLE11G\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA
System parameters with non-default values:
  processes                = 150
  memory_target            = 6512M
  control_files            = "E:\DAASAN_SERVER_ENV\DSSERVER\ORACLE11G\ORADATA\ORCL\CONTROL01.CTL"
  control_files            = "E:\DAASAN_SERVER_ENV\DSSERVER\ORACLE11G\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL"
  db_block_size            = 8192
  compatible               = "11.2.0.0.0"
  db_recovery_file_dest    = "E:\daasan_server_env\dsserver\oracle11g\flash_recovery_area"
  db_recovery_file_dest_size= 3912M
  undo_tablespace          = "UNDOTBS1"
  remote_login_passwordfile= "EXCLUSIVE"
  db_domain                = ""
  dispatchers              = "(PROTOCOL=TCP) (SERVICE=orclXDB)"
  audit_file_dest          = "E:\DAASAN_SERVER_ENV\DSSERVER\ORACLE11G\ADMIN\ORCL\ADUMP"
  audit_trail              = "DB"
  db_name                  = "orcl"
  open_cursors             = 300
  deferred_segment_creation= FALSE
  diagnostic_dest          = "E:\DAASAN_SERVER_ENV\DSSERVER\ORACLE11G"
Sun Apr 08 16:45:15 2018
PMON started with pid=2, OS id=7384 
Sun Apr 08 16:45:15 2018
VKTM started with pid=3, OS id=8168 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Sun Apr 08 16:45:15 2018
GEN0 started with pid=4, OS id=7288 
Sun Apr 08 16:45:15 2018
DIAG started with pid=5, OS id=9100 
Sun Apr 08 16:45:15 2018
DBRM started with pid=6, OS id=8792 
Sun Apr 08 16:45:15 2018
PSP0 started with pid=7, OS id=8308 
Sun Apr 08 16:45:15 2018
DIA0 started with pid=8, OS id=8480 
Sun Apr 08 16:45:15 2018
MMAN started with pid=9, OS id=8236 
Sun Apr 08 16:45:15 2018
DBW0 started with pid=10, OS id=9140 
Sun Apr 08 16:45:15 2018
DBW1 started with pid=11, OS id=8364 
Sun Apr 08 16:45:15 2018
LGWR started with pid=12, OS id=8840 
Sun Apr 08 16:45:15 2018
CKPT started with pid=13, OS id=4836 
Sun Apr 08 16:45:15 2018
SMON started with pid=14, OS id=7372 
Sun Apr 08 16:45:15 2018
RECO started with pid=15, OS id=8200 
Sun Apr 08 16:45:15 2018
MMON started with pid=16, OS id=8860 
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
ORACLE_BASE from environment = E:\daasan_server_env\dsserver\oracle11g
Sun Apr 08 16:45:15 2018
ALTER DATABASE   MOUNT
Sun Apr 08 16:45:15 2018
MMNL started with pid=17, OS id=8744 
Successful mount of redo thread 1, with mount id 1500695323
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Sun Apr 08 16:45:20 2018
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
 parallel recovery started with 11 processes
Started redo scan
Completed redo scan
 read 0 KB redo, 0 data blocks need recovery
Started redo application at
 Thread 1: logseq 2, block 2, scn 3226349097
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
  Mem# 0: E:\DAASAN_SERVER_ENV\DSSERVER\ORACLE11G\ORADATA\ORCL\REDO02.LOG
Completed redo application of 0.00MB
Completed crash recovery at
 Thread 1: logseq 2, block 3, scn 3226369099
 0 data blocks read, 0 data blocks written, 0 redo k-bytes read
Thread 1 advanced to log sequence 3 (thread open)
Thread 1 opened at log sequence 3
  Current log# 3 seq# 3 mem# 0: E:\DAASAN_SERVER_ENV\DSSERVER\ORACLE11G\ORADATA\ORCL\REDO03.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
Errors in file e:\daasan_server_env\dsserver\oracle11g\diag\rdbms\orcl\orcl\trace\orcl_ora_9072.trc:
ORA-00704: 引导程序进程失败
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-00942: 表或视图不存在
Errors in file e:\daasan_server_env\dsserver\oracle11g\diag\rdbms\orcl\orcl\trace\orcl_ora_9072.trc:
ORA-00704: 引导程序进程失败
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-00942: 表或视图不存在
Error 704 happened during db open, shutting down database
USER (ospid: 9072): terminating the instance due to error 704
Instance terminated by USER, pid = 9072
ORA-1092 signalled during: ALTER DATABASE OPEN...
opiodr aborting process unknown ospid (9072) as a result of ORA-1092
Sun Apr 08 16:45:25 2018
ORA-1092 : opitsk aborting process

 

加载中
OSCHINA
登录后可查看更多优质内容
返回顶部
顶部
返回顶部
顶部