Archive logs are not transferred to STDBY database
Hi,
I have create a STDBY database (I am running the release 9.2.0.7.0).
I see that the archivelogs are not correctly transferred into STDBY server.
From Primary alert log, I see the following error:
**********************************************************
ARC1: Evaluating archive log 1 thread 1 sequence 16734
ARC1: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2
ARC1: Destination LOG_ARCHIVE_DEST_2 archival not expedited
ARC1: Beginning to archive log 1 thread 1 sequence 16734
Creating archive destination LOG_ARCHIVE_DEST_1: '/backup/archivelogs/log1_16734.arc'
ARC1: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2
Invoking non-expedited destination LOG_ARCHIVE_DEST_2 thread 1 sequence 16734 host STDBY_PROD
ARC1: Completed archiving log 1 thread 1 sequence 16734
Thu Nov 17 14:54:42 2011
Errors in file /mnt/orclEBS/oracle/proddb/9.2.0/admin/PROD_ebslive/bdump/prod_arc0_5277.trc:
ORA-03114: not connected to ORACLE
Thu Nov 17 14:54:42 2011
ARC0: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
Thu Nov 17 14:54:42 2011
ORACLE Instance PROD - Archival Error. Archiver continuing.
ARCH: Connecting to console port...
Thu Nov 17 14:54:42 2011
ORA-16055: FAL request rejected
ARCH: Connecting to console port...
Thu Nov 17 14:54:42 2011
Errors in file /mnt/orclEBS/oracle/proddb/9.2.0/admin/PROD_ebslive/bdump/prod_arc0_5277.trc:
ORA-16055: FAL request rejected
ARC0: Begin FAL archive (thread 1 sequence 16483 destination STDBY_PROD)
Creating archive destination LOG_ARCHIVE_DEST_2: 'STDBY_PROD'
Thu Nov 17 15:05:44 2011
LGWR: I/O error 3114 archiving log 2 to 'STDBY_PROD'
Thu Nov 17 15:05:44 2011
Errors in file /mnt/orclEBS/oracle/proddb/9.2.0/admin/PROD_ebslive/bdump/prod_lgwr_5265.trc:
ORA-03114: not connected to ORACLE
Thu Nov 17 15:10:08 2011
Errors in file /mnt/orclEBS/oracle/proddb/9.2.0/admin/PROD_ebslive/bdump/prod_arc0_5277.trc:
ORA-03114: not connected to ORACLE
Thu Nov 17 15:10:08 2011
ARC0: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
Thu Nov 17 15:10:08 2011
ORACLE Instance PROD - Archival Error. Archiver continuing.
ARCH: Connecting to console port...
Thu Nov 17 15:10:08 2011
ORA-16055: FAL request rejected
ARCH: Connecting to console port...
Thu Nov 17 15:10:08 2011
Errors in file /mnt/orclEBS/oracle/proddb/9.2.0/admin/PROD_ebslive/bdump/prod_arc0_5277.trc:
ORA-16055: FAL request rejected
********************************************************************************
I see that both archiving destinations are VALID:
SQL> select dest_id, dest_name, status from v$archive_dest_status where status != 'INACTIVE';
DEST_ID ---------- DEST_NAME -------------------------------------------------------------------------------- STATUS
---------
1 LOG_ARCHIVE_DEST_1 VALID
2 LOG_ARCHIVE_DEST_2 VALID
SQL>
TNSPING works properly in both directions, e.g. from PROD -> STDBY:
$tnsping STDBY_PROD
TNS Ping Utility for Linux: Version 9.2.0.7.0 - Production on 17-NOV-2011 16:56:40
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/mnt/orclEBS/oracle/proddb/9.2.0/network/admin/PROD_ebslive/sqlnet_ifile.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp) (HOST=EBSSTDBY) (PORT=1521)) (CONNECT_DATA=(SID=PROD)))
OK (10 msec)
Please help me to solve this issue.
Thank you.