Re: Datafile recovery

Oracle wrote:
>
> Creating control file again with reuse option may solve the problem. But
> I am not sure about it.
>
> Sudheer
> --

Hello,

if you do not have the redo logs from your last backup on then you're a looser.
Oracle stores tho log switch number in the datafiles, redo logs and control files.
Giving old database files to oracle means : There's a mismatch of this sequence number in the files meaning media recovery needed. If you do not have the redos with that sequencenumber ... :-((( But if you are having the conmtrolfiles with that sequence you can use those files again - but the data only contents the data from the backup. :-)

doing a backup of oracle means :
shutdown the database, do a complete backup (include control files), startup the database in archive log mode. Then you are save.

Detlev

-- 
Detlev Goebel

mailto:detlev.goebel_at_gzs.de
---------------------------