Re: Weird DB recovery.. help needed :)

In article <37aafa4d.6280299_at_news.earthlink.net>, andreyNSPAM_at_bookexchange.net (NetComrade) wrote:

>I did
>rm -r * in my $ORACLE_BASE dir.
>All of my control files, redo, system, datafiles seem to be in place
>on other mounts.
>I was thinking of just installing the software w/o creating the
>database (an installer option), then just restoring the initSID.ora
>file, and everything should be fine.
>
>Any suggestions?

It's worth a try. But you don't mention having a backup of your control file. If it is backed up to trace and udump is somewhere underneath $ORACLE_BASE such as $ORACLE_BASE/admin/SID/udump then you will have to make it work with the control files you have -- or rebuild them manually.

You also didn't mention whether the database was up when you blew away $ORACLE_BASE. If it was, you will probably have to recover it even though you have all the pieces. If it was in noarchivelog mode, or you lost the logs with the rest of $ORACLE_BASE, you may have trouble synching up the files without a way to do point in time recovery.

Paul de Anguera | "You can't write a chord ugly enough to say
Reply to:       | what you want to say sometimes, so you have to
deanguer@       | rely on a giraffe filled with whipped cream."
quidnunc.net    | - Frank Zappa