rman recovery using old backup set
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: rman recovery using old backup set

  1. #1
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97

    Post 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

  2. #2
    Join Date
    Nov 2001
    Posts
    335
    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!

  3. #3
    Join Date
    Oct 2001
    Location
    Berlin, Germany
    Posts
    97
    ... 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

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
  •  


Click Here to Expand Forum to Full Width