Prev | Current Page 715 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"


SYNC and ASYNC SYNC and ASYNC specify that network I/O is to be done synchronously or
asynchronously when using the log writer process (LGWR). The default is
SYNC=PARALLEL, which should be used when there are multiple destinations
with the SYNC attribute. All destinations should use the same value.
TEMPLATE and
NOTEMPLATE
TEMPLATE defines a directory specification and format template for names of
the archived redo log files or standby redo log files at the standby destination.
You can specify these attributes in either the primary or standby initialization
parameter file, but the attribute applies only to the database role that is archiving.
VALID_FOR VALID_FOR identifies when Log Transport Services can transmit redo data to
destinations based on the following factors: (1) whether the database is currently
running in the primary or the standby role, and (2) whether online redo log files,
standby redo log files, or both are currently being archived on the database
at this destination. The default value for this attribute is VALID_FOR=(ALL_
LOGFILES, ALL_ROLES). Other values include PRIMARY_ROLE, STANDBY_
ROLE, ONLINE_LOGFILES, and STANDBY_LOGFILE.
VERIFY and NOVERIFY VERIFY indicates an archiver process should verify the correctness of the
contents of a completed archived redo log file. The default is NOVERIFY.
TABLE 13-1 LOG_ARCHIVE_DEST_n Parameter Attributes (continued)
480 Oracle Database 11g DBA Handbook
If the primary and standby databases are on separate servers, you can use the same directory
structures for each, avoiding the need for the filename conversion parameters.


Pages:
703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727
Kalkulator kredytowy Kocham wakacje Budowa domu jednorodzinnego Warszawa poker ogrzewanie lubuskie