Redo log shipping fails with ORA-270 at Primary when max_connections is set to value > 1 (Doc ID 2042222.1)

Last updated on OCTOBER 26, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

 Alert log of the Standby DB:

=================

Creating archive destination file : +RECO01 (1009640 blocks)
Mon May 25 06:43:11 2015
RFS[20]: Assigned to RFS process 30128
RFS[20]: Opened log for thread 1 sequence 118735 dbid 743911627 branch 838315787
Deleted Oracle managed file +RECO01/pt01gcso_tss2l828/archivelog/2015_05_25/thread_1_seq_118735.15377.880612991
Mon May 25 06:44:07 2015
Errors in file /local/dbms/oracle/admin/diag/rdbms/pt01gcso_tss2l828/PT01GCSO1/trace/PT01GCSO1_rfs_30920.trc:
ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database.
*************************************************************
WARNING: A file of type ARCHIVED LOG may exist in
db_recovery_file_dest that is not known to the database.
Use the RMAN command CATALOG RECOVERY AREA to re-catalog
any such files. If files cannot be cataloged, then manually
delete them using OS command. This is most likely the
result of a crash during file creation.
*************************************************************
Creating archive destination file : +RECO01 (960412 blocks)

 

Alert log of the Primary DB:

==================

log_archive_dest_2 service="xxxxx", LGWR ASYNC NOAFFIRM delay=0 optional compression=enable max_failure=0 max_connections=3 reopen=300 db_unique_name="xxxxxx" net_timeout=10, valid_for=(all_logfiles,primary_role) 

ARC2: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)            
ARC2: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Thu Jun 04 17:46:22 2015
minact-scn: Master returning as live inst:3 has inc# mismatch instinc:0 cur:4 errcnt:0
Thu Jun 04 17:46:23 2015
FAL[server, ARC2]: Error 270 creating remote archivelog file 'xxxxx'
FAL[server, ARC2]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance PT01GCSO1 - Archival Error. Archiver continuing.
FAL[server, ARC3]: FAL archival, error 16041 closing archivelog file 'xxxxx'

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms