asked on

RMAN daily cold backup

We take RMAN cold backup daily.
we have the RMAN cold backup.(oracle 10g rel 10) on Unix env.
today is friday and we have to restore the development database from wednesdays cold backup.

How can we proceed with this task.

we have all the backups on disk.

ASKER CERTIFIED SOLUTION

schwertner

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ballioballi

ASKER

Thanks for your prompt reply. Let me explain you the whole scenario

we already have the cold backup of wednesday and thursday.

Now, where I am mentioning that we have to restorie the tuesday night's cold backup.

Please note today is friday and we ran two coldback's after the original backup we are talking here.

we have to restore from tuesday nights backup (we now have tuesday,wednesday and thursday's backup on the location).

Please advice.

ballioballi

ASKER

I mean how the repository come to know about the 2 day's back

mrjoltcola

use restore until time ... and recover until time ...

Or set the UNTIL TIME or SCN or SEQUENCE

RUN
{
SET UNTIL SCN 1000;
# or
# SET UNTIL TIME 'Mar 29 2009 05:00:00';
RESTORE DATABASE;
RECOVER DATABASE;
}

ballioballi

ASKER

This is a cold backup.Does this incomplete recovery will work for the cold backup ?

Why I have to recover when I have the cold backup?
One more question:- How can I find the SCN for that cold backup ended two days ago ?

Thanks,

SOLUTION

mrjoltcola

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial