3 Replies Latest reply: Aug 26, 2013 8:26 AM by Pradeepcmst RSS

    archived log is missing


      dear all,

                    i have rman backup taken and an archived log is missing .how can i recover my database using rman,your help appreciated.

      thanks and regards.

        • 1. Re: archived log is missing
          Hemant K Chitale

          You can't recover the database to any point in time or SCN that is on or after the beginning of the missing archivelog.  Oracle cannot and does not allow you to skip a missing archivelog.


          Thus, if the archivelog Sequence#1020 was for transactions from 10:01:01am to 10:48:42am of 25-Aug and is the missing archivelog, you can recover the database only upto 10:01:01am even if you have Sequence#1021 and subsequent archivelogs available.

          Note that if you have a database backup that began after 10:48:42am, you can use the more recent backup to ignore the missing Sequence#1020.



          Hemant K Chitale

          • 2. Re: archived log is missing

            Full discription of your problem will be easy for us to analyse the problem and give a solution to u, and it is important for you to give the database version and your os information.

            • 3. Re: archived log is missing

              use recover database until cancel option