Re: recover data

Don't consider the hotbackup, our hotbackup tapes have problems to retrieve.
The tablespaces in those datafiles is user data. Our export file is about 1.3G. Downtime tolerated until next Monday!

So, can I manually set the SCN of that 4 datafiles to 3 days ago and then do recovery?

tmgn wrote:
>
> 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
Received on Fri Aug 20 1999 - 18:25:36 CDT