Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> ERRORS >> Database Errors >> Oracle Errors
  2. Suggest New Category

ORA-38771: unnamed datafile(s) added to controlfile by
flashback recovery

Question Posted / guest

Answer Posted / guest

Cause: The recovery step of FLASHBACK DATABASE encountered
the creation of a datafile that could not be added to the
controlfile. An entry has been added to the controlfile for
the new datafile, but with the file name UNNAMEDnnnn, where
nnnn is the file number. Related error messages provide the
file names that were originally used to create the files.

Action: Rename the file in the controlfile, or use the ALTER
ALTER DATABASE CREATE DATAFILE command to create a file
suitable for recovery. If the file is not going to be
recovered, then take it offline with the FOR DROP option.
The recovery step of Flashback can be resumed by entering a
RECOVERY command with the same SCN or timestamp as used in
the FLASHBACK DATABASE command. For example, RECOVER
AUTOMTAIC DATABASE UNTIL CHANGE <flashback-scn>.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

NZE-28868: Peer certificate chain check failed.

2744

ORA-26094: stream format error: input column overflow

2738

RMAN-05017: no copy of datafile number found to recover

2346

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1562

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2173

ORA-26084: direct path context already finished

1878

IMP-00070: Lob definitions in dump file are inconsistent with database.

1698

IMP-00064: Definition of LOB was truncated by export

6350

ORA-26082: load of overlapping segments on table string.string is not allowed

1716

ORA-26032: index string.string loading aborted after string keys

2055

IMG-02003: 2FF03 - incorrect color histogram feature specification

1652

ORA-26027: unique index string.string partition string initially in unusable state

6701

ORA-26029: index string.string partition string initially in unusable state

2096

ORA-26079: file "string" is not part of table string.string

1895

invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3321