断电引起文件scn异常数据库恢复---惜分飞

由于异常断电,数据库最初启动报错

Fri Mar 01 08:41:17 2024

ALTER DATABASE   MOUNT

Successful mount of redo thread 1, with mount id 1865809648

Database mounted in Exclusive Mode

Lost write protection disabled

Completed: ALTER DATABASE   MOUNT

Fri Mar 01 08:41:24 2024

ALTER DATABASE OPEN

Errors in file /home/oracle/app/diag/rdbms/XFF/XFF/trace/XFF_ora_25243.trc:

ORA-01113: file 13 needs media recovery

ORA-01110: data file 13: '/data2/oracle/oradata/data/data00.dbf'

ORA-1113 signalled during: ALTER DATABASE OPEN...

经过应用厂商一系列操作,主要是如下操作

Fri Mar 01 11:10:56 2024

ALTER DATABASE RECOVER  datafile 13 

Media Recovery Start

Serial Media Recovery started

WARNING! Recovering data file 13 from a fuzzy backup. It might be an online

backup taken without entering the begin backup command.

ORA-279 signalled during: ALTER DATABASE RECOVER  datafile 13  ...

Fri Mar 01 11:11:09 2024

ALTER DATABASE RECOVER    CONTINUE DEFAULT 

Media Recovery Log /home/oracle/app/flash_recovery_area/XFF/archivelog/2024_03_01/o1_mf_1_153563_%u_.arc

Errors with log /home/oracle/app/flash_recovery_area/XFF/archivelog/2024_03_01/o1_mf_1_153563_%u_.arc

ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...

ALTER DATABASE RECOVER    CONTINUE DEFAULT 

Media Recovery Log /home/oracle/app/flash_recovery_area/XFF/archivelog/2024_03_01/o1_mf_1_153563_%u_.arc

Errors with log /home/oracle/app/flash_recovery_area/XFF/archivelog/2024_03_01/o1_mf_1_153563_%u_.arc

ORA-308 signalled during: ALTER DATABASE RECOVER    CONTINUE DEFAULT  ...

ALTER DATABASE RECOVER CANCEL

Media Recovery Canceled

Completed: ALTER DATABASE RECOVER CANCEL

Fri Mar 01 11:16:50 2024

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值