11 Replies Latest reply: Nov 6, 2013 7:00 PM by Hemant K Chitale RSS

    How to recover standby by rman

    yasirdba

      Hello every one

       

      Oracle 11g2 on window server 2008

       

      For testing i have created standby server and shutdow it.

      I have also schedule the increamental backup daily in the morning at 5:00 am.

       

      Suppose if primary server has crashed at day time at 11:00 am as whole and standby database has lag of two days with respect to primary server

       

      I have all archive log till 11:00 am, rman backup and control at 5:00 am.

       

       

      Process that followed to recover the standby server .

       

      1) restore the control file to standby database

      2) copy the rman backup to standby server and catalog it.

      3) restore the database successfully

      4) recover database but it give error 

      RMAN-03002: failure of recover command at 10/31/2013 14:55:40

      ORA-19693: backup piece C:\BACKUP\STD_5TONPQ57_1_1 already included

       

      5) i have issued alter database open but gives following error

       

      ORA-10458: standby database requires recovery

      ORA-01152: file 1 was not restored from a sufficiently old backup

      ORA-01110: data file 1: 'C:\ORACLE\ORADATA\SLATE\SYSTEM01.DBF'

       

       

      any help how to recover the standby server by rman incremental backup

        • 1. Re: How to recover standby by rman
          Anar Godjaev

          Hi,

           

          RMAN-03002: failure of recover command at 10/31/2013 14:55:40

          ORA-19693: backup piece C:\BACKUP\STD_5TONPQ57_1_1 already included

           

          rman target /
          crosscheck backup;
          delete expired backup;
          catalog start with 'path_to_your_backup';

           

          ORA-10458: standby database requires recovery

          ORA-01152: file 1 was not restored from a sufficiently old backup

          ORA-01110: data file 1: 'C:\ORACLE\ORADATA\SLATE\SYSTEM01.DBF'

           

          OTN form: https://forums.oracle.com/thread/2490308?start=0&tstart=0

           

          Thank you

          • 2. Re: How to recover standby by rman
            Karan Kukreja

            RMAN Incremental Backups to Roll Forward a Physical Standby Database - www.ORACLE-CKPT.com

             

             

            rollforward your BCP.Step by Step using this link.

             

            credits to the creator of the link.

             

            regards

            KK

            • 3. Re: How to recover standby by rman
              Mahir M. Quluzade

              yasirdba wrote:

               

              Hello every one

               

              Oracle 11g2 on window server 2008

               

              For testing i have created standby server and shutdow it.

              I have also schedule the increamental backup daily in the morning at 5:00 am.

               

              Suppose if primary server has crashed at day time at 11:00 am as whole and standby database has lag of two days with respect to primary server

               

              I have all archive log till 11:00 am, rman backup and control at 5:00 am.

               

               

              Process that followed to recover the standby server .

               

              1) restore the control file to standby database

               

              2) copy the rman backup to standby server and catalog it.

              3) restore the database successfully

              4) recover database but it give error

              RMAN-03002: failure of recover command at 10/31/2013 14:55:40

              ORA-19693: backup piece C:\BACKUP\STD_5TONPQ57_1_1 already included

               

              5) i have issued alter database open but gives following error

               

              ORA-10458: standby database requires recovery

              ORA-01152: file 1 was not restored from a sufficiently old backup

              ORA-01110: data file 1: 'C:\ORACLE\ORADATA\SLATE\SYSTEM01.DBF'

               

               

              any help how to recover the standby server by rman incremental backup

              Hi Yasir!

               

              If you  have all archived log, and control file backups.

              Then you  must follow this steps

               

              1. Restore Standby control file;

              2. Copy archived logs to  a folder (/tmp/arch) or FRA

              3. RMAN>alter database mount;

              RMAN> catalog start  with '/tmp/arch'; (or FRA)

              RMAN must be cataloged all  archived logs;

              4. Start redo  apply process for apply archived log;

              5. If All archived logs applied, then you  can  perform failover to standby database.

              It means Standby database role will change  to Primary.

               

              Do you want this?

               

              Regards

              Mahir M. Quluzade

              • 4. Re: How to recover standby by rman
                Hemant K Chitale

                An incremental backup FOR STANDBY is different from a "normal" incremental backup.  The Backup FOR STANDBY is from a certain SCN onwards -- the SCN of the Standby.

                 

                Hemant K Chitale


                • 5. Re: How to recover standby by rman
                  yasirdba

                  standby is already created ,but i want to restore the whole rman backup  to it.

                   

                  actually i want to test can i recover standby if my primary server has crashed.  i am testing this because i can not up standby server  all the time.

                   

                  Now i have successfully recovered standby if primary has crashed. plz does following steps are correct for recovery.

                   

                  On standby

                   

                  1) restore control file .

                  2) catalog backup

                  3)restore database

                  4) recover database

                  • 6. Re: How to recover standby by rman
                    yasirdba

                    Dear Mahir

                     

                    I have recoverd the standby upto the last generated archive log. but what about the redo log which is not archived still .

                    Does i have to use manually  use command "alter system switch logfile".

                    • 7. Re: How to recover standby by rman
                      Mahir M. Quluzade

                      i am testing this because i can not up standby server  all the time.


                      What is means I  cannot up standby every time?

                      • 8. Re: How to recover standby by rman
                        Mahir M. Quluzade

                        If your Data Guard  running real time apply,  then  not archived redo changes applied to standby,too.

                        Additionally, you can use Active Data Guard  for real time queries. your version is 11gR2

                        • 9. Re: How to recover standby by rman
                          yasirdba

                          Dear sir ,

                           

                          Actually my primary server is physical machine and standby server is virtual machine.

                           

                          I can not up the virtual machine all the time as i have resources limitation.

                          • 10. Re: How to recover standby by rman
                            Mahir M. Quluzade

                            It is no problem, If your primary is not stopped, and not received  archived logs is not deleted or backed up - deleted.

                            Then you not need any restore database. You can start   standby database, primary will send all required archived logs to standby.

                            If occur GAP, then you can use Roll Forward standby database with RMAN incremental backups.

                             

                            Regards

                            Mahir M. Quluzade

                            • 11. Re: How to recover standby by rman
                              Hemant K Chitale

                              >I can not up the virtual machine all the time as i have resources limitation

                              Then it is NOT a "standby" if it is not running continuously.  It is a "restore site" where you have to do a RESTORE DATABASE and RECOVER DATABASE.

                               

                              Hemant K Chitale