Re: Weird DB recovery.. help needed :)

then just restoring the initSID.ora
> file, and everything should be fine. ...
No, regrettably this is NOT true. First of all you would have to edit your initSID.ora to reflect the new control file locations. However, the original file locations are in your control file: the database won't start. If you would have a controlfile backupped to trace then you could take that one, edit it,
issue a startup nomount and run the script from the create controlfile statement. Works like a breeze, 5secs and that's it. That's why you always need to make an alter database backup controlfile to trace after any changes in physical layout. If you don't have a control file backupped, the only thing I can see is performing a tric: alias all the files in the directories they should have been going to, to the locations where they are. Start the database, alter database backup controlfile etc. as above.

Hth,

Sybrand Bakker, Oracle DBA

NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message news:37aafa4d.6280299_at_news.earthlink.net...
> Hi folks,
>
> I posted this yesterday, but there is some confusion.
> 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?
>
> Thanx
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
Received on Fri Aug 06 1999 - 15:17:56 CDT