- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-13 10:32:13
|
查看: 1234 |
回复: 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...
|
|