9 Replies Latest reply: Jan 29, 2014 7:43 AM by 975791 RSS

    rebuild standby

    975791

      Hi,

       

      How to decide to rebuild the standby in oracle 11.2.
      We tried to sync both primary and standby.But no use.

      Log are shipping to standby,but not applied in standby.


      Br,
      Raj

        • 1. Re: rebuild standby
          Sunny kichloo

          Did you see if MRP Process is running or not on standby databases???

           

          Also did you find some errors in alert.log of Primary or Standby Database???

          • 2. Re: rebuild standby
            asdPro

            What does it say when you start the managed recovery process?

             

             

            RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

             

             

             

            Are there any errors in the alert_log after this statement? Also is there any MRP process in the v$managed_standby view?

             

             

            SELECT process,state from v$managed_standby;

             

             

             

            Maybe there is a gap, that you need to resolve first. What's the output of

             

             

            SELECT * from v$archive_gap on the standby?

            • 3. Re: rebuild standby
              975791

              Hi,

               

               

              I executed below one.Any suggestions.

               

              SELECT process,state from v$managed_standby;

               

              PROCESSSTATUS

              ---------- ----------

              ARCH   CLOSING
              ARCH   CLOSING
              ARCH   CLOSING
              ARCH   CONNECTED
              ARCH   CLOSING
              ARCH   CLOSING
              RFS    IDLE
              RFS    IDLE
              RFS    IDLE
              MRP0   WAIT_FOR_L
                     OG

               

              PROCESSSTATUS

              ---------- ----------

               

               

              SELECT * from v$archive_gap on the standby?

               

              No rows

               

              Br,

               

              Raj

              • 4. Re: rebuild standby
                mseberg

                Hello;

                 

                I have never trusted the results of v$archive_gap. Can you run this query on your Primary and post the results:

                 

                http://www.visi.com/~mseberg/data_guard/monitor_data_guard_transport.html

                 

                Best Regards

                 

                mseberg

                • 5. Re: rebuild standby
                  saurabh

                  SELECT process,status,sequence#,block#  from v$managed_standby; on standby dataabse and paste the output.


                  As it look likes there is a archive log gap.

                  • 6. Re: rebuild standby
                    975791

                    Hi,

                     

                    Thanks your reply.

                     

                     

                    SQL> SELECT process,status,sequence#,block#  from v$managed_standby;

                     

                    PROCESS    STATUS      SEQUENCE#     BLOCK#

                    ---------- ---------- ---------- ----------

                    ARCH       CLOSING          1868          1

                    ARCH       CLOSING          1864       2048

                    ARCH       CLOSING          1871          1

                    ARCH       CONNECTED           0          0

                    ARCH       CLOSING          1867          1

                    ARCH       CLOSING          1870          1

                    RFS        IDLE                0          0

                    RFS        IDLE             1872        242

                    RFS        IDLE                0          0

                    MRP0       WAIT_FOR_L          6          0

                               OG

                     

                    PROCESS    STATUS      SEQUENCE#     BLOCK#

                    ---------- ---------- ---------- ----------

                     

                     

                    10 rows selected.

                     

                     

                     

                    Br,

                    Raj

                    • 7. Re: rebuild standby
                      asdPro

                      Your recovery process is working, as it seems, just waiting for logs. Now the question would be, are the two databases in sync or there's a gap?

                       

                      To make it absolutely sure, please query

                       

                      SELECT switchover_status from v$database;

                       

                      from the primary site. If it says TO_STANDBY or there are sessions connected, you are OK, if it says RESOLVABLE_GAP or something like that, there is a gap and you need to find out where. Check out the alert log on the standby site, or if you are lazy, stop the recovery process:

                       

                      RECOVER MANAGED STANDBY DATABASE CANCEL;

                       

                      and restart it

                       

                      RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

                       

                      then observe the alert log (still on the standby) and watch out for the gap message. Alternatively, you can compare the archived redo log sequences from both databases.

                      • 8. Re: rebuild standby
                        975791

                        Hi,

                         

                        Thanks for your reply.

                         

                        Due to archive gap,it shown WAIT_FOR_LOG.

                         

                         

                        PROCESS                              STATUS      SEQUENCE#     BLOCK#

                        ------------------------------------ ---------- ---------- ----------

                        ARCH                                 CLOSING          1877       6144

                        ARCH                                 CLOSING            28          1

                        ARCH                                 CLOSING            27          1

                        ARCH                                 CONNECTED           0          0

                        ARCH                                 CLOSING            25          1

                        ARCH                                 CLOSING          1878          1

                        RFS                                  IDLE                0          0

                        RFS                                  IDLE             1879     119994

                        RFS                                  IDLE                0          0

                        MRP0                                 APPLYING_L         29      30785

                                                             OG

                         

                        PROCESS                              STATUS      SEQUENCE#     BLOCK#

                        ------------------------------------ ---------- ---------- ----------

                         

                        RFS                                  IDLE                0          0

                        RFS                                  IDLE               29      30786

                        RFS                                  IDLE                0          0

                         

                        Now it works.

                         

                        Br,

                        Raj

                        • 9. Re: rebuild standby
                          Anar Godjaev

                          Hi,

                           

                          can you pleas paste result in Primary location:

                           

                          SELECT status, error

                          FROM V$ARCHIVE_DEST_STATUS

                          WHERE STATUS <> 'DEFERRED' AND STATUS <> 'INACTIVE';

                           

                          and please past result in Secondary location:

                           

                          select name, value from v$dataguard_Stats;

                           

                          Thank you