Re: Weird DB recovery.. help needed :)

I am sort of a newbie at Oracle so I could very likely be wrong... However, since all his datafiles and controlfiles are still untouched in their respective original directories, why couldn't he just restore the init<SID>.ora file?

Carlos.

In article <933970680.20259.0.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postmaster_at_sybrandb.nospam.demon.nl> wrote:
> 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
> >
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 06 1999 - 17:13:45 CDT