操作系统:windows xp
数据库:oracle 8.05
由于管理不慎,这台保存重要数据的计算机掉电,导致oracle数据库无法使用,使用时提示oracle无效,进入svrmgr30使用startup命令,出现如下提示:
SVRMGR> startup
已启动 ORACLE 实例。
系统全局区域合计有 15077376个字节
Fixed Size 49152个字节
Variable Size 12906496个字节
Database Buffers 2048000个字节
Redo Buffers 73728个字节
ORA-00205: ?????????????????????在论坛里搜索到的资料大多是oracle 8.1.7或更高版本oracle的处理方法,很多内容都对不上,由于是重要数据,恢复的时间很急,如哪位知道解决方法,请不吝赐教,在此多谢!!在线等待。而且本人水平有限,请指点时尽量不要太简略,再次感谢!!
数据库:oracle 8.05
由于管理不慎,这台保存重要数据的计算机掉电,导致oracle数据库无法使用,使用时提示oracle无效,进入svrmgr30使用startup命令,出现如下提示:
SVRMGR> startup
已启动 ORACLE 实例。
系统全局区域合计有 15077376个字节
Fixed Size 49152个字节
Variable Size 12906496个字节
Database Buffers 2048000个字节
Redo Buffers 73728个字节
ORA-00205: ?????????????????????在论坛里搜索到的资料大多是oracle 8.1.7或更高版本oracle的处理方法,很多内容都对不上,由于是重要数据,恢复的时间很急,如哪位知道解决方法,请不吝赐教,在此多谢!!在线等待。而且本人水平有限,请指点时尽量不要太简略,再次感谢!!
Wed Oct 10 07:45:26 2007
ORACLE V8.0.5.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows NT V5.1, OS V10.40, CPU type 586
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
processes = 59
shared_pool_size = 11534336
control_files = C:\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 = FALSE
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
Wed Oct 10 07:45:40 2007
alter database "orcl" mount exclusive
Wed Oct 10 07:45:44 2007
Successful mount of redo thread 1, with mount id 1163362728.
Wed Oct 10 07:45:44 2007
Database mounted in Exclusive Mode.
Completed: alter database "orcl" mount exclusive
Wed Oct 10 07:45:44 2007
alter database "orcl" open
Beginning crash recovery of 1 threads
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1298 Reading mem 0
Mem# 0 errs 0: C:\ORANT\DATABASE\LOG3ORCL.ORA
Crash recovery completed successfully
Wed Oct 10 07:45:48 2007
Thread 1 advanced to log sequence 1299
Thread 1 opened at log sequence 1299
Current log# 3 seq# 1299 mem# 0: C:\ORANT\DATABASE\LOG2ORCL.ORA
Successful open of redo thread 1.
Wed Oct 10 07:45:49 2007
SMON: enabling cache recovery
SMON: enabling tx recovery
Wed Oct 10 07:45:55 2007
Completed: alter database "orcl" open
Dump file C:\orant\RDBMS80\trace\orclALRT.LOG
Wed Oct 10 10:01:04 2007
ORACLE V8.0.5.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows NT V5.1, OS V10.40, CPU type 586
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
processes = 59
shared_pool_size = 11534336
control_files = C:\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 = FALSE
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
Wed Oct 10 10:01:17 2007
alter database "orcl" mount exclusive
Wed Oct 10 10:01:25 2007
ORA-204 signalled during: alter database "orcl" mount exclusive...
Dump file C:\orant\RDBMS80\trace\orclALRT.LOG
Wed Oct 10 10:19:25 2007
ORACLE V8.0.5.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows NT V5.1, OS V10.40, CPU type 586
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
processes = 59
shared_pool_size = 11534336
control_files = C:\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 = FALSE
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
Wed Oct 10 10:19:33 2007
alter database "orcl" mount exclusive
Wed Oct 10 10:19:34 2007
ORA-00202: controlfile: 'C:\orant\DATABASE\ctl1ORCL.ora'
ORA-27048: skgfifi: file header information is invalid
OSD-04004: 无效的文件页楣Wed Oct 10 10:19:34 2007
ORA-205 signalled during: alter database "orcl" mount exclusive...
Dump file C:\orant\RDBMS80\trace\orclALRT.LOG
Wed Oct 10 11:26:57 2007
ORACLE V8.0.5.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows NT V5.1, OS V10.40, CPU type 586
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
processes = 59
shared_pool_size = 11534336
control_files = C:\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 = FALSE
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
Wed Oct 10 11:27:05 2007
alter database "orcl" mount exclusive
Wed Oct 10 11:27:07 2007
ORA-00202: controlfile: 'C:\orant\DATABASE\ctl1ORCL.ora'
ORA-27048: skgfifi: file header information is invalid
OSD-04004: 无效的文件页楣Wed Oct 10 11:27:07 2007
ORA-205 signalled during: alter database "orcl" mount exclusive...
Dump file C:\orant\RDBMS80\trace\orclALRT.LOG
Wed Oct 10 14:17:36 2007
ORACLE V8.0.5.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows NT V5.1, OS V10.40, CPU type 586
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
processes = 59
shared_pool_size = 11534336
control_files = C:\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 = FALSE
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
Wed Oct 10 14:18:01 2007
alter database "orcl" mount exclusive
Wed Oct 10 14:18:01 2007
ORA-00202: controlfile: 'C:\orant\DATABASE\ctl1ORCL.ora'
ORA-27048: skgfifi: file header information is invalid
OSD-04004: 无效的文件页楣