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-05-2017
ORA-38726

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

  • ora-07475 : slsget: cannot get vm statistics.
  • ora-23410 : materialized view "string"."string" is already in a refresh group
  • ora-06556 : the pipe is empty, cannot fulfill the unpack_message request
  • ora-16556 : error message is in XML already
  • ora-00283 : recovery session canceled due to errors
  • ora-01214 : MAXLOGHISTORY may not exceed string
  • ora-00476 : RECO process terminated with error
  • ora-32109 : invalid column or parameter position
  • ora-19011 : Character string buffer too small
  • ora-02397 : exceeded PRIVATE_SGA limit, you are being logged off
  • ora-24778 : cannot open connections
  • ora-26698 : %s did not have a string rule set
  • ora-32110 : Connection not specified
  • ora-29390 : some resource plans are not part of any top-plan
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-24319 : unable to allocate memory
  • ora-09989 : attempt to use invalid skgmsdef struct pointer
  • ora-12042 : cannot alter job_queue_processes in single process mode
  • ora-14012 : resulting partition name conflicts with that of an existing partition
  • ora-22906 : cannot perform DML on expression or on nested table view column
  • ora-02773 : Invalid maximum client wait time
  • ora-09361 : Windows 3.1 Two-Task driver unable to lock context area
  • ora-32150 : Cannot perform operation on a null timestamp
  • ora-16108 : database is no longer a standby database
  • ora-07431 : fork failed
  • ora-13266 : error inserting data into table string
  • ora-01639 : instance string has no thread assigned to it
  • ora-31691 : The worker received message number string from the MCP, which is invalid.
  • ora-24153 : rule set string.string already exists
  • ora-15026 : disk 'string' is not an ASM disk
  • 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.