| Property | Description |
|---|---|
| Parameter type | String |
| Syntax | STANDBY_ARCHIVE_DEST = filespec |
| Default value | Operating system-specific |
| Modifiable | ALTER SYSTEM |
| Range of values | A valid path or device name other than RAW |
STANDBY_ARCHIVE_DEST is relevant only for a standby database in managed recovery mode. It specifies the location of archive logs arriving from a primary database. Oracle uses STANDBY_ARCHIVE_DEST and LOG_ARCHIVE_FORMAT to fabricate the fully qualified standby log filenames and stores the filenames in the standby control file.
You can see the value of this parameter by querying the V$ARCHIVE_DEST data dictionary view.
See Also:
Oracle Data Guard Concepts and Administration for more information on setting this parameter and on managed recovery mode in general