Printable View
Hi friends,
somebody asked me if it is possible to run an rman recovery on the basis of an old backup set. He wants to make a point in time recovery to a point in time before the last recent backup.
Does someone know if it is possible and if so, how?
Thank you for help,
Christian
You can issue command in rman:
recover database until time "to_date('01-27-2003 07:00:00','MM-DD-YYYY HH24:MI:SS')" ;
... and than rman 'knows' that 'he has to use the old backup set and pieces? Should it be so easy?
Thank you! I´ll try it now... tell you if it was a success or failure :-)
Christian
YES! That's true.Quote:
Originally posted by ckiltz
... and than rman 'knows' that 'he has to use the old backup set and pieces? Should it be so easy?
Thank you! I´ll try it now... tell you if it was a success or failure :-)
Christian
You have to do the following:
1. Recover the control file.
2. STARTUP MOUNT;
3. run {
SET UNTIL TIME "to_date('13.04.2003:16:10:00','dd.mm.yyyy:hh24:mi:ss')";
restore database;
recover database noredo;
alter database open resetlogs;
}
I have tried that and it works.