StandbyAlternateLocation

The StandbyAlternateLocation configurable property specifies an alternate standby redo log archive location to use when the location specified by the StandbyArchiveLocation configurable property fails.

The property has database-specific scope, and the location that it specifies is applicable to all instances in a database.

Category Description

Datatype

String

Valid values

  • An empty string, when no alternate location is desired.

  • A directory specification that is accessible by the instance.
  • 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

On the standby database or the far sync instance, the LOCATION attribute for the LOG_ARCHIVE_DEST_n initialization parameter that represents an alternate destination of the local destination that matches the configurable property StandbyArchiveLocation.

Scope

Member

Cloud Control name

Alternate Standby 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 StandbyAlternateLocation configurable property.

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.