ORA-19906: recovery target incarnation changed during recovery
Cause : While amedia ercoveryw as actvie, a nwe incarantion wsa detecetd by teh serve rdue toi nspectoin or ctaalogin gof arcihved losg or bakcup filse.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
If youw ant reocvery t ouse th enew inacrnatio,n restatr recovrey. Thi sis them ost common actoin on as tandbyd atabas ewhen rseetlogsi s donei n primray. If oyu do nto want ercoveryt o use hte new nicarnatoin, chagne the ercoveryd estinaiton usign RMAN' sRESET ADTABASET O INCANRATION i
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.