数据库写入过程中突然断电
环境win2k O8.0.5
症状数据库 仅能mount状态 无法open
错误信息：
ORA-01172 recovery of thread 1 stuck at block 473 of file 1
ORA-01151 use media recovery to recover block, restore backup if needed
无法recover
ORA-00283 recovery session canceled due to errors
ORA-00600:internal error code,arguments[3020],[8388761],[1],[44],[47],[16],[],[]
没有备份
真心恳求各位大大的帮助曾经查过老贴问题不尽相同 他坏的是 file2 我是 file1没有办法找到坏的文件进行脱机
日志文件
Mon Jun 26 22:33:16 2006
Shutting down instance (immediate)
License high water mark = 4
Mon Jun 26 22:34:19 2006
ALTER DATABASE CLOSE NORMAL
Mon Jun 26 22:34:19 2006
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Mon Jun 26 22:34:19 2006
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
processes
= 59
shared_pool_size = 11534336
control_files
= d:\orant\DATABASE\ctl1ORCL.ora
db_block_buffers = 1000
db_block_size
= 2048
log_buffer
= 8192
log_checkpoint_interval= 10000
db_files
= 1024
db_file_multiblock_read_count= 8
sequence_cache_entries = 10
sequence_cache_hash_buckets= 10
remote_login_passwordfile= SHARED
global_names
= TRUE
distributed_lock_timeout = 300
distributed_transactions = 5
open_links
= 4
db_name
= ORCL
text_enable
= TRUE
job_queue_processes= 2
job_queue_interval = 10
job_queue_keep_connections= FALSE
parallel_max_servers = 5
background_dump_dest = %RDBMS80%\trace
user_dump_dest = %RDBMS80%\trace
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
SNP0 started with pid=8
SNP1 started with pid=9
Mon Jun 26 22:41:23 2006
alter databasemount
Mon Jun 26 22:41:27 2006
Successful mount of redo thread 1, with mount id 1121941399.
Mon Jun 26 22:41:27 2006
Database mounted in Exclusive Mode.
Completed: alter databasemount
Mon Jun 26 22:41:37 2006
Starting ORACLE instance (normal)
Mon Jun 26 22:42:03 2006
alter database open
Mon Jun 26 22:42:03 2006
Beginning crash recovery of 1 threads
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2061 Reading mem 0
Mem# 0 errs 0: D:\ORANT\DATABASE\LOG4ORCL.ORA
ORA-1172 signalled during: alter database open
...
Mon Jun 26 22:42:29 2006
ALTER DATABASE RECOVER database
Mon Jun 26 22:42:29 2006
Media Recovery Start
Media Recovery Log
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2061 Reading mem 0
Mem# 0 errs 0: D:\ORANT\DATABASE\LOG4ORCL.ORA
Mon Jun 26 22:42:29 2006
Errors in file d:\orant\RDBMS80\trace\ORA00276.TRC:
ORA-00600: internal error code, arguments: [3020], [4194777], [1], [2061], [3], [76], [], []
Media Recovery failed with error 600
ORA-283 signalled during: ALTER DATABASE RECOVER database...
Mon Jun 26 22:42:30 2006
ALTER DATABASE RECOVER CANCEL
ORA-1112 signalled during: ALTER DATABASE RECOVER CANCEL...
小弟水平有限真心恳求各位大侠的帮助不胜感激 拜先～
|
