- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-13 11:02:04
|
查看: 1207 |
回复: 0
系统表空间报ORA-01157: cannot identify data file 1 - file not found
ORA-01110: data file 1: 'D:\ORANT\DATABASE\SYS1ORCL.ORA'
ORA-27048: skgfifi: file header information is invalid
OSD-04004: 无效的文件页楣
但用户表空间数据正常
以上环境为oracle805+WIN2000
里面有很多用户重要的数据,谢谢
Dump file d:\orant\RDBMS80\trace\orclALRT.LOG
Fri Nov 18 09:50:07 2005
ORACLE V8.0.5.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows NT V5.0, OS V8.147, CPU type 586
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
processes = 59
shared_pool_size = 30720000
control_files = d:\orant\DATABASE\ctl1ORCL.ora
db_block_buffers = 16000
db_block_size = 2048
log_buffer = 655360
log_checkpoint_interval = 10000
db_files = 1024
db_file_multiblock_read_count= 32
dml_locks = 1000
rollback_segments = rb1, rb2, rb3, rb4, rb5, rb6
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
sort_area_size = 327680
db_name = ORCL
open_cursors = 200
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
Fri Nov 18 09:50:08 2005
alter database "orcl" mount exclusive
Fri Nov 18 09:50:12 2005
Successful mount of redo thread 1, with mount id 1102453844.
Fri Nov 18 09:50:12 2005
Database mounted in Exclusive Mode.
Completed: alter database "orcl" mount exclusive
Fri Nov 18 09:50:12 2005
alter database "orcl" open
Fri Nov 18 09:50:12 2005
Errors in file d:\orant\RDBMS80\trace\orclDBW0.TRC:
ORA-01157: cannot identify data file 1 - file not found
ORA-01110: data file 1: 'D:\ORANT\DATABASE\SYS1ORCL.ORA'
ORA-27048: skgfifi: file header information is invalid
OSD-04004: 无效的文件页楣
ORA-1157 signalled during: alter database "orcl" open...
以上是报错的日志文件,把DATABASE拷贝到别的机器(环境一样)也报
Errors in file d:\orant\RDBMS80\trace\orclDBW0.TRC:
ORA-01157: cannot identify data file 1 - file not found
ORA-01110: data file 1: 'D:\ORANT\DATABASE\SYS1ORCL.ORA'
ORA-27048: skgfifi: file header information is invalid
OSD-04004: 无效的文件页楣
如下错误误码 |
|