Re: Archived Log File broken

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Mon, 5 Jul 2004 20:13:56 +0100
Message-ID: <40e9a86d$0$6445$cc9e4d1f@news-text.dial.pipex.com>

"FlameDance" <FlameDance_at_gmx.de> wrote in message news:cbtphv$aci$01$1_at_news.t-online.com...

> > Hacking your own 'standby' mechanism together, where a stable Oracle
> > solution exists.
>
> I believe I did it by the book. Which would be your suggested stable
> Oracle solution? A connection between production and standby via
> SQLNet8? That would mean instant recovery, wouldn't it? It's not what I
> want.

This is true on 8i, it certainly isn't true on either 9.2 or 10. Eg (from the manuals)

LOG_ARCHIVE_DEST_3='SERVICE=stby1 DELAY=240' LOG_ARCHIVE_DEST_STATE_3=ENABLE

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

Received on Mon Jul 05 2004 - 14:13:56 CDT