Re: Help needed urgently, Oracle crashed

Well, #1 without a valid controlfile the database won't mount.

You can use the create controlfile command and try to recreate the controlfile specifying all the datafiles in the database. Check the trace directory to see if the old DBA had ever dumped the controlfile to trace.

If you get that created and mount the DB, then you may have a chance at recovery with all the archivelogs if they are still available.

Recovery is tricky sometimes and real tricky if you don't have all the pieces.

Once mounted and archivelogs are in the archive log directory then determine how you want to recover.

alter database recover until time using backup controlfile 'time'; alter database recover until change change# using backup controlfile; alter database recover until cancel using backup controlfile;

When recovery is complete

alter database open resetlogs;

If the database opens, do a full export, rebuild the database and import the data back in.

Good luck, your going to need it.
Matt Arrocha marrocha_at_belsouth.net

Dr. J. Wang <NO_SPAM.jizwang_at_cc.umanitoba.ca> wrote in article <5u40g7$7k7$1_at_postern.mbnet.mb.ca>...
>
> Hi all, on my first day being a DBA, our oracel server machine (Oracle
> 7.3.2.1, on a Unixware 2.1) ran out of disk space. After some looking
 around,
> we found that previous DBA set 'auto archive log' to true and those
 archieved
> log file eat up 760MB disk space in 4 months period. So our Unix guy came
 over
> and removed files. He accidently removed ALL redo log files AND control
 files,
> only left datafiles alone. and then Oracle refused to start. I have been
 an
> Oracle application developer for a while and have not been trained as a
 DBA.
> By consulting a dozen of oracle manuals, I managed to bring Oracle to
 life by
> recreating new control files. However, I do not know how to recover our
 data
> from those left-over datafiles on the machine (we have backup tapes. but
> before doing tape backup, we like to try those datafiles on the machine)
>
> here what I did:
> 1. startup oracle, without nomount
> 2. tried to recover datafiles, tablespaces, as well as database
 itself,
> none of them was completed because of Oracle asking for relogs or control
 

> files, which we did not have.
> 3. I took all datafiles offline
> 4. I did try to specify ALL datafiles in creating new control
> files. Oracle complained that datafile needed media recovery. However,
 as I
> mentioned in 2). All media recovery failed. So that I was forced to
 create
> control files ONLY with system datafiles. The process went through and
 Oracle
> is up without any data.
> 5. Oracle shows all old tabespaces are online. However, when I
 queried
> some tables, Oracle shows that they do not exist. Which does make sense
 since
> Oracle still using old data dictionary.
>
>
> here what I want to do:
> 1. Recover all datafiles on the machine. Without control files and
 redo
> logs, how can I do it? (or can I?)
> 2. I did drop a test tablespace and receate a new one. However, I do
 not
> know how to associate an existing datafile wiht a tablespace so that I
 can use
> objects (tables, indexes, SPs, triggers) stored in that datafile (or can
 I ?)
>
> Any suggestions/comments are greatly appreciated.
>
> Thanks
> Jizhong
>
>
> -----------------------------------------------------------------------
> Jizhong Wang, Ph.D. jizwang_at_cc.umanitoba.ca
> Systems Analyst, Information Services
> St. Boniface General Hospital Tel. 204-235-3326
> Winnipeg, Canada Fax. 204-237-6229
> ---------------- ------------------------------------------------------
>
Received on Thu Sep 11 1997 - 00:00:00 CDT