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.

update : 21-09-2017
ORA-38771

ORA-38771 - unnamed datafile(s) added to control file by flashback recovery
ORA-38771 - unnamed datafile(s) added to control file by flashback recovery

  • ora-06580 : Hash Join ran out of memory while keeping large rows in memory
  • ora-34487 : (MXMAINT08) You cannot string values of non-unique concat dimension workspace object.
  • ora-00295 : datafile/tempfile number string is invalid, must be between 1 and string
  • ora-29843 : indextype should support atleast one operator
  • ora-22851 : invalid CHUNK LOB storage option value
  • ora-07230 : slemcr: fopen error, unable to open error file.
  • ora-13457 : GeoRaster cell data error
  • ora-01250 : Error string occurred during termination of file header access
  • ora-29339 : tablespace block size string does not match configured block sizes
  • ora-08308 : sllfop: Cannot open file
  • ora-16028 : new string causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires
  • ora-19642 : start SCN of incremental backup is string
  • ora-29505 : AS keyword is invalid in CREATE JAVA CLASS or RESOURCE
  • ora-13124 : unable to determine column id for column string
  • ora-26671 : maximum number of STREAMS processes exceeded
  • ora-01230 : cannot make read only - file string is offline
  • ora-02192 : PCTINCREASE not allowed for rollback segment storage clauses
  • ora-00207 : control files are not for the same database
  • ora-02361 : error while attempting to allocate number bytes of memory
  • ora-01165 : MAXDATAFILES may not exceed string
  • ora-01253 : cannot start online backup - file string in recovery manager backup
  • ora-07510 : scgbrm: $getlki unexpected return on lockid string
  • ora-14316 : table is not partitioned by List method
  • ora-32036 : unsupported case for inlining of query name in WITH clause
  • ora-09300 : osncon: unable to connect, DPMI not available
  • ora-12640 : Authentication adapter initialization failed
  • ora-06129 : NETTCP: unable to transfer socket ownership to ORASRV
  • ora-25237 : navigation option used out of sequence
  • ora-13004 : the specified buffer size is invalid
  • ora-29504 : invalid or missing schema name
  • 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.