Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Hot Backup and Recovery - When to switch log files.

Re: Hot Backup and Recovery - When to switch log files.

From: Joel Garry <joel-garry_at_home.com>
Date: 17 May 2004 14:36:28 -0700
Message-ID: <91884734.0405171336.6648e9a6@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US