Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: system datafile is damaged

Re: system datafile is damaged

From: Samantha Hall <samanthahall_at_qwest.net>
Date: Fri, 07 Sep 2001 10:19:18 -0600
Message-ID: <3B98F386.588A6C60@qwest.net>


One thing to remember about that blank check. You might still be filling in numbers for a large amount and end up still with no data! Getting one of their support guys to use DUL is not 100% guaranteed!

Koert was right, start praying. I hope you are now putting steps in place to have a more robust backup and recovery strategy.

Regards,
Samantha

koert54 wrote:

> IF the data is THAT important then follow this procedure :
> 1. write a blank cheque (or ask your company for one)
> 2. call Oracle support
> 3. ask for a Oracle tech guy on-site and tell'm to bring DUL
> 4. if they hesitate - tell'm you have a blank cheque waiting for them
> 5. find the one guy who knows all your tables by heart (kinda like - pop
> quiz hotshot ... table #3202 has 10 columns and the
> first five records are these ... what is the tablename ??? :-) - most
> probably this will be a senior developer ... or just one of the guys
> who didn't bail out after this incedent ....)
> 6. pray
>
> Have fun,
> Koert
>
> "upendra" <upendrasingh_at_rediffmail.com> wrote in message
> news:b0f6a9f8.0108290546.76a53237_at_posting.google.com...
> > dear groups
> > my system datafile is damaged and i am working in no archive log
> mode
> > back up i have is quite old say 9 months
> > database is mount but not open
> > os is unixware 7.0
> > is there is any chance to recover my important data ?
> > plz tell??
> > upendra
Received on Fri Sep 07 2001 - 11:19:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US