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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-12 18:35:03 | 查看: 1231| 回复: 1
请问各位前辈:
         之前RAID的两颗Disk坏了,后来修复后,我用internal成功登入并且下startup指令.Database已可以mount上去了,可是一直无法Open,游标一直停在空白处,不晓得它在做什麽.
        为什麽会这样? 没有任的错误讯息回应给我参考!
有没有其他法可以将它开启?
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
2#
发表于 2017-4-12 18:35:53

在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回去!


回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

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

GMT+8, 2024-12-20 16:11 , Processed in 0.046237 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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