Redo log shipping fails with ORA-270 at Primary when max_connections is set to value > 1
(Doc ID 2042222.1)
Last updated on JUNE 16, 2021
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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 <sequence#> dbid <dbid> branch <branch value>
Deleted Oracle managed file <+diskgroup>/dbname/filetype/filetypetag.file.incarnation
Mon May 25 06:44:07 2015
Errors in file /<path>/diag/rdbms/<db_name>/<oracle_sid>/trace/<oracle_sid>_rfs_<pid>.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)
Mon May 25 06:43:11 2015
RFS[20]: Assigned to RFS process 30128
RFS[20]: Opened log for thread 1 sequence <sequence#> dbid <dbid> branch <branch value>
Deleted Oracle managed file <+diskgroup>/dbname/filetype/filetypetag.file.incarnation
Mon May 25 06:44:07 2015
Errors in file /<path>/diag/rdbms/<db_name>/<oracle_sid>/trace/<oracle_sid>_rfs_<pid>.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'
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'
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |