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...


ORA-01244: unnamed datafile(s) added to controlfile by media
recovery



ORA-01244: unnamed datafile(s) added to controlfile by media recovery..

Answer / guest

Cause: Media recovery with a backup controlfile or a
controlfile that was rebuilt, encountered the creation of a
datafile that was not in the controlfile. An entry has been
added to the controlfile for the new datafiles, but with the
file name UNNAMEDnnnn, where nnnn is the file number.
Attached errors describe the file names that were originally
used to create the files.

Action: Rename the files to valid file names and resume
recovery. If necessary the command ALTER DATABASE CREATE
DATAFILE may be used to create a file suitable for recovery
and do the rename. If the file is not going to be recovered
then take it offline with the FOR DROP option.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14076: submitted alter index partition/subpartition operation is not valid for local partitioned index

2 Answers  


ORA-30365: left relation in the JOIN KEY clause cannot be same as right

1 Answers  


KUP-01008: the bad identifier was: string

1 Answers  


ORA-36710: (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.

1 Answers  


ORA-04065: not executed, altered or dropped string

1 Answers  


ORA-12469: no user levels found for user string and policy string

1 Answers  


ORA-15059: invalid device type for ASM disk

1 Answers  


RMAN-06903: backup of datafile string was cancelled

1 Answers  


LPX-00230: invalid character ~1u (~2x) found in a Name or Nmtoken

1 Answers  


CLSR-00003: ORACLE_HOME environment variable not set

1 Answers  


ORA-06253: NETNTT: cannot read arguments from address file

1 Answers  


ORA-16121: applying transaction with commit SCN string

1 Answers  


Categories