ORA-16654: Fast-Start Failover is enabled
I recently received this error after performing a 'flashback database' on a primary database that was part of a dataguarded pair. I needed to open the database with resetlogs, but because dataguard was configured for fast-start failover, the broker wouldn't allow it. Normally, I would simply stop the broker momentarily, but when I tried to, this happened:
SQL> alter system set dg_broker_start=false
/
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16654: Fast-Start Failover is enabled
The solution in this case was to disable fast-start failover using dgmgrl, stop the broker, open the database resetlogs, and then re-enable fast-start failover afterwards:
oracle@bloo$ dgmgrl /
DGMGRL for Linux: Version 10.2.0.2.0 - Production
Copyright (c) 2000, 2005, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
Connected.
DGMGRL> disable fast_start failover
DGMGRL> stop observer
DGMGRL> exit
oracle@bloo$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.2.0 - Production on Sat Apr 21 10:37:59 2007
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> alter system set dg_broker_start=false;
System altered.
SQL> alter database open resetlogs;
Database opened.
SQL> alter system set dg_broker_start=true;
System altered.
SQL> exit
oracle@bloo$ dgmgrl /
Connected.
DGMGRL> enable fast_start failover
DGMGRL> start observer
For more useful dataguard commands, try here.
|
