LOG_ARCHIVE_DEST_n PARAMETER'S ATTRIBUTE
¡½ Specifies whether redo transport services use archiver processes (ARCn) or the log
writer process (LGWR) to collect transaction redo data and transmit it to standby
destinations. If neither the ARCH or LGWR attributes are specified, the default is ARCH.
¡½ Specifies that network I/O is to be done synchronously (SYNC) or asynchronously
(ASYNC) when archival is performed using the log writer process (LGWR).
Specifies the policy for reusing online redo log files:
¡½ MANDATORY¡Xspecifies that filled online log files must be successfully archived to
the destination before they can be reused.
¡½ OPTIONAL¡Xspecifies that successful archival to the destination is not required
before the online redo log file can be made available for reuse.
¡½ AFFIRM¡Xspecifies that all disk I/O to archived redo log files and standby redo
log files is performed synchronously and completes successfully before the log
writer process continues.
¡½ NOAFFIRM¡Xspecifies that all disk I/O to archived redo log files and standby redo
log files is performed asynchronously; the log writer process on the primary
database does not wait until the disk I/O completes before continuing.
¡½ REOPEN Specifies the minimum number of seconds before redo transport services should try to
reopen a failed destination.
¡½ MAX_FAILURE Controls the consecutive number of times redo transport services attempt to
reestablish communication and transmit redo data to a failed destination before the
primary database gives up on the destination.
¡½ Each destination must specify either the LOCATION or the SERVICE attribute to
identify either a local disk directory or a remote database destination where redo
transport services can transmit redo data.
¡½ Specifies a unique name for the database at this destination.
Specifies when redo transport services transmit redo data to a destination, based on
the following factors:
¡½ Whether the database is currently running in the primary or the standby role
¡½ Whether online redo log files, standby redo log files, or both are currently being
archived on the database at this destination
||Physical Standby Role
||Logical Standby Role|
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/308563/viewspace-496148/，如需转载，请注明出处，否则将追究法律责任。