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