求助:打开数据库提示00704，00604，01555

显示全部楼层 · 2012-2-2 14:24:29

下面是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 ID

170.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 NAME

sqlplus.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$&quot

过小
*** 2012-02-02 14:24:30.187
USER (ospid: 8108): terminating the instance due to error 704

千问 · 2012-2-2 14:24:29

有人知道吗，以下是alert文件的部分内容
Using parameter settings in server-side spfile D:\APP\ADMINISTRATOR\PRODUCT\11.1.0\DB_1\DATABASE\SPFILESJZ.ORA
System parameters with non-default values:
processes
= 150
memory_target
= 820M
control_files
= "D:\APP\ADMINISTRATOR\ORADATA\SJZ\CONTROL01.CTL"
db_block_size
= 8192
compatible
= "11.1.0.0.0"
db_recovery_file_dest= "D:\app\Administrator\flash_recovery_area"
db_recovery_file_dest_size= 2G
_allow_resetlogs_corruption= TRUE
undo_tablespace
= "UNDOTBS1"
remote_login_passwordfile= "EXCLUSIVE"
db_domain
= ""
dispatchers
= "(PROTOCOL=TCP) (SERVICE=SJZXDB)"
audit_file_dest
= "D:\APP\ADMINISTRATOR\ADMIN\SJZ\ADUMP"
audit_trail
= "DB"
db_name
= "SJZ"
open_cursors
= 300
diagnostic_dest
= "D:\APP\ADMINISTRATOR"
Thu Feb 02 14:24:22 2012
PMON started with pid=2, OS id=8004
Thu Feb 02 14:24:22 2012
VKTM started with pid=3, OS id=8008 at elevated priority
VKTM running at (20)ms precision
Thu Feb 02 14:24:22 2012
DIAG started with pid=4, OS id=8012
Thu Feb 02 14:24:22 2012
DBRM started with pid=5, OS id=8016
Thu Feb 02 14:24:22 2012
PSP0 started with pid=6, OS id=8020
Thu Feb 02 14:24:22 2012
DSKM started with pid=7, OS id=8024
Thu Feb 02 14:24:22 2012
DIA0 started with pid=8, OS id=8028
Thu Feb 02 14:24:22 2012
MMAN started with pid=7, OS id=8032
Thu Feb 02 14:24:22 2012
DBW0 started with pid=9, OS id=8036
Thu Feb 02 14:24:22 2012
DBW1 started with pid=10, OS id=8040
Thu Feb 02 14:24:22 2012
DBW2 started with pid=11, OS id=8044
Thu Feb 02 14:24:22 2012
DBW3 started with pid=12, OS id=8048
Thu Feb 02 14:24:22 2012
LGWR started with pid=13, OS id=8052
Thu Feb 02 14:24:22 2012
CKPT started with pid=14, OS id=8056
Thu Feb 02 14:24:22 2012
SMON started with pid=15, OS id=8060
Thu Feb 02 14:24:22 2012
RECO started with pid=16, OS id=8064
Thu Feb 02 14:24:22 2012
MMON started with pid=17, OS id=8068
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Thu Feb 02 14:24:22 2012
MMNL started with pid=18, OS id=8072
starting up 1 shared server(s) ...
ORACLE_BASE from environment = D:\app\Administrator
Thu Feb 02 14:24:22 2012
ALTER DATABASEsjz MOUNT
Setting recovery target incarnation to 2
Successful mount of redo thread 1, with mount id 2975656729
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASEsjz MOUNT
Thu Feb 02 14:24:29 2012
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery started with 16 processes
Started redo scan
Completed redo scan
1 redo blocks read, 0 data blocks need recovery
Started redo application at
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

千问 · 2012-2-2 14:24:29

估计UNDO有异常读不到数据所以出现不一致打不开，有没备份，如果没有用隐含参数打开重建UNDO表空间看看

千问 · 2012-2-2 14:24:29

ftc007 ，能说的具体点吗？如何用隐含参数打开重建UNDO表空间

千问 · 2012-2-2 14:24:29

有人知道吗

千问 · 2012-2-2 14:24:29

这是命令行，之前服务器被异常关机过，再打开服务器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 Area535662592 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

千问 · 2012-2-2 14:24:29

_corrupted_rollback_segments='_SYSSMU10_1192467665$'，跳过这个回滚段试试看

千问 · 2012-2-2 14:24:29

如何跳过回滚段啊？怎么写？

千问 · 2012-2-2 14:24:29

你先create pfile from spfile然后修改PFILE里把以上的语句添加上去，然后用PFILE启动试下

千问 · 2012-2-2 14:24:29

具体的语句怎么写阿