Re: Database copy -- recover database question

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<4131a992$0$11963$afc38c87_at_news.optusnet.com.au>...
> James wrote:
>
> > System altered.
> > SQL> alter database backup controlfile to trace;
>
> Right... you take a backup of the control file (though only to trace, which
> has issues of its own. Bear with me).
>
> > SQL> shutdown
>
> > Database closed.
> > Database dismounted.
> > ORACLE instance shut down.
> [snip a perfectly standard trace file, which you could have usefully done
> too!]
>
> > SQL> recover database using backup controlfile
>
> Wrong command. I don't know why people insist on doing this, but they
> invariably do. There was a rash of posts doing it unnecessarily a few
> months back. The phrase 'using backup controlfile' has a very specific
> meaning: "I am using a control file which was backed up some time ago".

Because "backup controlfile to trace" and "using backup controlfile" appear commutative. It's just unfortunate historical syntax.

jg

--
@home.com is bogus.  Regarding not having a potato peeler, the Oracle
way would be to say "Larry has determined that customers prefer
potatoes with the skin on, so we have decremented the peeling of
potatoes.  So quit trying to do what you are used to and get with the
program!"