FW: disk crash no mirror, NOARCHILEG mode, and NO BACKUP, some datafiles & undo missing

Inadvertantly off list. Mladen's response was far superior to mine, anyway.

 

mwf

 

  _____  

From: Mark W. Farnham [mailto:mwf@xxxxxxxx] 
Sent: Wednesday, February 28, 2007 10:07 AM
To: 'Ujang Jaenudin'
Subject: RE: disk crash no mirror, NOARCHILEG mode, and NO BACKUP, some
datafiles & undo missing

 

Were they storing scripts in the database? Do you know which tablespace? If
that is all you want, focus on just system, sysaux (if required), and the
tablespace(s) that held the scripts.

 

There might be some value to just system (sysaux) if you can get at
sys.source$ you could dump out the lines of the any stored procedures and
packages.

 

If that fails, then you might still possibly get text fragments with bbed or
strings.

 

On the other hand, if the scripts were not in the database, that is not
going to help.

 

  _____  

From: Ujang Jaenudin [mailto:ujang.jaenudin@xxxxxxxxx] 
Sent: Wednesday, February 28, 2007 9:58 AM
To: Mark W. Farnham
Subject: Re: disk crash no mirror, NOARCHILEG mode, and NO BACKUP, some
datafiles & undo missing

 

Mark,

control file is safe, as well as redolog.
database is 10.2.0.1 on linux
this database is development warehouse db.
my aim only to get all the scripts which developer created. sadly they
haven't  create backup of their scripts yet. 

thanks
ujang@Indonesia

On 2/28/07, Mark W. Farnham <mwf@xxxxxxxx> wrote:

your chances are slim to none. if the online redo logs survived you might
have a chance to get back something. make copies of the online redo logs to
somewhere safe before you try anything if you still have them.

likewise the controlfile, if it survives.

 

is system one of the surviving files? I guess before I tried anything else
I'd get a copy of system, control, and the online redo to see if I could
even recover system with its undo activated and the other tablespaces marked
off line. You might be at a release where you have to have sysaux as well,
but we can only wonder about that.

 

If you get that far you might be able to resurrect some data both of certain
and questionable vintage by using one of the methods of declaring the undo
corrupt. That all varies by release, can probably be found in various
archives on line. Maybe someone can direct you to the possibilities for a
particular release if you clue us in on the details.

 

I'm mustering all the sympathy I can to get even this far in making
suggestions. If the data is really valuable (contrary to the state of
protection), you might be able to hire someone to scrub out as much as
possible, or if someone has a problem solving addiction and is bored at the
moment something might be possible, but don't get your hopes up.

 

Do you have a list of all the components of the databases against which to
compare what survives? That is sort of a minimal starting point. If a
control file survived that might help some.

 

good luck (you'll need it),

 

mwf

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:
<mailto:oracle-l-bounce@xxxxxxxxxxxxx>  oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Ujang Jaenudin
Sent: Wednesday, February 28, 2007 8:46 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: disk crash no mirror, NOARCHILEG mode, and NO BACKUP, some
datafiles & undo missing

 

folks,

and luckily user was SHUTDOWN ABORT database after make datafiles OFFLINE,
so when startup, it always try to find the missing undo file.....
this is worst case, please help me on this situation......


regards
ujang





-- 
regards
ujang 

Other related posts:

  • » FW: disk crash no mirror, NOARCHILEG mode, and NO BACKUP, some datafiles & undo missing