Re: switchover with DGMGRL
Date: Tue, 2 Jun 2015 13:16:00 -0500
Message-Id: <0051AF76-4800-4C5B-948B-BA082DB7F5EF_at_gmail.com>
On the standby, the static dgmgrl entry should be db_unique_name_dgmgrl. Which should be standby_dgmgrl it looks like.
Sent from my iPad
> On Jun 2, 2015, at 1:04 PM, max scalf <oracle.blog3_at_gmail.com> wrote:
>
> Hello all,
>
> I am trying to do a switchover for my test setup for DG, it work just fine if i do it with SQLPLUS but with data guard broker it does not work.
>
> primary host is called prime, secondary host is called standby and DB_name is PRIME while DB_UNIQUE_NAME is PRIME and STANDBY
>
> here is what i get when i do switchover with data guard broker. I have also pasted my listener and tns file below for both prime and standby. Would this be related to the parameter "StaticConnectIdentifier" ??
>
>
> [oracle_at_prime admin]$ dgmgrl /
> DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
>
> Copyright (c) 2000, 2009, Oracle. All rights reserved.
>
> Welcome to DGMGRL, type "help" for information.
> Connected.
> DGMGRL> show configuration;
>
> Configuration - prime
>
> Protection Mode: MaxPerformance
> Databases:
> prime - Primary database
> standby - Physical standby database
>
> Fast-Start Failover: DISABLED
>
> Configuration Status:
> SUCCESS
>
> DGMGRL> swithover to standby;
> Unrecognized command "swithover", try "help"
> DGMGRL> switchover to standby;
> Performing switchover NOW, please wait...
> Operation requires a connection to instance "prime" on database "standby"
> Connecting to instance "prime"...
> Unable to connect to database
> ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
>
> Failed.
> Warning: You are no longer connected to ORACLE.
>
> connect to instance "prime" of database "standby"
>
> DGMGRL>
> DGMGRL> show database verbose prime;
>
> Database - prime
>
> Role: PRIMARY
> Intended State: TRANSPORT-ON
> Instance(s):
> prime
>
> Properties:
> DGConnectIdentifier = 'prime'
> ObserverConnectIdentifier = ''
> LogXptMode = 'ASYNC'
> DelayMins = '0'
> Binding = 'optional'
> MaxFailure = '0'
> MaxConnections = '1'
> ReopenSecs = '300'
> NetTimeout = '30'
> RedoCompression = 'DISABLE'
> LogShipping = 'ON'
> PreferredApplyInstance = ''
> ApplyInstanceTimeout = '0'
> ApplyParallel = 'AUTO'
> StandbyFileManagement = 'AUTO'
> ArchiveLagTarget = '0'
> LogArchiveMaxProcesses = '4'
> LogArchiveMinSucceedDest = '1'
> DbFileNameConvert = ''
> LogFileNameConvert = ''
> FastStartFailoverTarget = ''
> InconsistentProperties = '(monitor)'
> InconsistentLogXptProps = '(monitor)'
> SendQEntries = '(monitor)'
> LogXptStatus = '(monitor)'
> RecvQEntries = '(monitor)'
> ApplyLagThreshold = '0'
> TransportLagThreshold = '0'
> TransportDisconnectedThreshold = '30'
> SidName = 'prime'
> StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=prime)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=prime_DGMGRL)(INSTANCE_NAME=prime)(SERVER=DEDICATED)))'
> StandbyArchiveLocation = '/data/oradata/prime/arch'
> AlternateLocation = ''
> LogArchiveTrace = '0'
> LogArchiveFormat = '%t_%s_%r.dbf'
> TopWaitEvents = '(monitor)'
>
> Database Status:
> SUCCESS
>
> DGMGRL>
> DGMGRL>
> DGMGRL> show database verbose standby;
>
> Database - standby
>
> Role: PHYSICAL STANDBY
> Intended State: APPLY-ON
> Transport Lag: 0 seconds (computed 0 seconds ago)
> Apply Lag: 0 seconds (computed 0 seconds ago)
> Apply Rate: 285.00 KByte/s
> Real Time Query: OFF
> Instance(s):
> prime
>
> Properties:
> DGConnectIdentifier = 'standby'
> ObserverConnectIdentifier = ''
> LogXptMode = 'ASYNC'
> DelayMins = '0'
> Binding = 'optional'
> MaxFailure = '0'
> MaxConnections = '1'
> ReopenSecs = '300'
> NetTimeout = '30'
> RedoCompression = 'DISABLE'
> LogShipping = 'ON'
> PreferredApplyInstance = ''
> ApplyInstanceTimeout = '0'
> ApplyParallel = 'AUTO'
> StandbyFileManagement = 'AUTO'
> ArchiveLagTarget = '0'
> LogArchiveMaxProcesses = '4'
> LogArchiveMinSucceedDest = '1'
> DbFileNameConvert = ''
> LogFileNameConvert = '/data/oradata/prime/redoA/, /data/oradata/prime/redoA/, /data/oradata/prime/redoB/, /data/oradata/prime/redoB/, /data/oradata/prime/standbylog, /data/oradata/prime/standbylog'
> FastStartFailoverTarget = ''
> InconsistentProperties = '(monitor)'
> InconsistentLogXptProps = '(monitor)'
> SendQEntries = '(monitor)'
> LogXptStatus = '(monitor)'
> RecvQEntries = '(monitor)'
> ApplyLagThreshold = '0'
> TransportLagThreshold = '0'
> TransportDisconnectedThreshold = '30'
> SidName = 'prime'
> StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=standby)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=standby_DGMGRL)(INSTANCE_NAME=prime)(SERVER=DEDICATED)))'
> StandbyArchiveLocation = '/data/oradata/prime/arch'
> AlternateLocation = ''
> LogArchiveTrace = '0'
> LogArchiveFormat = '%t_%s_%r.dbf'
> TopWaitEvents = '(monitor)'
>
> Database Status:
> SUCCESS
>
> DGMGRL>
>
>
>
> here is the TNS and listener file for primary
>
> [oracle_at_prime ~]$ cd /ora_home/app/product/11.2/dbhome/network/admin/
> [oracle_at_prime admin]$ cat listener.ora
> LISTENER_PRIME =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = prime)(PORT = 1540))
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1540))
> )
> )
>
> ADR_BASE_LISTENER_TESTDB = /ora_home
>
> ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_PRIME=ON # line added by Agent
>
> SID_LIST_LISTENER_PRIME=
> (SID_LIST=
> (SID_DESC=
> (GLOBAL_DBNAME=prime)
> (SID_NAME=prime)
> (ORACLE_HOME=/ora_home/app/product/11.2/dbhome)
> )
> (SID_DESC=
> (GLOBAL_DBNAME=prime_DGMGRL)
> (SID_NAME=prime)
> (ORACLE_HOME=/ora_home/app/product/11.2/dbhome)
> )
> )
> [oracle_at_prime admin]$ cat tnsnames.ora
> LISTENER_PRIME =
> (ADDRESS = (PROTOCOL = TCP)(HOST = prime)(PORT = 1540))
>
>
> PRIME =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = prime)(PORT = 1540))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = prime)
> )
> )
>
> # Note service_name = prime, as the DB is still going to be called prime
> # it is only the db_unique_name that standby
> STANDBY =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1545))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = prime)
> )
> )
>
> [oracle_at_prime admin]$
>
>
>
>
> Here is the listener and tns for standby server...
>
> [oracle_at_standby ~]$ cd /ora_home/app/product/11.2/dbhome/network/admin/
> [oracle_at_standby admin]$ cat listener.ora
> LISTENER_STANDBY =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1545))
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1545))
> )
> )
>
> ADR_BASE_LISTENER_TESTDB = /ora_home
>
> ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_PRIME=ON # line added by Agent
>
> SID_LIST_LISTENER_STANDBY=
> (SID_LIST=
> (SID_DESC=
> (GLOBAL_DBNAME=prime)
> (SID_NAME=prime)
> (ORACLE_HOME=/ora_home/app/product/11.2/dbhome)
> )
> (SID_DESC=
> (GLOBAL_DBNAME=prime_DGMGRL)
> (SID_NAME=prime)
> (ORACLE_HOME=/ora_home/app/product/11.2/dbhome)
> )
> )
> [oracle_at_standby admin]$
> [oracle_at_standby admin]$ cat tnsnames.ora
> LISTENER_STANDBY =
> (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1545))
>
>
> PRIME =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = prime)(PORT = 1540))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = prime)
> )
> )
>
> # Note service_name = prime, as the DB is still going to be called prime
> # it is only the db_unique_name that standby
> STANDBY =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1545))
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = prime)
> )
> )
>
> [oracle_at_standby admin]$
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 02 2015 - 20:16:00 CEST