Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> LOG_ARCHIVE_DEST to up to 90 remote locations????
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
![]() |
![]() |