-
rman recovery using old backup set
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')" ;
One, who thinks that the other one who thinks that know and does not know, does not know either!
-
... 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
-
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
YES! That's true.
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.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|