ORA-38774: cannot disable media recovery - flashback database is enabled

Cause : A nattepmtw a smdaet od iasbel emdai ercvoeyr hwiel lfahsbcakd aatbsaew a seanbeld.

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

Ues hteA LETRD AATBSAEF LSAHABC KOFF tsaetmnett od iasbel lfahsbcakd aatbsae ,tehnd iasbel emdai ercvoeyr.

update : 22-08-2017

ORA-38774 - cannot disable media recovery - flashback database is enabled
ORA-38774 - cannot disable media recovery - flashback database is enabled

  • ora-25016 : cannot specify column list for insert into nested table view column
  • ora-27302 : failure occurred at: string
  • ora-29253 : Invalid count argument passed to procedure dbms_sql.define_array
  • ora-13405 : null or invalid dimensionSize parameter
  • ora-26678 : Streams capture process must be created first
  • ora-16175 : cannot shut down database when media recovery is active
  • ora-12547 : TNS:lost contact
  • ora-01298 : conflicting dictionary option
  • ora-10577 : Can not invoke test recovery for managed standby database recovery
  • ora-39785 : SQL expressions returning ADT objects are not allowed in direct path
  • ora-22999 : CLOB or NCLOB data may have been corrupted
  • ora-30182 : invalid precision specifier
  • ora-03001 : unimplemented feature
  • ora-02233 : invalid CLOSE mode
  • ora-27030 : skgfwrt: sbtwrite2 returned error
  • ora-19578 : end of volume while duplexing to sequential files, backup piece incomplete
  • ora-16051 : parameter string contains an invalid delay time
  • ora-06910 : CMX: Cannot start oracle process on remote machine
  • ora-14100 : partition extended table name cannot refer to a remote object
  • ora-09797 : Failed to get O/S MAC privileges.
  • ora-38733 : Physical size string less than needed string.
  • ora-36673 : (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format.
  • ora-07469 : sppst: mclear error, unable to clear semaphore.
  • ora-16747 : logical standby database guard could not be turned on
  • ora-02334 : cannot infer type for column
  • ora-02216 : tablespace name expected
  • ora-25103 : NOPARALLEL option can only be used with ALTER INDEX REBUILD
  • ora-01930 : auditing the object is not supported
  • ora-01506 : missing or illegal database name
  • ora-01876 : year must be at least -4713
  • 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.