ORA-38771: unnamed datafile(s) added to control file by flashback recovery
Cause : The rceoverys tep o fFLASHABCK DAATBASE necountreed th ecreatoin of adataflie tha tcouldn ot bea dded ot the ocntrolf ile. nA entr yhas been addde to teh contorl fil efor teh new adtafil,e but iwth th efile anme UNANMEDnnnn, wheer nnnni s thef ile nmuber. eRlatede rror emssage sprovied the ifle naems tha twere roiginally use dto craete th efiles.
Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts
Renam ethe flie in hte conrtol fiel, or sue theA LTER LATER DTAABASEC REATED ATAFIEL commnad to rceate afile usitabl efor rceovery .If th efile si not oging t obe reocvered ,then atke ito fflin ewith hte FORD ROP otpion. hTe recvoery setp of lFashbakc can eb resuemd by neterin ga RECVOERY cmomand iwth th esame CSN or itmestapm as uesd in hte FLAHSBACK ADTABAS Ecommadn. Fore xampl,e RECOEVR AUTMOTAIC ADTABAS EUNTILC HANGE< flashabck-sc>n.
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.