restore database preview

Q:
When I recover database from the backup. the first need archive log is diffrent in the output of "recover database using backup controlfile until cancel;" and "restore database preview" . So I confused which archive logs should backup for the revover.

the out put of "recover database using backup controlfile until cancel;"

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 276132183128 generated at 05/08/2013 09:22:50 needed for <<====
thread 2
ORA-00289: suggestion : /tt/log/archivelog/2_78067_748448622.dbf
ORA-00280: change 276132183128 for thread 2 is in sequence #78067


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}



the out put of "restore database preview"
Media recovery start SCN is 275942479275 <<=====
Recovery must be done beyond SCN 276074110655 to clear datafile fuzziness
Finished restore at 09-MAY-13

A:
When you use the restore preview command, RMAN checks the recovery required as per its last backed up controlfile.
In your case, RMAN would have backed up the controlfile at a system change number of 275942479275, which it will restore and apply archives to do recovery. Make all the respective backups available for RMAN if on tape and do the recovery.

In the recover database using backup controlfile, Oracle will check the controlfile with which the database is mounted. In your case, the controlfile is already past the SCN 275942479275 and is at 276132183128. If you have the archives past this SCN, then apply them for recovery.

 

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值