ORA-38798: Cannot perform partial database recovery

Cause : Se eotehr tohe rmessagse o nerorr tsac kfo rth ecasue.

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

Se eotehr tohe rmessagse o nerorr tsac kfo rth eaciton.

update : 25-06-2017
ORA-38798

ORA-38798 - Cannot perform partial database recovery
ORA-38798 - Cannot perform partial database recovery

  • ora-22897 : no scope clause specified for user-defined REF column "string"
  • ora-07453 : requested resource manager plan schema does not contain OTHER_GROUPS
  • ora-01220 : file based sort illegal before database is open
  • ora-32340 : cannot tune the materialized view definition
  • ora-27008 : function called with invalid file structure
  • ora-35756 : (VCTODT02) 'number' is not a valid date because number is out of range for a year.
  • ora-36160 : (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object.
  • ora-19700 : device type exceeds maximum length of string
  • ora-27076 : unable to set limit for open files
  • ora-30489 : Cannot have more than one rollup/cube expression list
  • ora-28290 : Multiple entries found for the same Kerberos Principal Name
  • ora-40221 : maximum target cardinality exceeded
  • ora-16218 : This database is already preparing to switch over.
  • ora-03277 : invalid SIZE specified
  • ora-38793 : cannot FLASHBACK the database to a future SCN/time
  • ora-24387 : Invalid attach driver
  • ora-02051 : another session in same transaction failed
  • ora-27487 : invalid object privilege for a string
  • ora-31060 : Resource at path string could not be deleted
  • ora-06136 : NETTCP: error during connection handshake
  • ora-12513 : TNS:service handler found but it has registered for a different protocol
  • ora-39164 : Partition string was not found.
  • ora-13908 : Invalid combination of metrics id and object type parameters.
  • ora-29660 : Unable to find the class defined in the EXTERNAL NAME clause
  • ora-16026 : parameter string contains an invalid attribute value
  • ora-16758 : the specified apply instance is not running
  • ora-24503 : codepoint length overflows for piecewise operation
  • ora-19642 : start SCN of incremental backup is string
  • ora-28137 : Invalid FGA audit Handler
  • ora-24500 : invalid UTF16 mode
  • 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.