My Oracle Support Banner

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

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
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.