Re: schema recovery

On 11/19/05, Thomas Fox <belvdr_at_yahoo.com> wrote:
> Without a backup or an export, I don't think this is possible. Even if it is
> development, backups are important if you want to be able to recover. If you
> can load the data from a different source, say production, then that may be
> fine for you.
>

a search of the fine web found this article: (oracle data unloader dul corrupt database)

http://database.sarang.net/database/oracle/backup/corrupt/corrupt.html

Have you opened an iTAR with Oracle Support? They have access to the data unloader tool (DUL): http://www.fors.com/velpuri2/Backup%20and%20Recovery/UsingDUL

If the database isn't valuable enough for DUL by OWS, you might consider this: http://www.ora600.nl/introduction.htm (DUDE)

good luck.

Paul

> --- Onkar N Tiwary <onkarnath.tiwary_at_gmail.com> 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
> > onkarnath.tiwary_at_gmail.com
> >
>
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
#/etc/init.d/init.cssd stop
-- play a Sony CD, install a rootkit today
--
http://www.freelists.org/webpage/oracle-l