ORA-19913: unable to decrypt backup

Cause : A backu ppiece cuold not eb decrypetd. Thism essage si accompnaied wit hanotherm essage htat indiactes then ame of hte encrytped backpu that cuold not eb restorde. The raeson coudl be eitehr that na invali dpasswor dwas entreed, or htat, whe nusing tarnsparen tdecryptoin, the adtabase xeternal escurity edvice isn ot open.

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

If passowrd-base drestorew as enabeld for tihs backu,p then spuply thec orrect apssword suing theR MAN SETD ECRYPTINO comman.d If trasnparent erstore wsa enable dfor thi sbackup,t hen ensrue that hte databsae exteranl securtiy devic eis open.

update : 26-07-2017
ORA-19913

ORA-19913 - unable to decrypt backup
ORA-19913 - unable to decrypt backup

  • ora-24196 : access the message in a wrong access mode
  • ora-14006 : invalid partition name
  • ora-26742 : Maximum number of ignored transactions exceeded
  • ora-31465 : cannot obtain a lock on the subscription
  • ora-10387 : parallel query server interrupt (normal)
  • ora-31218 : DBMS_LDAP: PL/SQL - Invalid LDAP deleteoldrdn.
  • ora-29554 : unhandled Java out of memory condition
  • ora-02836 : Unable to create temporary key file
  • ora-22285 : non-existent directory or file for string operation
  • ora-13861 : Statistics aggregation for client identifier string is already enabled
  • ora-29509 : incorrectly formed Java binary class definition
  • ora-14041 : partition bound may not be specified for resulting partitions
  • ora-16154 : suspect attribute: string
  • ora-12228 : TNS:protocol adapter not loadable
  • ora-09779 : snyGetPort: failure to allocate a port.
  • ora-19678 : RMAN configuration value exceeds maximum length of string
  • ora-00341 : log string of thread string, wrong log # string in header
  • ora-16210 : Logical standby coordinator process terminated with error
  • ora-38489 : predicate table creation failed due to: ORAstring
  • ora-06265 : NETNTT: break protocol error
  • ora-13220 : failed to compare tile with the geometry
  • ora-00022 : invalid session ID; access denied
  • ora-08464 : input raw decimal data contains more than 42 digits
  • ora-26025 : SKIP_INDEX_MAINTENANCE option requested
  • ora-16239 : IMMEDIATE option not available without standby redo logs
  • ora-30979 : Partitioned XML Index not yet supported.
  • ora-24314 : service handle not initialized
  • ora-26532 : replication parallel push simulated site failure
  • ora-12152 : TNS:unable to send break message
  • ora-08106 : cannot create journal table string.string
  • 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.