1 2 Previous Next 21 Replies Latest reply: Nov 6, 2013 7:11 AM by user8792751 RSS

    Data Guard issue with Switch Over

    user8792751

      Hi ,

       

      Iam currently testing a Data Guard Swith over scenarioes for the Physical standby database with Oracle 11.2.0.2 on windows

       

      Machine 1:

      db_unique_name = prd

      hostname=IE11VW1FHRDG1

       

      Machine 2 :

      db_unique_name = stdby

      hostname=IE11VW1FHRDG1

       

      {code:sql}

      DGMGRL> show configuration

       

       

      Configuration - dgconfig

       

       

        Protection Mode: MaxPerformance

        Databases:

          prd   - Primary database

          stdby - Physical standby database

       

       

      Fast-Start Failover: DISABLED

       

       

      Configuration Status:

      SUCCESS

      {code}

       

      Switching Over to standby

       

      {code}

      DGMGRL> switchover to "stdby"

      Performing switchover NOW, please wait...

      New primary database "stdby" is opening...

      Operation requires shutdown of instance "prd" on database "prd"

      Shutting down instance "prd"...

      ORACLE instance shut down.

      Operation requires startup of instance "prd" on database "prd"

      Starting instance "prd"...

      ORACLE instance started.

      Database mounted.

      Switchover succeeded, new primary is "stdby"

       

       

      DGMGRL>

      DGMGRL>

      DGMGRL>

      DGMGRL> SHOW configuration

       

       

      Configuration - dgconfig

       

       

        Protection Mode: MaxPerformance

        Databases:

          stdby - Primary database

          prd   - Physical standby database

       

       

      Fast-Start Failover: DISABLED

       

       

      Configuration Status:

      SUCCESS

      {/code}

       

       

      When i switch back to Primary (i.e) PRD , then iam getting the below error.

       

      {code}

      DGMGRL> switchover to "prd"

      Performing switchover NOW, please wait...

      New primary database "prd" is opening...

      Operation requires shutdown of instance "stdby" on database "stdby"

      Shutting down instance "stdby"...

      ORACLE instance shut down.

      Operation requires startup of instance "stdby" on database "stdby"

      Starting instance "stdby"...

      Unable to connect to database

      ORA-12521: TNS:listener does not currently know of instance requested in connect descriptor

       

       

      Failed.

      Warning: You are no longer connected to ORACLE.

       

       

      Please complete the following steps to finish switchover:

              start up and mount instance "stdby" of database "stdby"

      {/code}

       

       

      I have also configured the Listeners properly on the both servers.

       

      What could be the issue for the connection error ?

        • 1. Re: Data Guard issue with Switch Over
          Sunny kichloo

          Is your listener configured properly??

           

          Are you using GLOBAL_DBNAME in listener.ora file and does db_unique_name_DGMRL is present in your listener,ora??

          • 2. Re: Data Guard issue with Switch Over
            Mahir M. Quluzade

            You  must add prd_DGMGRL service  to new standby (old priamry) side.

            Edit listener.ora file on new standby side add this service, restart listener, try again

             

            As I saw,  you added this service to old standby (stby) side.

             

            Regards

            Mahir M. Quluzade

            • 3. Re: Data Guard issue with Switch Over
              user8792751

              Listerner.ora on IE11VW1FHRDG1

               

               

               

               

               

              LISTENER =

                (DESCRIPTION_LIST =

                  (DESCRIPTION =

                    (ADDRESS = (PROTOCOL = TCP)(HOST = IE11VW1FHRDG1.FHRCLUSTER.com)(PORT = 1521))

                    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

                  )

                )

               

               

              ADR_BASE_LISTENER = C:\app\admin

               

               

               

               

               

               

              SID_LIST_LISTENER =

                (SID_LIST =

                (SID_DESC =

                (GLOBAL_DBNAME = PRD)

                (ORACLE_HOME = C:\app\admin\product\11.2.0\dbhome_1)

                (SID_NAME = PRD)

                )

                (SID_DESC =

                (GLOBAL_DBNAME = PRD_DGMGRL)

                (ORACLE_HOME = C:\app\admin\product\11.2.0\dbhome_1)

                (SID_NAME = PRD)

                )

              )

               

               

               

              Listerner.ora on IE11VW1FHRDG2

               

               

               

               

              LISTENER =

                (DESCRIPTION_LIST =

                  (DESCRIPTION =

                    (ADDRESS = (PROTOCOL = TCP)(HOST = IE11VW1FHRDG2.FHRCLUSTER.com)(PORT = 1521))

                    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

                  )

                )

               

               

              ADR_BASE_LISTENER = C:\app\admin

               

               

               

               

              SID_LIST_LISTENER =

                (SID_LIST =

                (SID_DESC =

                (GLOBAL_DBNAME =STDBY)

                (ORACLE_HOME = C:\app\admin\product\11.2.0\dbhome_1)

                (SID_NAME = STDBY)

                )

                (SID_DESC =

                (GLOBAL_DBNAME =STDBY_DGMGRL)

                (ORACLE_HOME = C:\app\admin\product\11.2.0\dbhome_1)

                (SID_NAME = STDBY)

                )

              )

              • 4. Re: Data Guard issue with Switch Over
                Mahir M. Quluzade

                user8792751 wrote:

                 

                Listerner.ora on IE11VW1FHRDG1

                 

                 

                 

                 

                 

                LISTENER =

                  (DESCRIPTION_LIST =

                    (DESCRIPTION =

                      (ADDRESS = (PROTOCOL = TCP)(HOST = IE11VW1FHRDG1.FHRCLUSTER.com)(PORT = 1521))

                      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

                    )

                  )

                 

                 

                ADR_BASE_LISTENER = C:\app\admin

                 

                 

                 

                 

                 

                 

                SID_LIST_LISTENER =

                  (SID_LIST =

                  (SID_DESC =

                  (GLOBAL_DBNAME = PRD)

                  (ORACLE_HOME = C:\app\admin\product\11.2.0\dbhome_1)

                  (SID_NAME = PRD)

                  )

                  (SID_DESC =

                  (GLOBAL_DBNAME = PRD_DGMGRL)

                  (ORACLE_HOME = C:\app\admin\product\11.2.0\dbhome_1)

                  (SID_NAME = PRD)

                  )

                )

                 

                 

                 

                Listerner.ora on IE11VW1FHRDG2

                 

                 

                 

                 

                LISTENER =

                  (DESCRIPTION_LIST =

                    (DESCRIPTION =

                      (ADDRESS = (PROTOCOL = TCP)(HOST = IE11VW1FHRDG2.FHRCLUSTER.com)(PORT = 1521))

                      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

                    )

                  )

                 

                 

                ADR_BASE_LISTENER = C:\app\admin

                 

                 

                 

                 

                SID_LIST_LISTENER =

                  (SID_LIST =

                  (SID_DESC =

                  (GLOBAL_DBNAME =STDBY)

                  (ORACLE_HOME = C:\app\admin\product\11.2.0\dbhome_1)

                  (SID_NAME = STDBY)

                  )

                  (SID_DESC =

                  (GLOBAL_DBNAME =STDBY_DGMGRL)

                  (ORACLE_HOME = C:\app\admin\product\11.2.0\dbhome_1)

                  (SID_NAME = STDBY)

                  )

                )

                 

                Looks good, I  mean this.  Perform switch over again. What is result? paste here please.

                • 5. Re: Data Guard issue with Switch Over
                  user8792751

                  Same error Occured....

                   

                  DGMGRL> SHOW configuration

                   

                   

                  Configuration - dgconfig

                   

                   

                    Protection Mode: MaxPerformance

                    Databases:

                      prd   - Primary database

                      stdby - Physical standby database

                   

                   

                  Fast-Start Failover: DISABLED

                   

                   

                  Configuration Status:

                  SUCCESS

                   

                   

                  DGMGRL> switchover to "stdby"

                  Performing switchover NOW, please wait...

                  New primary database "stdby" is opening...

                  Operation requires shutdown of instance "prd" on database "prd"

                  Shutting down instance "prd"...

                  ORACLE instance shut down.

                  Operation requires startup of instance "prd" on database "prd"

                  Starting instance "prd"...

                  ORACLE instance started.

                  Database mounted.

                  Switchover succeeded, new primary is "stdby"

                  DGMGRL>

                  DGMGRL>

                  DGMGRL> switchover to "prd"

                  Performing switchover NOW, please wait...

                  New primary database "prd" is opening...

                  Operation requires shutdown of instance "stdby" on database "stdby"

                  Shutting down instance "stdby"...

                  ORACLE instance shut down.

                  Operation requires startup of instance "stdby" on database "stdby"

                  Starting instance "stdby"...

                  Unable to connect to database

                  ORA-12521: TNS:listener does not currently know of instance requested in connect descriptor

                   

                   

                  Failed.

                  Warning: You are no longer connected to ORACLE.

                   

                   

                  Please complete the following steps to finish switchover:

                          start up and mount instance "stdby" of database "stdby"

                  • 6. Re: Data Guard issue with Switch Over
                    Mahir M. Quluzade

                    Can  you  paste here how to you  connecting to DGMGRL? You must connect with  SYS explicitly.

                    Which side you  perform Switchover?

                    • 7. Re: Data Guard issue with Switch Over
                      user8792751

                      Iam connecting  from the Inital primary side where the db_unique_name is prd

                       

                       

                      C:\Users\bflex1>hostname

                      IE11VW1FHRDG1

                       

                      DGMGRL SYS/BFLEX

                      • 8. Re: Data Guard issue with Switch Over
                        Mahir M. Quluzade

                        You must connect from primary side.

                        It means if switch over performed, then primary is stby.

                        Connect from stby, try.

                        If  not solved, paste here results again.

                         

                        Regards

                        Mahir M. Quluzade 

                        • 9. Re: Data Guard issue with Switch Over
                          user8792751

                          Still the same error. I tried from he new primary side....

                           

                           

                          C:\Users\bflex1>hostname

                          IE11VW1FHRDG2

                           

                           

                          C:\Users\bflex1>SET ORACLE_SID=STDBY

                           

                           

                          C:\Users\bflex1>dgmgrl sys/BFLEX

                          DGMGRL for 64-bit Windows: Version 11.2.0.2.0 - 64bit Production

                           

                           

                          Copyright (c) 2000, 2009, Oracle. All rights reserved.

                           

                           

                          Welcome to DGMGRL, type "help" for information.

                          Connected.

                          DGMGRL> SHOW CONFIGURATION

                           

                           

                          Configuration - dgconfig

                           

                           

                            Protection Mode: MaxPerformance

                            Databases:

                              stdby - Primary database

                              prd   - Physical standby database

                           

                           

                          Fast-Start Failover: DISABLED

                           

                           

                          Configuration Status:

                          SUCCESS

                           

                           

                          DGMGRL> SWITCHOVER TO 'prd'

                          Performing switchover NOW, please wait...

                          New primary database "prd" is opening...

                          Operation requires shutdown of instance "stdby" on database "stdby"

                          Shutting down instance "stdby"...

                          ORACLE instance shut down.

                          Operation requires startup of instance "stdby" on database "stdby"

                          Starting instance "stdby"...

                          Unable to connect to database

                          ORA-12521: TNS:listener does not currently know of instance requested in connect descriptor

                           

                           

                          Failed.

                          Warning: You are no longer connected to ORACLE.

                           

                           

                          Please complete the following steps to finish switchover:

                                  start up and mount instance "stdby" of database "stdby"

                          • 10. Re: Data Guard issue with Switch Over
                            Mahir M. Quluzade

                            Did you  sure <db_unique_name>_DGMGRL services is running on Both Side? 

                             

                            lsnrctl status

                            lsnrctl stop

                            lsnrctl start

                             

                             

                            Regards

                            Mahir

                            • 11. Re: Data Guard issue with Switch Over
                              user8792751

                              On IE11VW1FHRDG1 :

                               

                               

                              C:\Users\bflex1>lsnrctl status

                               

                               

                              LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 06-NOV-2013 17:06:18

                               

                               

                              Copyright (c) 1991, 2010, Oracle.  All rights reserved.

                               

                               

                              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IE11VW1FHRDG1.FHRCLUSTER.com)(PORT=1521)))

                              STATUS of the LISTENER

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

                              Alias                     LISTENER

                              Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production

                              Start Date                06-NOV-2013 17:05:52

                              Uptime                    0 days 0 hr. 0 min. 27 sec

                              Trace Level               off

                              Security                  ON: Local OS Authentication

                              SNMP                      OFF

                              Listener Parameter File   C:\app\admin\product\11.2.0\dbhome_1\network\admin\listener.ora

                              Listener Log File         C:\app\admin\diag\tnslsnr\IE11VW1FHRDG1\listener\alert\log.xml

                              Listening Endpoints Summary...

                                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=IE11VW1FHRDG1.fhrcluster.com)(PORT=1521)))

                              Services Summary...

                              Service "PRD_DGMGRL" has 1 instance(s).

                                Instance "PRD", status UNKNOWN, has 1 handler(s) for this service...

                              The command completed successfully

                               

                               

                               

                               

                              On IE11VW1FHRDG2:

                               

                               

                               

                              C:\Users\bflex1>lsnrctl status

                               

                               

                              LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 06-NOV-2013 17:06:53

                               

                               

                              Copyright (c) 1991, 2010, Oracle.  All rights reserved.

                               

                               

                              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IE11VW1FHRDG2.FHRCLUSTER.com)(PORT=1521)))

                              STATUS of the LISTENER

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

                              Alias                     LISTENER

                              Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production

                              Start Date                06-NOV-2013 17:06:11

                              Uptime                    0 days 0 hr. 0 min. 45 sec

                              Trace Level               off

                              Security                  ON: Local OS Authentication

                              SNMP                      OFF

                              Listener Parameter File   C:\app\admin\product\11.2.0\dbhome_1\network\admin\listener.ora

                              Listener Log File         C:\app\admin\diag\tnslsnr\IE11VW1FHRDG2\listener\alert\log.xml

                              Listening Endpoints Summary...

                                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=IE11VW1FHRDG2.fhrcluster.com)(PORT=1521)))

                              Services Summary...

                              Service "STDBY_DGMGRL" has 1 instance(s).

                                Instance "STDBY", status UNKNOWN, has 1 handler(s) for this service...

                              The command completed successfully

                              • 12. Re: Data Guard issue with Switch Over
                                Mahir M. Quluzade

                                Can you paste here:

                                 

                                DGMGRL> show database verbose prd

                                DGMGRL> show database verbose stby

                                 

                                Regards

                                Mahir M. Quluzade

                                • 13. Re: Data Guard issue with Switch Over
                                  Mahir M. Quluzade

                                  and what is db_domain?

                                  May  be you must change :

                                  (GLOBAL_DBNAME =STDBY_DGMGRL.db_domain)

                                  (GLOBAL_DBNAME =PRD_DGMGRL.db_domain)




                                  • 14. Re: Data Guard issue with Switch Over
                                    user8792751

                                    My db_domain is null

                                     

                                    SQL> show parameter db_domain

                                     

                                     

                                    NAME                                 TYPE        VALUE

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

                                    db_domain                            string

                                    1 2 Previous Next