I hope you weren't doing that while driving home with your cell phone
without a car-kit :-)))
I talked I guy through a recovery in that situation - I still haven't bought
a carkit though :-)
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:3c0bc62e$0$19078$afc38c87_at_news.optusnet.com.au...
> It is not even necessary to have a trace copy of the control file. All
the
> trace file is, is a piece of SQL. It is perfectly possible, with adequate
> database documentation to hand, to simply issue the 'create controlfile'
> command as a regular piece of SQL in SQL Plus or Server Manager. I
wouldn't
> *advise* it, but it can be done!
>
> I once talked someone through doing just that over the telephone. The
call
> took slightly over 2 and half hours, and I count it one of my greatest
> triumphs!!
>
> Regards
> HJR
> --
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Simon Hume" <simon_at_publishers-market.com> wrote in message
> news:J0JO7.1$vI3.72_at_news.ecrc.de...
> > Thanks to everyone who replied, which solved my problem. I want to find
> > the absolute minimum required to restore a database. Seems to me that
> many
> > people and much that is written (including Oracle manuals) are vague
about
> > this. Say I don't have current redo logs, OR current controlfile, I CAN
> > recover right up until my last archived log even if I have only an old
> > controlfile or even NO controlfile (as long as i have a 'trace' copy
with
> > which to rebuild it)
> >
> > In the later case, I had to comment out the RECOVER DATABASE line in the
> > trace script, and did the following:
> >
> > startup nomount
> > @/location/of/trace/file/control01.trc (ignore error message ORA-01503:
> > CREATE CONTROLFILE failed - it DID create one)
> >
> > recover database using backup controlfile until cancel
> > auto
> > alter database open resetlogs
> >
> > this took me right up to last archived redo log which is what I wanted.
> >
> > Simon Hume
> > Publishers Market AG
> > Lindwurmstrasse 129a
> > D-80337 München
> >
>
>
Received on Mon Dec 03 2001 - 12:47:37 CST
