RMAN Tape restore

From: Mek S <sidi.bouzid.meknessy_at_gmail.com>
Date: Wed, 18 Apr 2012 22:12:32 +0200
Message-ID: <CAJX5RkRpW=Cf-y9apQwwdeV+Db94vpibuPhAGTjkS3Q2S19xAQ_at_mail.gmail.com>

Hello,
We have a RAC 4 nodes environment running in 11gR2 / Linux redhat. database in Archivelog mode and we use RMAN. Every Sunday, We do weekly Tape backup of the recovery area + Current controlfile + archivelog files. We do daily incremental backups to disk during weekdays.

For business, we need to restore the database to the state of 9 of April 2012. So we need to do a Tape restore + Archivelogs from daily disk backups. (8 of April is Sunday and 9 of April is Monday).

This is the procedure I am thinking to use.

1- Allocate Tape channels
2- *set until time* "to_date('09-APR-2012 14:45:00','DD-MON-YYYY HH24:MI:SS')";

3- Restore the database
4- Recover the database
5- Alter database open resetlogs;

My questions are;
1- Do I need to restore the controlfile from the tape backup of 08 of April?
2- How do I restore the archivelogs from daily disk backups ?

Thanks,
S

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 18 2012 - 15:12:32 CDT