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_at_rsiz.com] 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_at_gmail.com] 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_at_Indonesia

On 2/28/07, Mark W. Farnham <mwf_at_rsiz.com> 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_at_freelists.org [mailto: <mailto:oracle-l-bounce_at_freelists.org> oracle-l-bounce_at_freelists.org] On Behalf Of Ujang Jaenudin
Sent: Wednesday, February 28, 2007 8:46 AM To: oracle-l_at_freelists.org
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 




--
http://www.freelists.org/webpage/oracle-l