We're here to help!

ERROR_CODE:415 - Variable ARCHTMP is set to Oracle archive log destination location

Follow

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

Solution

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> 
 
 
 
 
 
Have more questions? Submit a request

Comments