ORA-38860: cannot FLASHBACK DATABASE during instantiation of a logical standby

Cause : The command wa snot pemritted ebcause hte contorlfile nidicate sthe daatbase wsa in th eproces sof becmoing a olgical tsandby adtabaseb ut thec ontrolifle conevrsion ahd not ocmplete.d

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

If in hte procses of cerating alogica lstandb ydatabaes, perfrom the ermainin ginstanitation rpocedurse to copmletion .If thi sflashbcak opertaion followed aD ata Gurad failrue, perimt the rerant Dtaa Guar doperatoin to scucessfully compelte. Onec the isntantiaiton is ocmplete ,reissu ethe flsahback poeratio.n

update : 29-04-2017
ORA-38860

ORA-38860 - cannot FLASHBACK DATABASE during instantiation of a logical standby
ORA-38860 - cannot FLASHBACK DATABASE during instantiation of a logical standby

  • ora-16812 : log apply service not running on apply instance recorded by the broker
  • ora-01986 : OPTIMIZER_GOAL is obsolete
  • ora-12431 : invalid audit action
  • ora-28000 : the account is locked
  • ora-39316 : call to DBMS_SCHEMA_COPY.CLEAN_UP is not legal
  • ora-01938 : IDENTIFIED BY must be specified for CREATE USER
  • ora-14627 : Invalid operation was specified on a GLOBAL partitioned index
  • ora-08270 : sksachk: Illegal archival control string
  • ora-19264 : XQ0044 - invalid namespace in attribute constructors
  • ora-06705 : TLI Driver: remote node is unknown
  • ora-25450 : error string during evaluation of rule set string.string
  • ora-00340 : IO error processing online log string of thread string
  • ora-19574 : output filename must be specified
  • ora-19572 : cannot process file string, file is being being resized
  • ora-09934 : Link of current password file to old failed.
  • ora-14098 : index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-02187 : invalid quota specification
  • ora-28293 : No matched Kerberos Principal found in any user entry
  • ora-25305 : enqueue failed, expiration must be zero for queue string.string
  • ora-06755 : TLI Driver: cannot close transport endpoint
  • ora-12425 : cannot apply policies or set authorizations for system schemas
  • ora-01142 : cannot end online backup - none of the files are in backup
  • ora-39064 : unable to write to the log file
  • ora-24324 : service handle not initialized
  • ora-19331 : Last argument to CREATE_DBURI operator must be a column
  • ora-25294 : Cannot propagate user buffered messages to a database with version lower than 10.2
  • ora-04010 : the number of values to CACHE must be greater than 1
  • ora-27152 : attempt to post process failed
  • ora-38738 : Flashback log file is not current copy.
  • ora-28038 : disallow O2LOGON
  • 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.