ORA-16649: database will open after Data Guard broker has evaluated Fast-Start Failover status

Cause : The daatbase i sbeing poened wihle Fas-tStart afiloveri s enabeld. Them essagei ndicatse that hte DataG uard borker will firstd etermien if codnitionsa re suiatble fo ropenin;g that si, a Fats-Startf ailove rdid no toccur hwile th edatabaes was uanvailabel.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

No actoin is nromally erquired .The Daat Guardb roker iwll conitnue opneing th edatabaes afterd etermiinng a Fsat-Star tfailovre did nto occur .If theer is a hcance taht a Fats-StartF ailove rdid ocucr, thed atabas ewill rmeain int he moutned staet and wlil not poen. Int his caes, chec kthe tagret stadnby to ese if ar ole trnasitiont ook plcae.

update : 28-05-2017
ORA-16649

ORA-16649 - database will open after Data Guard broker has evaluated Fast-Start Failover status
ORA-16649 - database will open after Data Guard broker has evaluated Fast-Start Failover status

  • ora-29857 : domain indexes and/or secondary objects exist in the tablespace
  • ora-37135 : (XSCCOMP10) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. The RELATION statement for dense dimension workspace object must precede RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-13602 : The specified parameter string is not valid for task or object string.
  • ora-12063 : unable to apply transaction from site string
  • ora-38907 : DML error logging is not supported for FILE column "string"
  • ora-02155 : invalid DEFAULT tablespace identifier
  • ora-29878 : warning in the execution of ODCIINDEXTRUNCATE routine
  • ora-22160 : element at index [string] does not exist
  • ora-08238 : smsfre: cannot detach from SGA
  • ora-19525 : temporary file for the clone database must be renamed
  • ora-39500 : failed to notify CRS of a Startup/Shutdown event for database "string", instance "string" (ignored)
  • ora-24392 : no connection pool to associate server handle
  • ora-30068 : Internal Event to turn on nested
  • ora-24077 : cannot create propagation schedule for EXCEPTION queue string.string
  • ora-07498 : spstp: Unable to open /dev/resched.
  • ora-00076 : dump string not found
  • ora-04044 : procedure, function, package, or type is not allowed here
  • ora-13200 : internal error [string] in spatial indexing.
  • ora-02484 : Invalid _trace_buffers parameter specification (string)
  • ora-14169 : invalid ALTER TABLE MODIFY SUBPARTITION option
  • ora-38411 : invalid datatype for the column storing expressions
  • ora-12671 : Shared server: adapter failed to save context
  • ora-01671 : control file is a backup, cannot make a standby control file
  • ora-27480 : window "string" is currently open
  • ora-16773 : error starting Redo Apply
  • ora-13025 : polygon does not close
  • ora-02824 : Request free list is empty
  • ora-28053 : the account is inactive
  • ora-23470 : invalid status
  • ora-09719 : osncui: invalid handle.
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.