- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-13 15:34:07
|
查看: 1817 |
回复: 0
数据库启动后,出错。SQL> startup
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2145048 bytes
Variable Size 2600469736 bytes
Database Buffers 1660944384 bytes
Redo Buffers 12222464 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Process ID: 14942262
Session ID: 1655 Serial number: 5
查看日志文件,如下:
Completed redo application
Completed crash recovery at
Thread 1: logseq 11, block 3, scn 13981938126766
0 data blocks read, 0 data blocks written, 1 redo blocks read
Thread 1 advanced to log sequence 12
Thread 1 opened at log sequence 12
Current log# 3 seq# 12 mem# 0: /oracle/app/oracle/oradata/wmtst/data/redo3a.log
Current log# 3 seq# 12 mem# 1: /oracle/app/oracle/oradata/wmtst/data/redo3b.log
Successful open of redo thread 1
SMON: enabling cache recovery
Errors in file /oracle/app/oracle/oradata/wmtst/diag/diag/rdbms/wmtst/wmtst/trace/wmtst_ora_14942262.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
Error 704 happened during db open, shutting down database
USER (ospid: 14942262): terminating the instance due to error 704
Instance terminated by USER, pid = 14942262
ORA-1092 signalled during: ALTER DATABASE OPEN...
ORA-1092 : opiodr aborting process unknown ospid (14942262_1)
Sun Feb 08 02:17:55 2015
ORA-1092 : opitsk aborting process
查看wmtst_ora_14942262.trc,内容如下:
Trace file /oracle/app/oracle/oradata/wmtst/diag/diag/rdbms/wmtst/wmtst/trace/wmtst_ora_14942262.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /oracle/app/oracle/product/11.1.0/db_1
System name: AIX
Node name: test
Release: 1
Version: 6
Machine: 00CADFD64C00
Instance name: wmtst
Redo thread mounted by this instance: 1
Oracle process number: 16
Unix process pid: 14942262, image: oracle@test (TNS V1-V3)
*** 2015-02-08 02:17:52.924
*** SESSION ID1655.5) 2015-02-08 02:17:52.924
*** CLIENT ID) 2015-02-08 02:17:52.924
*** SERVICE NAME) 2015-02-08 02:17:52.924
*** MODULE NAMEsqlplus@test (TNS V1-V3)) 2015-02-08 02:17:52.924
*** ACTION NAME) 2015-02-08 02:17:52.924
Successfully allocated 3 recovery slaves
Using 93 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 11, block 2, scn 13981938106764
start recovery at logseq 11, block 2, scn 13981938106764
*** 2015-02-08 02:17:52.997
Started resilvering redo thread 1 seq 11: blocks 2-2
*** 2015-02-08 02:17:53.007
Completed resilvering redo thread 1 seq 11
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 1024Kb
-- Redo read_disk statistics --
Read rate (ASYNC): 0Kb in 0.07s => 0.01 Mb/sec
Longest record: 0Kb, moves: 0/1 (0%)
Longest LWN: 0Kb, moves: 0/1 (0%), moved: 0Mb
Last redo scn: 0x0cb7.6c74418d (13981938106765)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
请各位大侠看看如何解决?
Errors in file /oracle/app/oracle/oradata/wmtst/diag/diag/rdbms/wmtst/wmtst/trace/wmtst_ora_14942262.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
Error 704 happened during db open, shutting down database
USER (ospid: 14942262): terminating the instance due to error 704
Instance terminated by USER, pid = 14942262
ORA-1092 signalled during: ALTER DATABASE OPEN...
ORA-1092 : opiodr aborting process unknown ospid (14942262_1)
Sun Feb 08 02:17:55 2015
ORA-1092 : opitsk aborting process
|
|