Parameter Name: log_archive_config. Both the REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG parameters are defined in the initialization file and they are mutually. Use this command to define a new archive copy group within a specific. Parameters domain_name. The archive copy will be kept for a minimum of 90 days.

15 LOG_ARCHIVE_DEST_n Parameter Attributes This chapter provides reference information for the attributes of the LOG_ARCHIVE_DEST_ n initialization parameter, where n is an integer between 1 and 31. Roger Eno Voices Rarity there. Category ALTERNATE=LOG_ARCHIVE_DEST_ n Data Type String Valid Value A LOG_ARCHIVE_DEST_ n destination, where n is a value from 1 through 10. Default Value None. If an alternate destination is not specified, then redo transport services do not automatically change to another destination. What Would Emma Dopdf Download there.

Requires attributes Not applicable Conflicts with attributes None Corresponds to ALTERNATE and STATUS columns of the V$ARCHIVE_DEST view Footnote 1 If the REOPEN attribute is specified with a nonzero value, the ALTERNATE attribute is ignored. If the MAX_FAILURE attribute is also specified with a nonzero value, and the failure count exceeds the specified failure threshold, the ALTERNATE destination is enabled. Change Routeros Software Idm here.

Therefore, the ALTERNATE attribute does not conflict with a nonzero REOPEN attribute value. Usage Notes • LOG_ARCHIVE_DEST_11 through LOG_ARCHIVE_DEST_31 cannot be specified as an alternate redo transport location.

• The ALTERNATE attribute is optional. If an alternate destination is not specified, then redo transport services do not automatically change to another destination if the original destination fails. • You can specify only one alternate destination for each LOG_ARCHIVE_DEST_ n parameter, but several enabled destinations can share the same alternate destination.

• Ideally, an alternate destination should specify either: • A different disk location on the same local standby database system (shown in ) • A different network route to the same standby database system (shown in ) • A remote standby database system that closely mirrors that of the enabled destination • If no enabled destinations reference an alternate destination, the alternate destination is implied to be deferred, because there is no automatic method of enabling the alternate destination. However, you can enable (or defer) alternate destinations at runtime using ALTER SYSTEM. • Any destination can be designated as an alternate destination, given the following restrictions: • At least one local mandatory destination is enabled. • The number of enabled destinations must meet the defined LOG_ARCHIVE_MIN_SUCCEED_DEST parameter value.

• A destination cannot be its own alternate. • Increasing the number of enabled destinations decreases the number of available alternate archiving destinations. • When a destination fails, its alternate destination is enabled on the next archival operation. There is no support for enabling the alternate destination in the middle of the archival operation because that would require rereading already processed blocks. This is identical to the REOPEN attribute behavior. • If the REOPEN attribute is specified with a nonzero value, the ALTERNATE attribute is ignored unless the MAX_FAILURE attribute has a nonzero value.

If the MAX_FAILURE and REOPEN attributes have nonzero values and the failure count exceeds the specified failure threshold, the ALTERNATE destination is enabled. Therefore, the ALTERNATE attribute does not conflict with a nonzero REOPEN attribute value. Example 15-1 Automatically Failing Over to an Alternate Destination LOG_ARCHIVE_DEST_1='LOCATION=/disk1 MANDATORY MAX_FAILURE=1 ALTERNATE=LOG_ARCHIVE_DEST_2' LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_DEST_2='LOCATION=/disk2 MANDATORY' LOG_ARCHIVE_DEST_STATE_2=ALTERNATE In both this example and in the following example, the MAX_FAILURE attribute must be specified or the destination will not fail over to the alternate destination when a problem is encountered. There is no default value for MAX_FAILURE; you must supply a value. Usage Notes • This attribute is optional if: • The LOG_ARCHIVE_CONFIG=DG_CONFIG initialization parameter is not specified. • This is a local destination (specified with the LOCATION attribute). • This attributes is required if the LOG_ARCHIVE_CONFIG=DG_CONFIG initialization parameter is specified and if this is a remote destination (specified with the SERVICE attribute).