StandbyArchiveLocation

The StandbyArchiveLocation configurable property specifies the standby redo log archive location. Oracle recommends that you always explicitly set the value.

Category Description

Datatype

String

Valid values

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

  • A nonempty file specification of the standby redo log archive location for the instance. 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, standby, and far sync instance

Standby type

Physical, logical, or snapshot standby, or a far sync instance

Corresponds to

  • LOCATION attribute of the LOG_ARCHIVE_DEST_n initialization parameter of the standby database or far sync instance with VALID_FOR compatible with (STANDBY_LOGFILE, ALL_ROLES)

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

Scope

Member

Cloud Control name

Standby Archive Location

Note:

On a logical standby database, Oracle recommends the LOCATION attribute of the LOG_ARCHIVE_DEST_n initialization parameter for the local destination be different from the value of StandbyArchiveLocation property, unless you are using a database recovery area.

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.