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 : 16-08-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-39124 : dump file name "string" contains an invalid substitution variable
  • ora-00215 : must be at least one control file
  • ora-37121 : AW Spreadsheet invalidated
  • ora-38706 : Cannot turn on FLASHBACK DATABASE logging.
  • ora-15176 : file 'string' already has an alias associated with it
  • ora-24507 : invalid combination of character set ids
  • ora-02356 : The database is out of space. The load cannot continue
  • ora-13441 : GeoRaster metadata SRS error
  • ora-29839 : failed to validate implementation type
  • ora-33308 : (DBVALID04) SEVERE ERROR: Record number used but not allocated
  • ora-25138 : %s initialization parameter has been made obsolete
  • ora-12657 : No algorithms installed
  • ora-12708 : error while loading create database NLS parameter string
  • ora-28656 : incomplete attribute specification
  • ora-16051 : parameter string contains an invalid delay time
  • ora-31033 : Requested number of XML children string exceeds maximum string
  • ora-16769 : the physical standby database is open read-only
  • ora-01569 : data file too small for system dictionary tables
  • ora-13211 : failed to tessellate the window object
  • ora-02301 : maximum number of OIDGENERATORS is 255
  • ora-25014 : cannot change the value of a PARENT reference variable
  • ora-12510 : TNS:database temporarily lacks resources to handle the request
  • ora-16151 : Managed Standby Recovery not available
  • ora-12018 : following error encountered during code generation for "string"."string"
  • ora-13213 : failed to generate spatial index for window object
  • ora-29309 : export dump file was generated by different version of DBMS_PITR package
  • ora-07400 : slemtr: translated name for the message file is too long.
  • ora-14629 : cannot drop the only subpartition of a partition
  • ora-22140 : given size [string] must be in the range of 0 to [string]
  • ora-30687 : session terminated by debugger
  • 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.