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.