ArchiveLocation

The ArchiveLocation configurable property specifies the online redo log archive location for primary, logical, and snapshot standby databases.

If the StandbyArchiveLocation property is not empty, the ArchiveLocation property specifies an online redo log archive location. If the StandbyArchiveLocation property is empty, the ArchiveLocation property specifies an online and standby redo log archive location.

Set a value for this property if you want Oracle to manage local archiving.

Note:

These properties allow you to have the broker automatically manage the local archival of online and standby redo logs to the specified local destination. Do not use set log_archive_dest_n initialization parameters for local archival specifying that same destination.
Category Description
Datatype String
Valid values

  • An empty string when you do not want broker to manage the online archive location.

  • A nonempty file specification of the redo log archive location for the database. Specify USE_DB_RECOVERY_FILE_DEST if a database recovery area is desired.

  • A valid LOG_ARCHIVE_DEST_n parameter string with the LOCATION attribute specified, but no VALID_FOR, ALTERNATE, or SERVICE attributes.

Broker default Empty string
Imported? No
Parameter class Dynamic
Role Primary and standby
Standby type Physical, logical, or snapshot standby
Corresponds to

  • LOCATION attribute of the LOG_ARCHIVE_DEST_n initialization parameter of the primary or standby database with VALID_FOR compatible with (ONLINE_LOGFILE, ALL_ROLES)

  • DESTINATION column of the V$ARCHIVE_DEST view of the primary or standby database

Scope Member
Cloud Control name There is no Cloud Control name

Note:

When resetting ArchiveLocation, broker will change the property value to an empty string, but will not update the initialization parameter log_archive_dest_n that points to the location specified by the property ArchiveLocation before resetting it. The reasons are:
  1. The redo log archiver must have an accessible location to archive the redo log. If the arching fails, the archiver will be stuck, then the database will be in restricted mode. Since broker does not have knowledge which archive location should be used, so intentionally does not update the parameter log_archive_dest_n corresponding to the archive location.
  2. An empty value for property ArchiveLocation indicates that the user can manually manage the local archive destinations.