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 : 24-04-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-23610 : internal dbms_streams_tablespaces error: [string] [string] [string] [string]
  • ora-07200 : slsid: oracle_sid not set.
  • ora-29819 : cannot associate default values with columns
  • ora-02093 : TRANSACTIONS_PER_ROLLBACK_SEGMENT(string) more than maximum possible(string)
  • ora-29932 : the type being dropped is a statistics type
  • ora-07469 : sppst: mclear error, unable to clear semaphore.
  • ora-28363 : buffer provided not large enough for output
  • ora-25020 : renaming system triggers is not allowed
  • ora-29760 : instance_number parameter not specified
  • ora-36650 : (XSDUNION10) Concat dimension workspace object cannot be changed to UNIQUE. Leaves workspace object and workspace object share the value number.
  • ora-24817 : Unable to allocate the given chunk for current lob operation
  • ora-24323 : value not allowed
  • ora-01609 : log string is the current log for thread string - cannot drop members
  • ora-32815 : message system link string is referenced by a foreign queue
  • ora-10662 : Segment has long columns
  • ora-07480 : snchmod: cannot change permissions on ?/dbs/sgalm.dbf.
  • ora-07281 : slsget: times error, unable to get cpu time.
  • ora-16242 : Processing logfile (thread# string, sequence# string)
  • ora-31619 : invalid dump file "string"
  • ora-37152 : MDX query error: (string)
  • ora-24019 : identifier for string too long, should not be greater than string characters
  • ora-14024 : number of partitions of LOCAL index must equal that of the underlying table
  • ora-00312 : online log string thread string: 'string'
  • ora-07511 : sscggtl: $enq unexpected return for master termination lock
  • ora-12515 : TNS:listener could not find a handler for this presentation
  • ora-33452 : (ESDREAD06) Discarding compiled code for workspace object because number is now dimensioned by workspace object. It was dimensioned by workspace object when the code was compiled.
  • ora-24100 : error in ktz testing layer
  • ora-16042 : user requested cancel immediate of managed recovery operation
  • ora-15001 : diskgroup "string" does not exist or is not mounted
  • ora-38447 : Type required for the embedded ADT attribute "string" is missing
  • 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.