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.
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.