Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Missing datafiles
Hi,
A database was copied from another one and the controlfile to create it missed out couple of datafiles.
The database now has missing datafiles listed in it.
Also, the fact that some datafiles are missing was not known until a few days when some changes to the
database have taken place.
My question is if its possible to 'restore' the database now? I can see the missing datafiles on disk although
with an older timestamp than the ones that are online.
The database is in NOARCHIVELOG mode. However I checked v$log and found that since database build, no
log switch has happened yet. Does this means shutting the database down and recreating the controlfile
with the missing datafiles can bring the database to a consistent state? Can it use the current redo log for
recovery, if required?
This is rather urgent, although not critical since its not a production environment.
Thank you,
Kanwar
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jun 28 2007 - 16:36:21 CDT
![]() |
![]() |