Document Type | Technical Information
Category | Administration
Applicable Product Versions | 6FS07PS, 7FS02PS
Document Number | TADTS077
Issue
This document explains cases where ERROR_CACHE_LOGNET_LOGFILE_NOT_FOUND occurs despite the presence of archived logs, along with corrective measures.
1. On standby, THROW occurs. ec=ERROR_CACHE_LOGNET_DISCONN(-1102) error continuously occurs.
2. On active, THROW occurs. ec=ERROR_CACHE_LOGNET_LOGFILE_NOT_FOUND(-1033) error continuously occurs.
3. However, in the ARCHIVED_LOG_DEST path, archived logs older than the log sequence at the time of the error exist.
Cause
1. TSC looks for archived logs to read during synchronization by reading information from the Control File to find the target.
2. The list of archived logs stored in the Control File only saves up to the MAXARCHIVELOG value within the control file, not the entire ARCHIVED_LOG_DEST files.
MAXARCHIVELOG value.
3. Therefore, if the synchronization difference between Active and Standby exceeds the number of archived logs specified by MAXARCHIVELOG,
even if the actual files remain, the Control File information cannot find them, resulting in a file not found error.
--1. When creating the DB: MAXARCHIVELOG is set to 500.
create database
user sys identified by tibero
NOARCHIVELOG
MAXLOGFILES 255
MAXLOGMEMBERS 8
MAXDATAFILES 4096
MAXARCHIVELOG 500
MAXBACKUPSET 500
MAXLOGHISTORY 500
CHARACTER SET UTF8
NATIONAL CHARACTER SET UTF16
logfile
group 1 ('redo001.redo') size 100M,
group 2 ('redo011.redo') size 100M,
group 3 ('redo021.redo') size 100M
datafile 'system001.dtf' size 100M
(omitted)
--2. When generating control file trace: MAXARCHIVELOG 500 setting is visible.
CREATE CONTROLFILE REUSE DATABASE "tibero"
LOGFILE
GROUP 0 '/home/tibero/tbdata/redo01.redo' SIZE 50M,
GROUP 1 '/home/tibero/tbdata/redo02.redo' SIZE 50M,
GROUP 2 '/home/tibero/tbdata/redo03.redo' SIZE 50M
NORESETLOGS
DATAFILE
'/home/tibero/tbdata/system001.dtf',
'/home/tibero/tbdata/undo001.dtf',
'/home/tibero/tbdata/usr001.dtf',
'/home/tbdata/undo002.dtf',
'/home/tibero/tbdata/apm_ts.dtf'
NOARCHIVELOG
MAXLOGFILES 255
MAXLOGMEMBERS 8
MAXDATAFILES 4096
MAXARCHIVELOG 500
MAXBACKUPSET 500
MAXLOGHISTORY 500
CHARACTER SET UTF8
NATIONAL CHARACTER SET UTF16
(omitted)
;
Solutions
1. If it is the initial setup, one option is to increase the MAXARCHIVELOG count and recreate the control file.
2. If a patch has been applied, you can use the feature to check the actual file path instead of the Control file using the method below.
- 308817a: Patch included by default from Tibero7FS02PS, Tibero6FS06PS
- ALTER SYSTEM SET _LNW_LOG_ARCHIVE_SEARCH_DEST=Y
3. When setting parameter 2, even if the synchronization target logs differ by more than MAXARCHIVELOG, if files exist in ARCHIVED_LOG_DEST,
they are read normally and synchronization starts.
Function Parameters
_LNW_LOG_ARCHIVE_SEARCH_DEST
Whether LNW refers to the archive log path before the Control File when transmitting archive logs.
If N, only the Control File is read; if Y, the archive log path is checked first, then the Control File.Category Description Type Boolean Default N Attributes Optional, Adjustable, Dynamic, System How to Set Set in TIP file and restart or change with ALTER statement. Syntax - TIP file
_LNW_LOG_ARCHIVE_SEARCH_DEST=[Y|N]
- ALTER statement
ALTER SYSTEM SET _LNW_LOG_ARCHIVE_SEARCH_DEST=[Y|N];_LNW_LOG_ARCHIVE_SEARCH_DEST_ONLY
Whether LNW refers only to the archive log path and not the Control File when transmitting archive logs.
Can be set to Y only when _LNW_LOG_ARCHIVE_SEARCH_DEST=Y.Category Description Type Boolean Default N Attributes Optional, Adjustable, Dynamic, System How to Set Set in TIP file and restart or change with ALTER statement. Syntax - TIP file
_LNW_LOG_ARCHIVE_SEARCH_DEST_ONLY=[Y|N]
- ALTER statement
ALTER SYSTEM SET _LNW_LOG_ARCHIVE_SEARCH_DEST_ONLY=[Y|N];_LNW_IGNORE_LOG_ARCHIVE_FORMAT
Whether LNW allows archived logs with file names that do not satisfy the archive log format when referencing the archive log path to transmit archive logs.
Category Description Type Boolean Default N Attributes Optional, Adjustable, Dynamic, System How to Set Set in TIP file and restart or change with ALTER statement. Syntax - TIP file
_LNW_IGNORE_LOG_ARCHIVE_FORMAT=[Y|N]
- ALTER statement
ALTER SYSTEM SET _LNW_IGNORE_LOG_ARCHIVE_FORMAT=[Y|N];_LNW_LOG_ARCHIVE_DEST
The archive log path LNW refers to when transmitting archive logs.
If not set separately, the LOG_ARCHIVE_DEST value is used.
Category Description Type String Default LOG_ARCHIVE_DEST Attributes Optional, Adjustable, Dynamic, System How to Set Set in TIP file and restart or change with ALTER statement. Syntax - TIP file
_LNW_LOG_ARCHIVE_DEST=<path to use separately>
- ALTER statement
ALTER SYSTEM SET _LNW_LOG_ARCHIVE_DEST=<path to use separately>;_LNW_LOG_ARCHIVE_SEARCH_DEST_RETRY_CNT
The number of times (seconds) LNW retries when transmitting archive logs by referring to an archive log path different from LOG_ARCHIVE_DEST if the archive log does not exist or if the size differs due to copying and the open fails.
Retries once per second, and if it still cannot find the archive log after the parameter value is reached, it triggers ERROR_CACHE_LOGNET_LOGFILE_NOT_FOUND error.
Category Description Type Integer Default 86400 Attributes Optional, Adjustable, Dynamic, System How to Set Set in TIP file and restart or change with ALTER statement. Syntax - TIP file
_LNW_LOG_ARCHIVE_DEST=<path to use separately>
- ALTER statement
ALTER SYSTEM SET _LNW_LOG_ARCHIVE_DEST=<path to use separately>;