1 2 Previous Next 20 Replies Latest reply: Aug 13, 2013 4:21 AM by newbieDBA RSS

    Active Data Guard

    newbieDBA

      hii guys ,

      I have configured successful active data-guard ,

      Now , i taken backup of Primary Database BUT same time i didn't Start Standby Database , SO-- both log sequence are now changed

      Now , How can i SYNC them again?

        • 1. Re: Active Data Guard
          Abufazal

          start the media recovery and it should be in sync provided all the primary archive logs are available since the last applied log.

          • 2. Re: Active Data Guard
            Hemant K Chitale

            Restart the Primary and the Standby and let Oracle DataGuard "auto-catchup".

             

             

            Hemant K Chitale


            • 3. Re: Active Data Guard
              newbieDBA

              after restarting both Databases -

              MY primary DB =

              select sequence# from v$log;

               

              SEQUENCE#

              ----------

                  28

                  29

                  30

              MY standby DB =

              select sequence# from v$log;

               

              SEQUENCE#

              ----------

                  22

                  20

                  24

              • 4. Re: Active Data Guard
                newbieDBA

                MY standby dataguard status

                 

                select database_role from v$database;

                 

                DATABASE_ROLE

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

                PHYSICAL STANDBY

                • 5. Re: Active Data Guard
                  Abufazal

                  What is output of the following in standby database?

                   

                  SQL>select  PROCESS,PID,STATUS,THREAD#,SEQUENCE# from v$MANAGED_STANDBY;

                  • 7. Re: Active Data Guard
                    newbieDBA

                    select  PROCESS,PID,STATUS,THREAD#,SEQUENCE# from v$MANAGED_STANDBY;

                     

                    PROCESS      PID STATUS         THREAD#  SEQUENCE#

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

                    ARCH        4972 CONNECTED           0          0

                    ARCH        4974 CONNECTED           0          0

                    ARCH        4976 CONNECTED           0          0

                    ARCH        4978 CONNECTED           0          0

                    • 8. Re: Active Data Guard
                      Abufazal

                      Media recovery is not running in your standby database.

                       

                      You need start MRP in standby as follows:

                       

                      SQL> alter database recover managed standby database disconnect;

                      • 9. Re: Active Data Guard
                        newbieDBA

                        how to make sure that i configured perfect active dataguard ,

                        i guess it was perfect because whatever i make changes , like create table in primary database , in next second it was reflected in standby read only database.

                        • 10. Re: Active Data Guard
                          newbieDBA

                          Thanks i did that , but still log sequence Dsnt match

                           

                          SQL> alter database recover managed standby database disconnect;

                           

                          Database altered.

                           

                          after that i checked - Primary

                          SQL> select sequence# from v$log;

                           

                          SEQUENCE#

                          ----------

                              28

                              29

                              30

                          ---and stnadby DB----

                          SQL> select sequence# from v$log;

                           

                          SEQUENCE#

                          ----------

                              22

                              20

                              24

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

                          • 11. Re: Active Data Guard
                            Abufazal

                            What the following query says now?


                            SQL>select  PROCESS,PID,STATUS,THREAD#,SEQUENCE# from v$MANAGED_STANDBY;



                            Also, could you paste the alert log entries from primary and standby database

                            • 12. Re: Active Data Guard
                              hervedbi

                              To be sure that active guard is running, you must only report the value of OPEN_MODE from V$DATABASE on STANDBY DATABASE

                               

                              which sould be READ ONLY WITH APPLY

                              • 13. Re: Active Data Guard
                                newbieDBA

                                alert log details -

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

                                Fatal NI connect error 12541, connecting to:

                                (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.2)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=prim)(CID=(PROGRAM=oracle)(HOST=stnd)(USER=oracle))))

                                 

                                  VERSION INFORMATION:

                                    TNS for Linux: Version 12.1.0.1.0 - Production

                                    TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.1.0 - Production

                                  Time: 13-AUG-2013 11:36:37

                                  Tracing not turned on.

                                  Tns error struct:

                                    ns main err code: 12541

                                   

                                TNS-12541: TNS:no listener

                                    ns secondary err code: 12560

                                    nt main err code: 511

                                   

                                TNS-00511: No listener

                                    nt secondary err code: 111

                                    nt OS err code: 0

                                 

                                 

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

                                 

                                Fatal NI connect error 12541, connecting to:

                                (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.2)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=prim)(CID=(PROGRAM=oracle)(HOST=stnd)(USER=oracle))))

                                 

                                  VERSION INFORMATION:

                                    TNS for Linux: Version 12.1.0.1.0 - Production

                                    TCP/IP NT Protocol Adapter for Linux: Version 12.1.0.1.0 - Production

                                  Time: 13-AUG-2013 11:36:37

                                  Tracing not turned on.

                                  Tns error struct:

                                    ns main err code: 12541

                                   

                                TNS-12541: TNS:no listener

                                    ns secondary err code: 12560

                                    nt main err code: 511

                                   

                                TNS-00511: No listener

                                    nt secondary err code: 111

                                    nt OS err code: 0

                                Tue Aug 13 11:36:37 2013

                                Error 12541 received logging on to the standby

                                Check whether the listener is up and running.

                                FAL[client, ARC2]: Error 12541 connecting to PRIM for fetching gap sequence

                                Tue Aug 13 11:36:37 2013

                                AUDIT_TRAIL initialization parameter is changed to OS, as DB is NOT compatible for database opened with read-only access

                                Tue Aug 13 11:36:37 2013

                                SMON: enabling cache recovery

                                Tue Aug 13 11:36:37 2013

                                Dictionary check beginning

                                Dictionary check complete

                                Database Characterset is WE8MSWIN1252

                                No Resource Manager plan active

                                replication_dependency_tracking turned off (no async multimaster replication found)

                                Physical standby database opened for read only access.

                                Completed: ALTER DATABASE OPEN READ ONLY

                                Tue Aug 13 11:36:38 2013

                                db_recovery_file_dest_size of 4800 MB is 0.94% used. This is a

                                user-specified limit on the amount of space that will be used by this

                                database for recovery-related files, and does not reflect the amount of

                                space available in the underlying filesystem or ASM diskgroup.

                                Tue Aug 13 11:36:38 2013

                                ARC3: Archival started

                                ARC0: STARTING ARCH PROCESSES COMPLETE

                                ALTER DATABASE RECOVER  database  

                                Tue Aug 13 11:38:25 2013

                                Media Recovery Start

                                Tue Aug 13 11:38:25 2013

                                Serial Media Recovery started

                                Managed Standby Recovery not using Real Time Apply

                                Tue Aug 13 11:38:25 2013

                                Media Recovery failed with error 10459

                                ORA-283 signalled during: ALTER DATABASE RECOVER  database   ...

                                alter database recover managed standby database disconnect

                                Tue Aug 13 11:47:16 2013

                                Attempt to start background Managed Standby Recovery process (std)

                                Starting background process MRP0

                                Tue Aug 13 11:47:16 2013

                                MRP0 started with pid=26, OS id=5111

                                Tue Aug 13 11:47:16 2013

                                MRP0: Background Managed Standby Recovery process started (std)

                                Tue Aug 13 11:47:21 2013

                                Serial Media Recovery started

                                Managed Standby Recovery starting Real Time Apply

                                Tue Aug 13 11:47:21 2013

                                Waiting for all non-current ORLs to be archived...

                                Tue Aug 13 11:47:21 2013

                                All non-current ORLs have been archived.

                                Tue Aug 13 11:47:21 2013

                                Recovery of Online Redo Log: Thread 1 Group 4 Seq 24 Reading mem 0

                                  Mem# 0: /u01/app/oracle/oradata/std/standby_redo01.log

                                Completed: alter database recover managed standby database disconnect

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

                                 

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

                                select  PROCESS,PID,STATUS,THREAD#,SEQUENCE# from v$MANAGED_STANDBY;

                                 

                                PROCESS      PID STATUS         THREAD#  SEQUENCE#

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

                                ARCH        4972 CONNECTED           0          0

                                ARCH        4974 CONNECTED           0          0

                                ARCH        4976 CONNECTED           0          0

                                ARCH        4978 CONNECTED           0          0

                                MRP0        5111 APPLYING_LOG       1         24

                                • 14. Re: Active Data Guard
                                  Abufazal

                                  As per the logs, listener is not running.

                                   

                                  Make sure listener is running on both primary and standby servers. Also make sure remote connectivity is working fine for both the databases.

                                  1 2 Previous Next