求助:打开数据库提示00704，00604，01555
下面是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
这是命令行，之前服务器被异常关机过，再打开服务器oracle就打不开了
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 2月 2 15:27:36 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> conn / as sysdba
已连接。
SQL> shutdown immediate
ORA-01109: 数据库未打开
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。
Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 331350932 bytes
Database Buffers 192937984 bytes
Redo Buffers 10039296 bytes
数据库装载完毕。
ORA-01113: 文件 1 需要介质恢复
ORA-01110: 数据文件 1: 'D:\APP\ADMINISTRATOR\ORADATA\SJZ\SYSTEM01.DBF'
SQL> recover datafile 'D:\app\Administrator\oradata\SJZ\SYSTEM01.DBF';
完成介质恢复。
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-01113: 文件 2 需要介质恢复
ORA-01110: 数据文件 2: 'D:\APP\ADMINISTRATOR\ORADATA\SJZ\SYSAUX01.DBF'
SQL> recover datafile 'D:\app\Administrator\oradata\SJZ\SYSAUX01.DBF';
完成介质恢复。
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-01113: 文件 3 需要介质恢复
ORA-01110: 数据文件 3: 'D:\APP\ADMINISTRATOR\ORADATA\SJZ\UNDOTBS01.DBF'
SQL> recover datafile 'D:\app\Administrator\oradata\SJZ\UNDOTBS01.DBF';
完成介质恢复。
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-01113: 文件 4 需要介质恢复
ORA-01110: 数据文件 4: 'D:\APP\ADMINISTRATOR\ORADATA\SJZ\USERS01.DBF'
SQL> recover datafile 'D:\app\Administrator\oradata\SJZ\users01.DBF';
完成介质恢复。
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-01113: 文件 5 需要介质恢复
ORA-01110: 数据文件 5: 'D:\APP\ADMINISTRATOR\ORADATA\SJZ\EXAMPLE01.DBF'
SQL> recover datafile 'D:\app\Administrator\oradata\SJZ\example01.DBF';
完成介质恢复。
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-01113: 文件 6 需要介质恢复
ORA-01110: 数据文件 6: 'D:\SJZSDE\SDE.DBF'
SQL> recover datafile 'D:\sjzsde\sde.DBF';
完成介质恢复。
SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-01092: ORACLE 实例终止。强制断开连接
进程 ID: 7948
会话 ID: 170 序列号: 5
使用道具 举报
页:
[1]