Re: 2nd Archive Destination Question

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 14 Nov 2002 12:27:51 +1100
Message-ID: <aSCA9.76145$g9.214901@newsfeeds.bigpond.com>

It depends. The LOG_ARCHIVE_DEST_n parameters take an option 'MANDATORY' or 'OPTIONAL' (the default). Mandatory means "I *must* archive to that destination", OPTIONAL means "I'd like to archive there, but if I don't I'll cope". Optional is the default.

Meaning that failure to archive to an optional destination doesn't bring a database to its knees. Failure to archive to a mandatory destination will.

The two destinations are entirely independent of each other until you get to 9i Release 2, when it is possible to establish dependencies between destinations. So failure to write to one destination means sod-all as far as the ability to write to the other destination is concerned.

Regards
HJR "Chuckster" <chuckycarson_at_networkcloud.com> wrote in message news:3DD2F268.1040107_at_networkcloud.com...
>
> Under Oracle 8.1.7, if you specify two archive destinations, will the
> database hang if one of the destinations run out of space? (ie: It can
> still right to the other destination)
>
> Thx,
> CC
>
>
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
=----- Received on Wed Nov 13 2002 - 19:27:51 CST