Re: Weird DB recovery.. help needed :)

As far as I understood his situation he moved everything: datafiles, redolog files etc.
The location of the files are in the control files. Restoring the init<SID>.ora and opening the database would result in errors , as the files have been moved.
On second thought (which I emailed to him) he should be able to issue a startup mount followed by alter database rename file 'filea' to 'fileb'.
This command renames files in the control files only, it doesn't execute the OS rename.
This is exactly what he needs.
If everything was in the original location he could just reopen and accept any loss by potentially not running in archivelog. Hope to have clarified your concerns.

Best regards,

Sybrand Bakker, Oracle DBA

<cpereyra_at_ix.netcom.com> wrote in message news:7ofmmf$tdd$1_at_nnrp1.deja.com...
> 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 Sat Aug 07 1999 - 01:16:01 CDT