This discussion is archived
1 2 Previous Next 21 Replies Latest reply: Nov 6, 2013 5:11 AM by user8792751 RSS

Data Guard issue with Switch Over

user8792751 Newbie
Currently Being Moderated

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 Expert
    Currently Being Moderated

    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
    MahirM.Quluzade Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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
    MahirM.Quluzade Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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
    MahirM.Quluzade Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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
    MahirM.Quluzade Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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
    MahirM.Quluzade Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    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
    MahirM.Quluzade Guru
    Currently Being Moderated

    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
    MahirM.Quluzade Guru
    Currently Being Moderated

    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 Newbie
    Currently Being Moderated

    My db_domain is null

     

    SQL> show parameter db_domain

     

     

    NAME                                 TYPE        VALUE

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

    db_domain                            string

1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points