AlternateLocation

The AlternateLocation configurable property specifies an alternate online redo log archive location for primary, logical, and snapshot standby databases when the location specified by the ArchiveLocation configurable property fails.

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

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

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 no alternate location is desired. A directory specification that is accessible by the database. 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	On the primary or standby database, 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 ArchiveLocation.
Scope	Member
Cloud Control name	There is no Cloud Control name