Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
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: 无效的文件页楣
如下错误误码
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2025-1-4 04:36 , Processed in 0.043608 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569