Re: Lost oracle database but have the datafiles

It's like Howard says -

- what did you loose ?
- do you still have system, redologs and datafiles ?
- you're only backup is an export dump ? or is the DB running in archivelog

if you just lost your temp, rollback, indexes -> no biggy if you lost your system tablespace -> screwed

so more info is required - but the sentence 'I lost a hard drive and everything went to heck thereafter' is for me a big sign that the 'recreate DB, import one-week-old-dump' is the only recovery scenario here ...

"Kev" <java2e_at_yahoo.com> wrote in message news:etpu2u444abbne0l1su6mp0336cea8qefi_at_4ax.com...
> Ok, so what other suggestions do you have???
>
> I am not a deep pocket person and cant afford to hire oracle to come
> out.
>
> IF there is no other thing I can do I jsut want to know.
>
> Thanks.
>
>
> On Sun, 30 Dec 2001 18:15:11 GMT, "koert54" <koert54_at_nospam.com>
> wrote:
>
> >Dude - don't tell me your backup strategy is an export once a week ???
> >
> >I would suggest using that export to rebuild your DB - if this isn't
> >exceptable then you should contact Oracle support and
> >be prepared to spend a *lot* of money ....
> >
> >I'm still writing on jDUL (sourceforge) - and making progress :-)
> >
> >"Kev" <java2e_at_yahoo.com> wrote in message
> >news:92lu2usilvnj8sni448lnr3sruit0sgkhk_at_4ax.com...
> >> How can I get the data out of the datafiles back into the another
> >> oracle server??
> >>
> >> I am really sweating it here. Hte last exp I have is a week old. Any
> >> ideas??
> >>
> >> Soneone anyone?
> >>
> >> Am I screwed or can I pull the data back out? What happened was I
> >> lost a hard drive and everything went to heck thereafter.
> >>
> >> Please someone give me any advice you can.
> >>
> >> Thanks,
> >>
> >> Kev
> >
>
Received on Sun Dec 30 2001 - 13:41:53 CST