ORA-16651: requirements not met for enabling fast-start failover

When you want to enable fast start failover, you may get “ORA-16651: requirements not met for enabling fast-start failover”.

For solution

1-) Check if flashback is enable

select flashback_on from v$database;

If this returns NO, then enable it using “alter database flashback ON;” command.

2-) Check FastStartFailoverTarget parameter

You can set it using these commands :
PS: DBA is Primary, DBB is Standby database
edit database ‘DBA’ set property FastStartFailoverTarget=’DBB’;
edit database ‘DBB’ set property FastStartFailoverTarget=’DBA’;

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