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

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

999

积分

1

好友

942

主题
1#
发表于 2017-4-13 10:32:13 | 查看: 1236| 回复: 0

启动oracle 9i for linux 时出现这个错误:
ORA-01172 recovery of thread 1 stuck at block 153 of file 2
ORA-01151 use media recovery to recover block,  restore backup if needed

试过用以下方法恢复:
>startup mount
>recover database
修复过程中,出现很多错误:
ORA-00283 recovery session canceled due to errors
ORA-00600:internal error code,arguments[3020],[8388761],[1],[44],[47],[16],[],[]
ORA-10567:redo is inconsistent with data block(file#2,block#153)
ORA-10564:tablespace UNDOTBS1
ORA-01110: data file2:/data1/oradata/ora9i/undotbs01.dbf
ORA-10560:block type "KTU SMV HEADER BLOCK"

无法继续下去。

由于没有做任何备份,包括冷备份和exp。
想救回数据,应该怎么办?
热情希望得到答复,谢谢!


从恢复的错误“ORA-01110: data file2:/data1/oradata/ora9i/undotbs01.dbf”看,是回滚段1 文件损坏了。
启动时能否跳过回滚段?
多谢!


运行时候出现这个错误:
oracle instance terminated disconnection forced



同样打不开这个视图啊:
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only



不行,出现:
ORA-01092: database requires revcovery




oracle9i的参数文件里面没有rollback_segments这个参数啊。
我以前create pfile from spfile创建了一个pfile文件,但里面没有这个参数。



首先谢谢你的回答。
我startup mount之后,
可以成功执行:alter database datafile '/data1/oradata/ora9i/undotbs01.dbf' offline drop
然后跟着执行:alter database open就报错:
oracle instance terminated disconnection forced



UNDO_MANAGMENT  MANUAL
UNDO_RETENTION  900
UNDO_SUPPRESS_ERRORS FALSE



alter.log :

Wed Sep 29 10:21:59 2004
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
  processes                = 150
  timed_statistics         = TRUE
  shared_pool_size         = 134217728
  large_pool_size          = 452984832
  java_pool_size           = 251658240
  java_pool_size           = 251658240
  control_files            = /data1/oradata/ora9i/control01.ctl, /data1/oradata/
ora9i/control02.ctl, /data1/oradata/ora9i/control03.ctl
  db_block_size            = 8192
  db_cache_size            = 838860800
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = LOCATION=/data1/oradata/ora9i/archive
  log_archive_format       = %t_%s.dbf
  db_file_multiblock_read_count= 16
  fast_start_mttr_target   = 300
  _allow_read_only_corruption= TRUE
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  undo_retention           = 190800
  remote_login_passwordfile= EXCLUSIVE
  db_domain                =
  instance_name            = ora9i
  dispatchers              = (PROTOCOL=TCP) (SERVICE=ora9iXDB)
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = /home/oracle/admin/ora9i/bdump
  user_dump_dest           = /home/oracle/admin/ora9i/udump
  core_dump_dest           = /home/oracle/admin/ora9i/cdump
  sort_area_size           = 30824288
  db_name                  = ora9i
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 100165824
  aq_tm_processes          = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL
=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
Wed Sep 29 10:22:00 2004
ARCH: STARTING ARCH PROCESSES COMPLETE
Wed Sep 29 10:22:00 2004
ALTER DATABASE   MOUNT
ARC1 started with pid=13
ARC1: Archival started
ARC1: Thread not mounted
Wed Sep 29 10:22:00 2004
ARC0: Thread not mounted
Wed Sep 29 10:22:05 2004
Successful mount of redo thread 1, with mount id 2337786888.
Wed Sep 29 10:22:05 2004
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Wed Sep 29 10:22:51 2004
alter database datafile '/data1/oradata/ora9i/undotbs01.dbf' offline drop
                                          
Wed Sep 29 10:22:51 2004
Completed: alter database datafile '/data1/oradata/ora9i/undo
Wed Sep 29 10:23:01 2004
Restarting dead background process QMN0
QMN0 started with pid=9
Wed Sep 29 10:23:17 2004
alter database open
Wed Sep 29 10:23:18 2004
Beginning crash recovery of 1 threads
Wed Sep 29 10:23:18 2004
Started first pass scan
Wed Sep 29 10:23:18 2004
Completed first pass scan
1 redo blocks read, 0 data blocks need recovery
Wed Sep 29 10:23:18 2004
Started recovery at
Thread 1: logseq 46, block 2, scn 0.8071618
Recovery of Online Redo Log: Thread 1 Group 3 Seq 46 Reading mem 0
  Mem# 0 errs 0: /data1/oradata/ora9i/redo03.log
Wed Sep 29 10:23:18 2004
Completed redo application

CKPT started with pWed Sep 29 10:23:18 2004
Ended recovery at
Thread 1: logseq 46, block 3, scn 0.8091619
0 data blocks read, 0 data blocks written, 1 redo blocks read
Crash recovery completed successfully
Wed Sep 29 10:23:18 2004
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 47
Thread 1 opened at log sequence 47
  Current log# 1 seq# 47 mem# 0: /data1/oradata/ora9i/redo01.log
Successful open of redo thread 1.
Wed Sep 29 10:23:18 2004
ARC0: Evaluating archive   log 2 thread 1 sequence 45
ARC0: Beginning to archive log 2 thread 1 sequence 45
Creating archive destination LOG_ARCHIVE_DEST_1: '/data1/oradata/ora9i/archive/1
_45.dbf'
Wed Sep 29 10:23:18 2004
SMON: enabling cache recovery
Wed Sep 29 10:23:18 2004
Successfully onlined Undo Tablespace 1.
Wed Sep 29 10:23:18 2004
starting up 1 shared server(s) ...
QMN0 started with pid=9
Wed Sep 29 10:22:00 2004
SMON: enabling tx recovery
Wed Sep 29 10:23:18 2004
Errors in file /home/oracle/admin/ora9i/udump/ora9i_ora_1241.trc:
ORA-00604: error occurred at recursive SQL level 2
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: '/data1/oradata/ora9i/undotbs01.dbf'
Wed Sep 29 10:23:18 2004
Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Instance terminated by USER, pid = 1241
ORA-1092 signalled during: alter database open...

下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

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

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

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

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

GMT+8, 2024-12-21 01:18 , Processed in 0.047401 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

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