Database无法Open,急!急!
请问各位前辈:之前RAID的两颗Disk坏了,后来修复后,我用internal成功登入并且下startup指令.Database已可以mount上去了,可是一直无法Open,游标一直停在空白处,不晓得它在做什麽.
为什麽会这样? 没有任的错误讯息回应给我参考!
有没有其他法可以将它开启?
在alert文件中它显示:
ORA-00704: bootstrap process failre
ORA-27103: internal error
alert文件如下:
Dump file D:\oracle\ora81\RDBMS\trace\hermALRT.LOG
Thu Feb 26 14:55:42 2004
ORACLE V8.1.7.4.1 - Production vsnsta=0
vsnsql=f vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.7.4.1.
System parameters with non-default values:
processes = 100
shared_pool_size = 9000000
dbwr_io_slaves = 2
control_files = E:\HERMES\Oracle\Database\HERM_1.ctl, E:\HERMES\Oracle\Database\HERM_2.ctl
db_block_buffers = 3200
db_block_size = 8192
compatible = 8.0.5
log_archive_start = TRUE
log_archive_dest = E:\HERMES\Oracle\Database\Archive
log_archive_min_succeed_dest= 1
log_archive_format = Log%S_%T.arc
log_buffer = 163840
log_checkpoint_interval = 50
log_checkpoint_timeout = 900
db_files = 1500
db_file_multiblock_read_count= 32
dml_locks = 500
rollback_segments = RB0, RB1
remote_login_passwordfile= SHARED
db_domain = WORLD
distributed_transactions = 10
instance_name = HERM
service_names = HERMES
mts_dispatchers = (protocol=TCP)(DISP=5)(mul=ON)(pool=ON)
mts_servers = 5
mts_max_servers = 30
mts_max_dispatchers = 5
local_listener = (ADDRESS=(PROTOCOL=TCP)(HOST=10.1.1.66)(PORT=1521))
sort_area_size = 66560
db_name = HERMES
open_cursors = 1000
os_authent_prefix =
optimizer_mode = choose
parallel_max_servers = 25
max_dump_file_size = 10240
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Thu Feb 26 14:55:44 2004
starting up 5 shared server(s) ...
starting up 5 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=18
Thu Feb 26 14:55:48 2004
ARCH: STARTING ARCH PROCESSES COMPLETE
Thu Feb 26 14:55:48 2004
ARC0: Archival started
Thu Feb 26 14:55:48 2004
alter database mount
Thu Feb 26 14:55:53 2004
Successful mount of redo thread 1, with mount id 3394785977.
Thu Feb 26 14:55:53 2004
Database mounted in Exclusive Mode.
Completed: alter database mount
Thu Feb 26 14:56:56 2004
alter database open
Thu Feb 26 14:56:57 2004
Beginning crash recovery of 1 threads
Thu Feb 26 14:56:57 2004
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 842 Reading mem 0
Mem# 0 errs 0: E:\HERMES\ORACLE\DATABASE\REDOLOGHERM2.LOG
Thu Feb 26 14:56:58 2004
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 1 redo blocks read
Crash recovery completed successfully
Thu Feb 26 14:56:58 2004
Thread 1 advanced to log sequence 843
Thread 1 opened at log sequence 843
Current log# 1 seq# 843 mem# 0: E:\HERMES\ORACLE\DATABASE\REDOLOGHERM1.LOG
Successful open of redo thread 1.
Thu Feb 26 14:56:59 2004
ARC0: media recovery disabled
Thu Feb 26 14:56:59 2004
SMON: enabling cache recovery
***
Corrupt block relative dba: 0x00400085 (file 1, block 133)
Bad header found during buffer read
Data in bad block -
type: 67 format: 79 rdba: 0x23223d52
last change scn: 0x4646.38453644 seq: 0x22 flg: 0x0a
consistency value in tail: 0x46455248
check value in block header: 0x4957, block checksum disabled
spare1: 0x4c, spare2: 0x4f, spare3: 0x5444
***
Reread of rdba: 0x00400085 (file 1, block 133) found same corrupted data
Thu Feb 26 14:56:59 2004
Errors in file D:\oracle\ora81\RDBMS\TRACE\ORA01408.TRC:
ORA-00704: bootstrap process failure
ORA-01578: ORACLE data block corrupted (file # 1, block # 133)
ORA-01110: data file 1: 'E:\HERMES\ORACLE\DATABASE\SYSHERM.DBF'
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Thu Feb 26 14:57:30 2004
Errors in file D:\oracle\ora81\RDBMS\trace\ORA01640.TRC:
ORA-00704: bootstrap process failure
Thu Feb 26 14:57:30 2004
Errors in file D:\oracle\ora81\RDBMS\trace\ORA00868.TRC:
ORA-00704: bootstrap process failure
Thu Feb 26 14:57:30 2004
Errors in file D:\oracle\ora81\RDBMS\trace\ORA01564.TRC:
ORA-00704: bootstrap process failure
Thu Feb 26 14:57:31 2004
Errors in file D:\oracle\ora81\RDBMS\trace\ORA01568.TRC:
ORA-00704: bootstrap process failure
Thu Feb 26 14:58:20 2004
Errors in file D:\oracle\ora81\RDBMS\trace\ORA01656.TRC:
ORA-00704: bootstrap process failure
Thu Feb 26 14:58:47 2004
Errors in file D:\oracle\ora81\RDBMS\TRACE\ORA00760.TRC:
ORA-27103: internal error
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
Thu Feb 26 14:59:17 2004
Errors in file D:\oracle\ora81\RDBMS\TRACE\ORA00876.TRC:
ORA-27103: internal error
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
Thu Feb 26 14:59:47 2004
Errors in file D:\oracle\ora81\RDBMS\TRACE\ORA01028.TRC:
ORA-27103: internal error
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
Thu Feb 26 15:00:17 2004
Errors in file D:\oracle\ora81\RDBMS\TRACE\ORA00944.TRC:
ORA-27103: internal error
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
Thu Feb 26 15:00:47 2004
Errors in file D:\oracle\ora81\RDBMS\TRACE\ORA01616.TRC:
ORA-27103: internal error
ORA-00704: bootstrap process failure
ORA-00704: bootstrap process failure
Thu Feb 26 15:02:30 2004
PMON: terminating instance due to error 704
Thu Feb 26 15:02:30 2004
LGWR: terminating instance due to error 704
Thu Feb 26 15:02:30 2004
DBW0: terminating instance due to error 704
Thu Feb 26 15:02:31 2004
CKPT: terminating instance due to error 704
Thu Feb 26 15:02:36 2004
Errors in file D:\oracle\ora81\RDBMS\trace\ORA01384.TRC:
ORA-00704: bootstrap process failure
Thu Feb 26 15:03:20 2004
RECO: terminating instance due to error 704
Thu Feb 26 15:03:30 2004
Instance terminated by DBW0, pid = 1564
Thu Feb 26 15:03:31 2004
Instance terminated by CKPT, pid = 1568
Thu Feb 26 15:03:50 2004
Instance terminated by RECO, pid = 1656
Thu Feb 26 15:04:00 2004
Instance terminated by PMON, pid = 1640
Thu Feb 26 15:04:00 2004
Instance terminated by LGWR, pid = 868
Thu Feb 26 15:05:00 2004
Errors in file D:\oracle\ora81\RDBMS\trace\ORA01564.TRC:
ORA-27103: internal error
ORA-00704: bootstrap process failure
Thu Feb 26 15:05:00 2004
Errors in file D:\oracle\ora81\RDBMS\trace\ORA01656.TRC:
ORA-27103: internal error
ORA-00704: bootstrap process failure
Thu Feb 26 15:05:00 2004
Errors in file D:\oracle\ora81\RDBMS\trace\ORA01568.TRC:
ORA-27103: internal error
ORA-00704: bootstrap process failure
Thu Feb 26 15:05:00 2004
Errors in file D:\oracle\ora81\RDBMS\trace\ORA00868.TRC:
ORA-27103: internal error
ORA-00704: bootstrap process failure
Thu Feb 26 15:05:00 2004
Errors in file D:\oracle\ora81\RDBMS\trace\ORA01640.TRC:
ORA-27103: internal error
ORA-00704: bootstrap process failure
Thu Feb 26 15:07:36 2004
SMON: terminating instance due to error 704
Instance terminated by SMON, pid = 1384
Thu Feb 26 15:08:06 2004
Errors in file D:\oracle\ora81\RDBMS\trace\ORA01384.TRC:
ORA-27103: internal error
ORA-00704: bootstrap process failure
我有重开机好几次,结果都是一样,不知道为何会如此?
请各位高手帮帮忙,有没有办法将资料库OPEN起来!
请问如何修复损坏的区块?
可以告诉我详细步骤吗?
底下是ORA01408.TRC档,请参考:
Dump file D:\oracle\ora81\RDBMS\TRACE\ORA01408.TRC
Thu Feb 26 14:56:59 2004
ORACLE V8.1.7.4.1 - Production vsnsta=0
vsnsql=f vsnxtr=3
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Oracle8i Release 8.1.7.4.1 - Production
JServer Release 8.1.7.4.1 - Production
Windows 2000 Version 5.0 Service Pack 2, CPU type 586
Instance name: herm
Redo thread mounted by this instance: 1
Oracle process number: 19
Windows thread id: 1408, image: ORACLE.EXE
*** SESSION ID8.1) 2004-02-26 14:56:59.451
***
Corrupt block relative dba: 0x00400085 (file 1, block 133)
Bad header found during buffer read
Data in bad block -
type: 67 format: 79 rdba: 0x23223d52
last change scn: 0x4646.38453644 seq: 0x22 flg: 0x0a
consistency value in tail: 0x46455248
check value in block header: 0x4957, block checksum disabled
spare1: 0x4c, spare2: 0x4f, spare3: 0x5444
***
Reread of rdba: 0x00400085 (file 1, block 133) found same corrupted data
ORA-00704: bootstrap process failure
ORA-01578: ORACLE data block corrupted (file # 1, block # 133)
ORA-01110: data file 1: 'E:\HERMES\ORACLE\DATABASE\SYSHERM.DBF'
我有做export不知会不会无法import回去!
页:
[1]