ORA-19906 and ORA-19909 at standby site (Doc ID 1509932.1)

Last updated on OCTOBER 25, 2016

Applies to:

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

Symptoms

Redo apply at standby site suddenly failed as shown in the alert.log:


Thu Nov 22 14:40:13 MET 2012
Media Recovery Log /APPL/ORACLE/SGSDGB/arch/SGSDGB_1_699789524_129430.arc[1]  
Thu Nov 22 14:40:26 MET 2012
Media Recovery Waiting for thread 1 sequence 129431 [2]                       
Thu Nov 22 14:44:34 MET 2012
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[4]: Assigned to RFS process 24267
RFS[4]: Identified database type as 'physical standby'
RFS[4]: Archived Log: '/APPL/ORACLE/SGSDGB/arch/SGSDGB_1_800028335_10.arc'
RFS[4]: Physical Standby in the future of Branch(resetlogs_id) 800028335
RFS[4]: Standby database SCN: 1746:-485073214  Primary branch SCN: 1746:-486307562
RFS[4]: New Archival REDO Branch(resetlogs_id): 800028335  Prior: 699789524
RFS[4]: Archival Activation ID: 0x5a34242d Current: 0x2f28438f
RFS[4]: Effect of primary database OPEN RESETLOGS
RFS[4]: Managed Standby Recovery process is active
New incarnation branch detected in ArchiveLog, filename /APPL/ORACLE/SGSDGB/arch/SGSDGB_1_800028335_10.arc [3] 
Inspection of file changed rdi from 1 to 2
Setting recovery target incarnation to 2
Thu Nov 22 14:44:37 MET 2012
MRP0: Incarnation has changed! Retry recovery...
Thu Nov 22 14:44:37 MET 2012
Errors in file /APPL/ORACLE/SGSDGB/admin/bdump/sgsdgb_mrp0_20506.trc:
ORA-19906: recovery target incarnation changed during recovery [4]
Recovery interrupted!
Thu Nov 22 14:44:40 MET 2012
Errors in file /APPL/ORACLE/SGSDGB/admin/bdump/sgsdgb_mrp0_20506.trc:
ORA-19906: recovery target incarnation changed during recovery
Thu Nov 22 14:45:00 MET 2012
Managed Standby Recovery not using Real Time Apply
Warning: Recovery target destination is in a sibling branch
of the controlfile checkpoint. Recovery will only recover
changes to datafiles.
Datafile 1 (ckpscn 7502822792898) is orphaned on incarnation#=1
MRP0: Background Media Recovery terminated with error 19909
Thu Nov 22 14:45:00 MET 2012
Errors in file /APPL/ORACLE/SGSDGB/admin/bdump/sgsdgb_mrp0_20506.trc:
ORA-19909: datafile 1 belongs to an orphan incarnation [5]
ORA-01110: data file 1: '/APPL/ORACLE/SGSDGB/data02/system01.dbf'
Thu Nov 22 14:45:00 MET 2012
Errors in file /APPL/ORACLE/SGSDGB/admin/bdump/sgsdgb_mrp0_20506.trc:
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '/APPL/ORACLE/SGSDGB/data02/system01.dbf'

 

From the above:

[1] most recent archive log applied

[2] the next sequence the standby needs to apply

[3] new archivelog name, and new incarnation!!

[4] there's a change of incarnation detected in this new archivelog

[5] Oracle is only reporting the first datafile issue encountered (file#1). All datafiles at this point belong to an orphaned incarnation

 

Changes

 The standby database was opened with resetlogs.  Usually, this occurs as part of a DR test and standby is then flashed back.  

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