Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

Error ORA-16627 operation disallowed since no standby databases

Posted by Hendry chinnapparaj on May 17, 2010

 

Error ORA-16627 operation disallowed since no standby databases

1.1     Initiate Switchover

 

On either the primary or the standby side start a DGMGRL session and issue the following:

DGMGRL> switchover to cpstest_f;

Performing switchover NOW, please wait…

Error: ORA-16627: operation disallowed since no standby databases would remain to support protection mode

Failed.

Unable to switchover, primary database is still “cpstest_j”

DGMGRL> show database verbose cpstest_j;

Database

  Name:            cpstest_j

  Role:            PRIMARY

  Enabled:         YES

  Intended State:  ONLINE

  Instance(s):

    cpstest

  Properties:

    InitialConnectIdentifier        = ‘cpstest_j’

    ObserverConnectIdentifier       = ”

    LogXptMode                      = ‘ASYNC

    Dependency                      = ”

    DelayMins                       = ‘0’

    Binding                         = ‘OPTIONAL’

    MaxFailure                      = ‘0’

    MaxConnections                  = ‘1’

    ReopenSecs                      = ‘300’

    NetTimeout                      = ‘180’

    LogShipping                     = ‘ON’

    PreferredApplyInstance          = ”

    ApplyInstanceTimeout            = ‘0’

    ApplyParallel                   = ‘AUTO’

    StandbyFileManagement           = ‘AUTO’

    ArchiveLagTarget                = ‘0’

    LogArchiveMaxProcesses          = ‘2’

    LogArchiveMinSucceedDest        = ‘1’

    DbFileNameConvert               = ”

    LogFileNameConvert              = ”

    FastStartFailoverTarget         = ”

    StatusReport                    = ‘(monitor)’

    InconsistentProperties          = ‘(monitor)’

    InconsistentLogXptProps         = ‘(monitor)’

    SendQEntries                    = ‘(monitor)’

    LogXptStatus                    = ‘(monitor)’

    RecvQEntries                    = ‘(monitor)’

    HostName                        = ‘devu009n3’

    SidName                         = ‘cpstest’

    LocalListenerAddress            = ‘(address=(protocol=TCP)(host=devu009n3)(port=1521))’

    StandbyArchiveLocation          = ‘?/dbs/arch’

    AlternateLocation               = ”

    LogArchiveTrace                 = ‘0’

    LogArchiveFormat                = ‘ARC%S_%R.%T’

    LatestLog                       = ‘(monitor)’

    TopWaitEvents                   = ‘(monitor)’

Current status for “cpstest_j”:

SUCCESS

DGMGRL> show database verbose cpstest_f;

Database

  Name:            cpstest_f

  Role:            PHYSICAL STANDBY

  Enabled:         YES

  Intended State:  ONLINE

  Instance(s):

    cpstest

  Properties:

    InitialConnectIdentifier        = ‘cpstest_f’

    ObserverConnectIdentifier       = ”

    LogXptMode                      = ‘SYNC’

    Dependency                      = ”

    DelayMins                       = ‘0’

    Binding                         = ‘OPTIONAL’

    MaxFailure                      = ‘0’

    MaxConnections                  = ‘1’

    ReopenSecs                      = ‘300’

    NetTimeout                      = ‘180’

    LogShipping                     = ‘ON’

    PreferredApplyInstance          = ”

    ApplyInstanceTimeout            = ‘0’

    ApplyParallel                   = ‘AUTO’

    StandbyFileManagement           = ‘AUTO’

    ArchiveLagTarget                = ‘0’

    LogArchiveMaxProcesses          = ‘2’

    LogArchiveMinSucceedDest        = ‘1’

    DbFileNameConvert               = ”

    LogFileNameConvert              = ”

    FastStartFailoverTarget         = ”

    StatusReport                    = ‘(monitor)’

    InconsistentProperties          = ‘(monitor)’

    InconsistentLogXptProps         = ‘(monitor)’

    SendQEntries                    = ‘(monitor)’

    LogXptStatus                    = ‘(monitor)’

    RecvQEntries                    = ‘(monitor)’

    HostName                        = ‘devu009n4’

    SidName                         = ‘cpstest’

    LocalListenerAddress            = ‘(address=(protocol=TCP)(host=devu009n4)(port=1521))’

    StandbyArchiveLocation          = ‘?/dbs/arch’

    AlternateLocation               = ”

    LogArchiveTrace                 = ‘0’

    LogArchiveFormat                = ‘ARC%S_%R.%T’

    LatestLog                       = ‘(monitor)’

    TopWaitEvents                   = ‘(monitor)’

Current status for “cpstest_f”:

SUCCESS

DGMGRL> edit database cpstest_j set property LogXptMode=’SYNC’;

Property “logxptmode” updated

DGMGRL> show database verbose cpstest_j;

Database

  Name:            cpstest_j

  Role:            PRIMARY

  Enabled:         YES

  Intended State:  ONLINE

  Instance(s):

    cpstest

  Properties:

    InitialConnectIdentifier        = ‘cpstest_j’

    ObserverConnectIdentifier       = ”

    LogXptMode                      = ‘SYNC

    Dependency                      = ”

    DelayMins                       = ‘0’

DGMGRL> switchover to cpstest_j;

Performing switchover NOW, please wait…

Operation requires shutdown of instance “cpstest” on database “cpstest_f”

Shutting down instance “cpstest”…

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

Operation requires shutdown of instance “cpstest” on database “cpstest_j”

Shutting down instance “cpstest”…

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

Operation requires startup of instance “cpstest” on database “cpstest_f”

Starting instance “cpstest”…

ORACLE instance started.

Database mounted.

Operation requires startup of instance “cpstest” on database “cpstest_j”

Starting instance “cpstest”…

ORACLE instance started.

Database mounted.

Switchover succeeded, new primary is “cpstest_j”

DGMGRL> show configuration;

Configuration

  Name:                cpstest_dgb

  Enabled:             YES

  Protection Mode:     MaxAvailability

  Fast-Start Failover: DISABLED

  Databases:

    cpstest_j – Primary database

    cpstest_f – Physical standby database

Current status for “cpstest_dgb”:

SUCCESS

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: