Database Software

Hi,
We have Primay and logical database configuration both in RAC in Production. both database are in 10.2.0.4.

Everyday we having issue of some archivelog not transfered to logical server around 2AM. I am having good exposure in Logical/Log minor/Goldgendate and can say fal server/client server configuration is correct.

Can you guys please give some input of what can cause this.
Yes we take RMAN backup of both database around 1:30 using control file instead of recovery catalog and I doubt this put lock on control file and cause this issue.

I would be glad of you could help me out in this.

Thanks a lot!

Pradeep

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Below is the configuration of archive/fal on both database.
PIP1REP2 is logical database(instance 2) where apply process is running/configured.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


Primary server configuration on (PIP11) (same are on other instances).

SQL> sho parameter fal

NAME TYPE VALUE
------------------------------------ -------------------------------------------- ------------------------------
fal_client string PIP1REP2
fal_server string PIP11


SQL> sho parameter archive

NAME TYPE VALUE
------------------------------------ -------------------------------------------- ------------------------------
log_archive_dest_1 string LOCATION=+ARCH01
log_archive_dest_2 string SERVICE=pip1rep2 lgwr async
log_archive_dest_state_1 string enable
log_archive_dest_state_2 string ENABLE
llog_archive_local_first boolean TRUE
log_archive_max_processes integer 10
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
remote_archive_enable string true


Logical server configuration

SQL> sho parameter fal

NAME TYPE VALUE
------------------------------------ -------------------------------------------- ------------------------------
fal_client string PIP1REP
fal_server string pip11, pip12, pip13, pip14, pi
p15
SQL> sho parameter archive

NAME TYPE VALUE
------------------------------------ -------------------------------------------- ------------------------------
alog_archive_dest_1 string LOCATION=+ARCH01/PIP1REP valid
for=(onlinelogfiles, all_rol
es) db_unique_name=pip1rep

log_archive_dest_2 string LOCATION=+ARCH01/PIP1REP/ARCH_
DEST2_STANDBY_LOGS VALID_FOR=(
STANDBY_LOGFILES,STANDBY_ROLE)
db_unique_name=pip1rep

log_archive_dest_state_1 string enable
log_archive_dest_state_2 string enable
log_archive_local_first boolean TRUE
log_archive_max_processes integer 20
log_archive_min_succeed_dest integer 1
log_archive_trace integer 0
remote_archive_enable string true
standby_archive_dest string +ARCH01