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: LOG_ARCHIVE_DEST to up to 90 remote locations????

Re: LOG_ARCHIVE_DEST to up to 90 remote locations????

From: Van Messner <vmessner_at_bestweb.net>
Date: Thu, 4 Sep 2003 17:13:55 -0400
Message-ID: <vlfb0rt55cv053@corp.supernews.com>


typo

"Peter Shankey" <shankeyp_at_NOSPAM.comcast.net> wrote in message news:iV6dnQpWT8hFAsqiXTWJgA_at_comcast.com...
> I am working on the OCP for 9i. This is an explaination I received for a
> test question. If this is true could I have an example of the syntax for
12
> locations? In reading through the docs and looking at a good number of
> example I am just not seeing how Oracle could be configured for up to 90
> remote locations.
>
> The LOG_ARCHIVE_DEST_n initialization parameter specifies multiple default
> destinations for the archived redo log files: LOG_ARCHIVE_DEST_n =
"LOCATION
> | SERVICE <file_storage_destination>" (where n = 1,2,3 . . .10). Use the
> LOCATION option to indicate a local file system destination, and the
SERVICE
> option to indicate an Oracle Net alias for a remote destination. At least
> one of the archive destinations specified using the LOG_ARCHIVE_DEST_n
> parameter must be local.
>
>
> A maximum of 10 locations may be specified using the LOG_ARCHIVE_DEST_n
> parameter, one of which must be for a local destination. It is possible,
but
> not likely, to have up to 90 remote destinations. Archive destinations
> specified using the LOG_ARCHIVE_DEST_n parameter are dynamic and can be
> altered at the system level using an 'ALTER SYSTEM SET LOG_ARCHIVE_DEST_n'
> statement or at the session level using an 'ALTER SESSION SET
> LOG_ARCHIVE_DEST_n' statement. Possible archive destinations are a local
> disk or a remote standby database. The SERVICE option specifies a standby
> database. A standby instance must be associated with the destination
> specified.
>
> Thank you
>
> Pete
>
>
>
>
Received on Thu Sep 04 2003 - 16:13:55 CDT

Original text of this message

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