Log transfer fails with ERROR_CODE:415 - Variable ARCHTMP is set to Oracle archive log destination location
Problem Details
Problem Statement
Log transfer fails with ERROR_CODE:415 - Variable ARCHTMP is set to Oracle archive log destination location
Applicable Error Code
ERROR_CODE:415
Variable ARCHTMP /u01/app/oracle/fast_recovery_area is set to Oracle archive log
destination location /u01/app/oracle/fast_recovery_area.
Affected Versions
v8 and v9
Affected Platforms
All
Description
The error occurs if the ARCHSOURCE is set to Oracle archive log destination location
SQL> show parameter db_recovery_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/fast_recovery_area
1. We highly recommend not to set Dbvisit ARCHSOURCE and ARCHDEST to Oracle archive log location
2. The ARCHTMP is temporary location where the logs get copied from ARCHSOURCE to ARCHTMP location prior to transfer.
This happens in 2 cases:
a. Primary database is ASM. The logs are copied from ASM to ARCHTMP before shipping them to standby
b. Compression is enabled (COMPRESS) so logs are compressed into ARCHTMP before transferring
Step1. Edit Dbvisit Configuration File
ARCHSOURCE = /u01/app/oracle/dbvisit_arch
ARCHDEST =/u01/app/oracle/dbvisit_arch
Step2: Run the command from primary to copy the updated DDC to standby
./dbvctl -d <DDC> -c
Step3: Send and apply logs
./dbvctl -d <DDC>
Comments