ORA-38781: cannot disable media recovery - have guaranteed restore points

Cause : An attempt was made to disable media recovery while there is at least one guaranteed restore point.

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

Drop all guaranteed restore points and then disable media recovery.

update : 29-06-2017

ORA-38781 - cannot disable media recovery - have guaranteed restore points
ORA-38781 - cannot disable media recovery - have guaranteed restore points

  • ora-01761 : DML operation does not map to a unique table in the join
  • ora-24009 : invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE
  • ora-32585 : duplicate specification of a supplemental log attribute
  • ora-28553 : pass-through SQL: invalid bind-variable position
  • ora-02377 : invalid resource limit
  • ora-25282 : message id. not provided for non-repudiation
  • ora-00025 : failed to allocate string
  • ora-07745 : slemcl: $CLOSE failure
  • ora-02285 : duplicate START WITH specifications
  • ora-07595 : sppid: $GETJPIW failure
  • ora-36258 : (XSAGINFO00) When the AGGMAPINFO function is called, workspace object must be an AGGMAP.
  • ora-12202 : TNS:internal navigation error
  • ora-06401 : NETCMN: invalid driver designator
  • ora-03278 : duplicate ALLOCATE EXTENT option specification
  • ora-15097 : cannot SHUTDOWN ASM instance with connected RDBMS instance
  • ora-01871 : the number of seconds must be less than 60
  • ora-31020 : The operation is not allowed, Reason: string
  • ora-06720 : TLI Driver: SID lookup failure
  • ora-27230 : OS system call failure
  • ora-16957 : SQL Analyze time limit interrupt
  • ora-36404 : (XSSPROP04) Property string cannot be applied to an undimensioned (scalar) TEMPORARY variable.
  • ora-19958 : potential deadlock involving DIAG process
  • ora-12423 : invalid position specified
  • ora-30203 : Cannot open mesage file
  • ora-02450 : Invalid hash option - missing keyword IS
  • ora-29290 : invalid offset specified for seek
  • ora-09812 : Unable to get user clearance from connection
  • ora-06574 : Function string references package state, cannot execute remotely
  • ora-16743 : the status of redo transport service for standby database "string" is unknown
  • ora-36157 : (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.
  • 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.