November 18 2015

ora-16651

DGMGRL> enable fast_start failover
Error: ORA-16651: requirements not met for enabling fast-start failover

Failed.

 

SQL> ho oerr ora 16651
16651, 0000, “requirements not met for enabling fast-start failover”
// *Cause: The attempt to enable fast-start failover could not be completed
// because one or more requirements were not met:
// – The Data Guard configuration must be in either MaxAvailability
// or MaxPerformance protection mode.
// – The LogXptMode property for both the primary database and
// the fast-start failover target standby database must be
// set to SYNC if the configuration protection mode is set to
// MaxAvailability mode.
// – The LogXptMode property for both the primary database and
// the fast-start failover target standby database must be
// set to ASYNC if the configuration protection mode is set to
// MaxPerformance mode.
// – The primary database and the fast-start failover target standby
// database must both have flashback enabled.
// – No valid target standby database was specified in the primary
// database FastStartFailoverTarget property prior to the attempt
// to enable fast-start failover, and more than one standby
// database exists in the Data Guard configuration.
// *Action: Retry the command after correcting the issue:
// – Set the Data Guard configuration to either MaxAvailability
// or MaxPerformance protection mode.
// – Ensure that the LogXptMode property for both the primary
// database and the fast-start failover target standby database
// are set to SYNC if the configuration protection mode is set to
// MaxAvailability.
// – Ensure that the LogXptMode property for both the primary
// database and the fast-start failover target standby database
// are set to ASYNC if the configuration protection mode is set to
// MaxPerformance.
// – Ensure that both the primary database and the fast-start failover
// target standby database have flashback enabled.
// – Set the primary database FastStartFailoverTarget property to
// the DB_UNIQUE_NAME value of the desired target standby database
// and the desired target standby database FastStartFailoverTarget
// property to the DB_UNIQUE_NAME value of the primary database.

DGMGRL> edit database orcl set property FastStartFailoverTarget=’sbdb’;
Property “faststartfailovertarget” updated
DGMGRL> edit database sbdb set property FastStartFailoverTarget=’orcl’;
Property “faststartfailovertarget” updated

DGMGRL> edit database orcl set property LogXptMode=’SYNC’;
Property “logxptmode” updated
DGMGRL> edit database sbdb set property LogXptMode=’SYNC’;
Property “logxptmode” updated

 

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MaxAvailability;
Succeeded.

 

 

SQL> alter database flashback on;

Database altered.

 

 

DGMGRL> enable configuration
Enabled.
DGMGRL> enable fast_start failover
Enabled.

 

 



Copyright 2019. All rights reserved.

Posted 2015年11月18日 by ucjmh in category "oracle

Leave a Reply

Your email address will not be published. Required fields are marked *