Skip to Main Content
Oracle Initialization Parameters Pocket Reference
book

Oracle Initialization Parameters Pocket Reference

by David C. Kreines
August 2004
Intermediate to advanced content levelIntermediate to advanced
122 pages
4h 22m
English
O'Reilly Media, Inc.
Content preview from Oracle Initialization Parameters Pocket Reference
LOG_ARCHIVE_DEST
56
|
Oracle Initialization Parameters Pocket Reference
NORECEIVE
Disables the receipt of remotely archived redo logs.
DG_CONFIG
Specifies a list of up to nine unique database names (defined
with the DB_UNIQUE_NAME initialization parameter) for
all the databases in the Data Guard configuration.
NODG_CONFIG
Eliminates the list of service provider names previously speci-
fied with the DG_CONFIG option.
LOG_ARCHIVE_DEST
Value:
String
Default:
Operating system dependent
Dynamic:
ALTER SYSTEM
Specifies the name of a fully qualified directory or tape device to
be used as a destination when archiving redo log files. Note that
archiving to tape is not supported on all operating systems.
Oracle recommends that if the Enterprise Edition of Oracle8i or
Oracle9i is used, you set LOG_ARCHIVE_DEST_n instead of
LOG_ARCHIVE_DEST.
LOG_ARCHIVE_DEST_n
Value:
See description
Default:
None
Dynamic:
ALTER SYSTEM, ALTER SESSION
Specifies up to 10 archived log destinations. This parameter is
valid for only the Oracle8i or Oracle9i Enterprise Edition. If you
use this parameter, you must not use LOG_ARCHIVE_DEST.
LOG_ARCHIVE_DEST_n
Parameter Quick Reference
|
57
Syntax
LOG_ARCHIVE_DEST_n = {SERVICE = service | LOCATION = location}
[AFFIRM | NOAFFIRM]
[ALTERNATE = destination | NOALTERNATE]
[ARCH | LGWR]
[DB_UNIQUE_NAME | NODB_UNIQUE_NAME] ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Running Applications on Oracle Exadata

Running Applications on Oracle Exadata

Joyjeet Banerjee

Publisher Resources

ISBN: 9780596528850