resetlogs强制拉库失败并使用备份system文件还原数据库故障处理---惜分飞

接手一个库,在open的过程中遭遇到ORA-600 2662错误

Sun May 26 10:15:54 2024

alter database open RESETLOGS

RESETLOGS is being done without consistancy checks. This may result

in a corrupted database. The database should be recreated.

RESETLOGS after incomplete recovery UNTIL CHANGE 84303583

Clearing online redo logfile 1 /data/OracleData/xff/redo01.log

Clearing online log 1 of thread 1 sequence number 8330

Clearing online redo logfile 1 complete

Clearing online redo logfile 2 /data/OracleData/xff/redo02.log

Clearing online log 2 of thread 1 sequence number 8327

Clearing online redo logfile 2 complete

Clearing online redo logfile 3 /data/OracleData/xff/redo03.log

Clearing online log 3 of thread 1 sequence number 8329

Clearing online redo logfile 3 complete

Clearing online redo logfile 4 /data/OracleData/xff/redo04.log

Clearing online log 4 of thread 1 sequence number 8328

Clearing online redo logfile 4 complete

Resetting resetlogs activation ID 1431370398 (0x5550fa9e)

Online log /data/OracleData/xff/redo01.log: Thread 1 Group 1 was previously cleared

Online log /data/OracleData/xff/redo02.log: Thread 1 Group 2 was previously cleared

Online log /data/OracleData/xff/redo03.log: Thread 1 Group 3 was previously cleared

Online log /data/OracleData/xff/redo04.log: Thread 1 Group 4 was previously cleared

Sun May 26 10:15:59 2024

Setting recovery target incarnation to 3

Sun May 26 10:15:59 2024

Read of datafile '/data/OracleData/xff/temp01.dbf' (fno 201) header failed with ORA-01200

Rereading datafile 201 header failed with ORA-01200

Errors in file /data/u01/app/oracle/diag/rdbms/xff/xff/trace/xff_dbw0_1563.trc:

ORA-01186: file 201 failed verification tests

ORA-01122: database file 201 failed verification check

<

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值