Document Type | Technical Information
Category | Administration
Applicable Product Versions | 6FS07, 7FS02PS
Document Number | TADTI055
Overview
This guide explains how to configure multiplexing for archive log paths.
NoteThis content was verified on Tibero7 FS02 version.
Method
1. For LOG_ARCHIVE_DEST, when set as location="absolute path", archive logs are generated normally.
alter system set LOG_ARCHIVE_DEST = "/tibero/tibero7/database/test/archivelog";
You can confirm that archive logs are generated properly.
2. For LOG_ARCHIVE_DEST_N, when set as "absolute path", archive logs are not generated.
alter system set LOG_ARCHIVE_DEST_1 = "/tibero/tibero7/database/test/archivelog";
Archive logs were not created in the specified path.
3. When setting LOG_ARCHIVE_DEST_N, it must be configured with location="absolute path" using the same syntax as mandatory or optional.
alter system set LOG_ARCHIVE_DEST_1="location=/home/tibero/tibero7/database/test/archive1" or alter system set LOG_ARCHIVE_DEST_1="location=/home/tibero/tibero7/database/test/archive1 mandatory"
When executed with the above syntax, archive logs are generated normally.
Note
mandatory : If the archive log copy fails, the entire archive operation is considered failed.
optional : The archive operation continues even if it fails.
default : optional