This issue is encountered occasionally when applying archive log, a timeout occurs and fails with an error.
Problem Details
Problem Statement
Log apply on standby fails with an error message and error code
Applicable Error Code
Error Code: 2044
File (/usr/dbvisit/standby/tmp/33593.dbvisit.201904160305.sqlplus.dbv) does not exist
or is empty. Please check space and file permissions.
Affected Versions
v8, v9, v10 and v11
Affected Platforms
All
Description
When the standby database is being recovered by applying the archivelogs, there is basically set a hard limit for how long the apply of one archivelog can take. The default value is 125 seconds. This error occurs when the archive log apply takes longer than the default timeout value.
Solution
Option 1: Increase the timeout for apply archive log by adding the following parameter to DDC file in the primary
WAIT_FOR_FILE_SEC=250
Run the command from primary to copy the updated file to standby
./dbvctl -d <DDC> -c
Restart the daemon process for changes to take into effect
Option 2: Switch to RMAN for applying archived logs instead of sqlplus and thus there will be no need waiting for the sqlplus file. This can be done by changing the below parameter in the DDC file from N to Y
APPLY_ARCHIVE_RMAN=Y
Run the command from primary to copy the updated DDC to standby
./dbvctl -d <DDC> -c
Restart the daemon process for changes to take into effect
Comments