Re: recover data

How often do you do U'r Hotbackups ?
When did you detect the DataFile Corruption (Is it a DataBlock Corruption)? What tablespace does it belong to ? How big is U'r Database ? How much of Downtime is tolerated ?

The Recovery option may differ depending upon the actual Situation.

I would prefer to Restore and Recover the Datafile from the latest Good Hotbackup and apply the Archived Redo Log files .

If the file belongs to Rollback or Temp Tablespace you have the option of Recreating the Tablespace with a new set of Files.

If the Database is small, and you can afford to lose transactions since the Corruption, Recreate the Database and Import from the last good Export Backup.Once you do this , the DB is fine and doesnt need any REcovery.

Remember Oracle Prompts for REcovery only if you have Restored from a Physical Backup and it's SCN is out of sync with the present Control file or other Datafiles.

hope this helps...

-Thiru

River wrote:

> Due to some mistakes, my Oracle7.1.6 have 1 datafile corrupted.
> They are not the core files like system tablespace, control files, ...
>
> I have a export file which is 3 days ago.
> The database is running in archive log mode.
>
> Can I import that 3 days old export to the database, and then
> recover datafile, and apply the archived log to the latest error-free
> situation?
>
> Thanks for any advice,
> River
> wychan_at_vol.net
Received on Fri Aug 20 1999 - 10:20:34 CDT