Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Hot Backup and Recovery - When to switch log files.
Mark Bole <makbo_at_pacbell.net> wrote in message news:<P8fpc.48829$2S.4129_at_newssvr29.news.prodigy.com>...
> At the risk of being completely obnoxious (no, not Obnoxio the Clown --
> I can't believe I had to google it to find out he was an X-Men villain,
> and also coincidentally an Informix newsgroup poster ...)
I doubt _that_ is a coincidence :-)
>
> I don't use binary controlfile backups for incomplete recovery.
>
> CREATE CONTROLFILE REUSE DATABASE "MY_DB" RESETLOGS NOARCHIVELOG [...]
>
> I do eventually get it to work... sorry! ;-) And it's portable!
Those darn resetlogs! ;-)
>
> What can I say, it's been a long work week ... and as long as I'm at it,
> I appreciate a sig that is different and enlightening every time! "It's
> always easier to move forward with an idea with $20,000," indeed!
The interesting challenge will be to declare all those sigs as an external table...
jg
-- @home.com is bogus. http://www.theregister.co.uk/2004/05/14/spam_club/Received on Mon May 17 2004 - 16:36:28 CDT