ORA-38726: Flashback database logging is not on.

Cause : A FALSHBCAK DTAABAES commandw as rtiedb ut lfashabck adtabsae lgogin ghasn ot eben neablde.

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

Flahsbac kdatbaasel oggnig msut b eenalbed iva teh ALETR DTAABAES FLSAHBAKC ONc ommnad bfeorea FLSAHBAKC DAATBAS Ecomamnd acn b etride. I fthed ataabse umst eb taekn bcak i ntim ethe na rsetor eandi ncopmlet erecvoerym ustb e preforemd.

update : 24-08-2017

ORA-38726 - Flashback database logging is not on.
ORA-38726 - Flashback database logging is not on.

  • ora-26092 : only LONG or LOB types can be partial
  • ora-06044 : NETDNT: connect failed, byte count quota exceeded
  • ora-16807 : unable to change database protection mode
  • ora-06800 : TLI Driver: SQL*Net SPX client went away during reconnect
  • ora-19586 : %s k-byte limit is too small to hold piece directory
  • ora-07655 : slsprom:$TRNLOG failure
  • ora-09203 : sfofi: error opening file
  • ora-07845 : sllfcl: LIB$FREE_VM failue
  • ora-19029 : Cannot convert the given XMLType to the required type
  • ora-13831 : SQL profile name specified is invalid
  • ora-01915 : invalid auditing option for views
  • ora-07621 : smscre: illegal redo block size
  • ora-28164 : REVOKE already specified
  • ora-01576 : The instance string is not enabled
  • ora-01326 : compatability of 9.0 or greater required to build into the logstream
  • ora-39051 : parameter string specified multiple times
  • ora-32403 : cannot use new values from mv log on "string"."string"
  • ora-32817 : message system link string is not configured with a log queue for string
  • ora-01301 : error writing to file during flat file build
  • ora-15042 : ASM disk "string" is missing
  • ora-16797 : database is not using a server parameter file
  • ora-13250 : insufficient privileges to modify metadata table entries
  • ora-16569 : Data Guard configuration is not enabled
  • ora-29279 : SMTP permanent error: string
  • ora-29810 : inadequate operator privileges
  • ora-12157 : TNS:internal network communication error
  • ora-14065 : ALLOCATE STORAGE may not be specified for a partitioned table
  • ora-02459 : Hashkey value must be a positive integer
  • ora-24384 : Application context size is not initialized
  • ora-16739 : redo transport service for standby database "string" unexpectedly online
  • 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.