1 Reply Latest reply on Apr 25, 2014 6:00 PM by rdoogan-Oracle

    Secure backup restore

    jay430640
    jay430640 Apr 25, 2014 8:29 AM

      Hi Experts,

       

      I have a question related to oracle secure backup restore.

       

      Is that possible to restore only the incremental backup?

       

      My full backup is on Sunday, all other days am taking incr backup. I want to restore my data back on Wednesday. For the same, do i need to restore Full backup and incr on Monday, Tuesday and Wednesday ?

       

      Or is there is any other option to recover a file which is available in Wednesday incremental backup?

       

      Thanks and Regards

      Jay

        • 1. Re: Secure backup restore
          rdoogan-Oracle
          rdoogan-Oracle Apr 25, 2014 6:00 PM (in response to jay430640)

          If the file was changed on the Wednesday then it would be included in the Wednesday incremental job, so if you were viewing "latest" and chose the file it would just restore that from the Wednesday backup job. It would only go back to the Full backup if the file hadn't changed so wasn't included in the incr.

           

          You can tell the view to be "as of date" and set it to "exclusive" so you'll only see the files included in that incr job.

           

          Thanks

           

          Rich