- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-15 23:49:34
|
查看: 1819 |
回复: 1
下面是trc文件里的内容,请高手指教
Trace file d:\app\administrator\diag\rdbms\sjz\sjz\trace\sjz_ora_8108.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows Server 2003 Version V5.2 Service Pack 2
CPU : 32 - type 586, 4 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:63842M/65520M, Ph+PgF:65254M/66969M, VA:1262M/2047M
Instance name: sjz
Redo thread mounted by this instance: 1
Oracle process number: 21
Windows thread id: 8108, image: ORACLE.EXE (SHAD)
*** 2012-02-02 14:24:29.843
*** SESSION ID170.5) 2012-02-02 14:24:29.843
*** CLIENT ID) 2012-02-02 14:24:29.843
*** SERVICE NAME) 2012-02-02 14:24:29.843
*** MODULE NAMEsqlplus.exe) 2012-02-02 14:24:29.843
*** ACTION NAME) 2012-02-02 14:24:29.843
Successfully allocated 16 recovery slaves
Using 69 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 4, block 2, scn 6963035
start recovery at logseq 4, block 2, scn 6963035
==== Redo read statistics for thread 1 ====
Total physical reads (from disk and memory): 4096Kb
-- 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: 0x0000.006a3f5c (6963036)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
*** 2012-02-02 14:24:29.921
KCRA: start recovery claims for 0 data blocks
*** 2012-02-02 14:24:29.921
KCRA: blocks processed = 0/0, claimed = 0, eliminated = 0
*** 2012-02-02 14:24:29.937
Recovery of Online Redo Log: Thread 1 Group 1 Seq 4 Reading mem 0
*** 2012-02-02 14:24:29.937
Completed redo application
*** 2012-02-02 14:24:29.937
Completed recovery checkpoint
IR RIA: redo_size 512 bytes, time_taken 8 ms
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 0
Average hash chain = 0/0 = 0.0
Max compares per lookup = 0
Avg compares per lookup = 0/0 = 0.0
----------------------------------------------
ORA-00704: 引导程序进程失败
ORA-00604: 递归 SQL 级别 2 出现错误
ORA-01555: 快照过旧: 回退段号 10 (名称为 "_SYSSMU10_1192467665$" 过小
*** 2012-02-02 14:24:30.187
USER (ospid: 8108): terminating the instance due to error 704
Thread 1: logseq 4, block 2, scn 6963035
Recovery of Online Redo Log: Thread 1 Group 1 Seq 4 Reading mem 0
Mem# 0: D:\APP\ADMINISTRATOR\ORADATA\SJZ\REDO01.LOG
Completed redo application
Completed crash recovery at
Thread 1: logseq 4, block 3, scn 6983037
0 data blocks read, 0 data blocks written, 1 redo blocks read
Thread 1 advanced to log sequence 5
Thread 1 opened at log sequence 5
Current log# 2 seq# 5 mem# 0: D:\APP\ADMINISTRATOR\ORADATA\SJZ\REDO02.LOG
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
SMON: enabling cache recovery
ORA-01555 caused by SQL statement below (SQL ID: 04xtrk7uyhknh, Query Duration=0 sec, SCN: 0x0000.006a8e06):
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
Errors in file d:\app\administrator\diag\rdbms\sjz\sjz\trace\sjz_ora_8108.trc:
ORA-00704: 引导程序进程失败
ORA-00604: 递归 SQL 级别 2 出现错误
ORA-01555: 快照过旧: 回退段号 10 (名称为 "_SYSSMU10_1192467665$") 过小
Error 704 happened during db open, shutting down database
USER (ospid: 8108): terminating the instance due to error 704
Thu Feb 02 14:24:31 2012
ORA-704 : opidrv aborting process S000 ospid (4716_8080)
Instance terminated by USER, pid = 8108
ORA-1092 signalled during: ALTER DATABASE OPEN...
ORA-1092 : opiodr aborting process unknown ospid (4716_8108)
Thu Feb 02 14:24:33 2012
ORA-1092 : opitsk aborting process
|
|