ORA-16009 reported on primary (Doc ID 1193334.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 24-Jul-2012***
***Checked for relevance on 06-Aug-2014***

Symptoms

--- primary ----

log_archive_dest_2 service=stndby LGWR

fal_client  =  prtp         ### connects to self from primary server, intended for role transition
fal_server = stndby      ### connects to standby, intended for role transition

Caution:- Primary's tnsnames.ora has a alias "prtp" that lets you connect to itself



Sat Aug 28 00:01:45 2010
ARC1: LGWR is actively archiving destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 24565 for destination LOG_ARCHIVE_DEST_2
Sat Aug 28 00:01:48 2010
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
Using STANDBY_ARCHIVE_DEST parameter default value as /archive/archive-log/
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 3634
RFS[1]: Not using real application clusters
Sat Aug 28 00:01:49 2010
Errors in file /oracle/admin/prtp/udump/prtp_rfs_3634.trc:
ORA-16009: remote archive log destination must be a STANDBY database
Sat Aug 28 00:01:49 2010
Errors in file /oracle/admin/prtp/bdump/prtp_arc0_29429.trc:
ORA-16009: remote archive log destination must be a STANDBY database
Sat Aug 28 00:01:49 2010


---- standby ---

fal_client = prtp       ### connects to self from standby server
fal_server = stndby   ### connects to primary from standby server


Fri Aug 27 23:33:13 2010
Media Recovery Waiting for thread 1 sequence 24563
Sat Aug 28 00:01:45 2010
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[10]: Assigned to RFS process 24687
RFS[10]: Identified database type as 'physical standby'
Primary database is in MAXIMUM PERFORMANCE mode
Primary database is in MAXIMUM PERFORMANCE mode
RFS[10]: Successfully opened standby log 9: '/oradata1/prtp/redo-log/redo9_1.log'
Sat Aug 28 00:01:45 2010
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[11]: Assigned to RFS process 24689
RFS[11]: Identified database type as 'physical standby'
RFS[11]: Successfully opened standby log 10: '/oradata1/prtp/redo-log/redo10_1.log'
Sat Aug 28 00:01:48 2010
Fetching gap sequence in thread 1, gap sequence 24563-24564
Sat Aug 28 00:02:01 2010
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[12]: Assigned to RFS process 24692
RFS[12]: Identified database type as 'physical standby'
RFS[12]: Archived Log: '/archive/archive-log/arc_1_24563_706389032.arc'
Sat Aug 28 00:02:08 2010

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