Re: schema recovery
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 19 Nov 2005 12:00:10 -0500
On 11/19/05, Thomas Fox <belvdr@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx
> > onkarnath.tiwary@xxxxxxxxx
> >
>
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
#/etc/init.d/init.cssd stop
-- play a Sony CD, install a rootkit today
--
//www.freelists.org/webpage/oracle-l
Other related posts:
