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

LOG_ARCHIVE_DEST to up to 90 remote locations????

From: Peter Shankey <shankeyp_at_NOSPAM.comcast.net>
Date: Thu, 4 Sep 2003 15:27:14 -0500
Message-ID: <iV6dnQpWT8hFAsqiXTWJgA@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 - 15:27:14 CDT

Original text of this message

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