Re: schema recovery

If this is an academic question, the answer is basically:

   You sould be able to get at least something back, the amount you get depending on how much effort you want to invest. If you want maximize data recovery, you'll probably need to involve Oracle Support.

   But *sane* people backup their databases. If you have a backup (and operate in archivelog mode) you can recover *everything* in this scenario. With relatively litle trouble or stress.

   Backup your database. If you choose *not* to backup the database, then you have effectively made a conscious choice not to recover it in the event of problems...

Onkar N Tiwary wrote:

> Hi,
>
> Today I had been asked one question : Scenario is : My DB is in
> noarchive log mode, no backup available, one of the datafile got
> corrupted say users01.dbf containing one schema TEST. Now can I
> recover the objects of the schema from that corrupted dbf file? If yes
> then how????
>
> Note : Partial/full data loss is acceptable as its a development db
> but all the objects are required!!!
>
> --
> Thanks & Regards,
> T. Onkar Nath
> OneAPPS Enterprise Technology Pvt. Ltd.
> to_onkar_at_yahoo.com <mailto:to_onkar_at_yahoo.com>
> onkarnath.tiwary_at_gmail.com <mailto:onkarnath.tiwary_at_gmail.com>
>

--
http://www.freelists.org/webpage/oracle-l