8 Replies Latest reply: Jun 8, 2014 10:06 PM by petra-K RSS

    How to convert active dataguard to non-active?

      Hi all,

       

      11.2.0.3

       

      How do I convert or revert back active dataguard to non-active?

       

       

      Thanks all,

      pK

        • 1. Re: How to convert active dataguard to non-active?
          FreddieEssex

          shutdown immediate;

          startup mount;

          alter database recover managed standby database disconnect from session;

          • 2. Re: How to convert active dataguard to non-active?

            Thanks dear , you mean it is just like shutting down the instance?  wait I will try that ...brb

            • 3. Re: How to convert active dataguard to non-active?

              Yeah you are correct

               

              Thanksssssss

              • 4. Re: How to convert active dataguard to non-active?

                Hi Fred,

                 

                After I did the above commands, my MRP0 does not start anymore

                 

                I repeat the cancel apply shutdown db and start apply again, but mrp0 is not starting.

                 

                At primary:

                SEQUENCE# FIRST_TIM APPLIED

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

                       532 05-JUN-14 YES

                       533 05-JUN-14 YES

                       534 05-JUN-14 YES

                       535 05-JUN-14 YES

                       536 05-JUN-14 YES

                       537 06-JUN-14 YES

                       538 06-JUN-14 YES

                       539 06-JUN-14 YES

                       540 06-JUN-14 YES

                       541 06-JUN-14 NO

                       542 06-JUN-14 NO

                       543 06-JUN-14 NO

                 

                SQL> select client_process, process, sequence#, status from v$managed_standby;

                 

                 

                CLIENT_P PROCESS    SEQUENCE# STATUS

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

                ARCH     ARCH             540 CLOSING

                ARCH     ARCH             541 CLOSING

                ARCH     ARCH               0 CONNECTED

                ARCH     ARCH             541 CLOSING

                LNS      LNS              543 WRITING

                 

                 

                SQL>  alter database recover managed standby database using current logfile disconnect;

                 

                Database altered.

                 

                SQL> select client_process, process, sequence#, status from v$managed_standby;

                 

                 

                CLIENT_P PROCESS    SEQUENCE# STATUS

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

                ARCH     ARCH             543 CLOSING

                ARCH     ARCH               0 CONNECTED

                ARCH     ARCH               0 CONNECTED

                ARCH     ARCH               0 CONNECTED

                ARCH     ARCH               0 CONNECTED

                ARCH     RFS                0 IDLE

                LGWR     RFS              544 IDLE

                UNKNOWN  RFS                0 IDLE

                 

                 

                How do I startup force the MRP0?

                 

                Thanks

                • 5. Re: How to convert active dataguard to non-active?
                  mseberg

                  Hello;

                   

                  Refresh my memory. Are you using Data Guard Broker?

                   

                  What does the Standby alert log show?

                   

                  Best Regards

                   

                  mseberg

                  • 6. Re: How to convert active dataguard to non-active?
                    yasinyazici

                    Hi

                    you can following steps to convert activa data guard to non-active

                     

                    SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

                    SQL>SHUTDOWN IMMEDIATE;

                    SQL>startup nomount;

                    SQL>alter database mount standby database;

                    SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

                     

                    I hope help you

                    yasin

                    • 7. Re: How to convert active dataguard to non-active?
                      FreddieEssex

                      Hi,

                       

                      I've just tested and it's working fine for me without broker.

                       

                      mseberg might be on the right track with Dataguard Broker.

                       

                      I've just tested with and without broker and in both cases the managed recovery process started as expected. (with broker I used set state to read-only and then apply-on).

                      • 8. Re: How to convert active dataguard to non-active?

                        I thank you all,

                         

                        My alert logs show that wallet is not open and also I have this errors:

                        Errors in file /u20/app/oracle/diag/rdbms/UATDR/UATDR/trace/UATDR_dbw0_7078022.trc:

                        ORA-01157: cannot identify/lock data file 201 - see DBWR trace file

                        ORA-01110: data file 201: '/u21/ORACLE/ORADATA/UATDR/temp01.dbf'

                        ORA-27037: unable to obtain file status

                        IBM AIX RISC System/6000 Error: 2: No such file or directory

                        Additional information: 3

                        Errors in file /u20/app/oracle/diag/rdbms/UATDR/UATDR/trace/UATDR_dbw0_7078022.trc:

                        ORA-01186: file 201 failed verification tests

                        ORA-01157: cannot identify/lock data file 201 - see DBWR trace file

                        ORA-01110: data file 201: '/u21/ORACLE/ORADATA/UATDR/temp01.dbf'

                        File 201 not verified due to error ORA-01157

                        Dictionary check complete

                        Re-creating tempfile /u21/ORACLE/ORADATA/UATDR/temp01.dbf

                        Database Characterset is US7ASCII

                        No Resource Manager plan active

                        **********************************************************

                        WARNING: Files may exists in db_recovery_file_dest

                        that are not known to the database. Use the RMAN command

                        CATALOG RECOVERY AREA to re-catalog any such files.

                        If files cannot be cataloged, then manually delete them

                        using OS command.

                        One of the following events caused this:

                        1. A backup controlfile was restored.

                        2. A standby controlfile was restored.

                        3. The controlfile was re-created.

                        4. db_recovery_file_dest had previously been enabled and

                           then disabled.

                        **********************************************************

                         

                        One of the causes is encryption "Wallet" TDE not being opened. I always forget to open it when the db undergone bouncing. After I opened it the MRP0 starts applying logs.

                         

                        But I am concerned about the tempfile how to recreate it at standby?

                         

                         

                        Thanks