ORA-19906 Frequently on Physical Standby
(Doc ID 960653.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 184.108.40.206 [Release 10.1 to 11.2]
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 27-Sep-2012***
***Checked for relevance on 06-Aug-2014***
Physical standby setup. Physical standby was activated accidentally on Fri Aug 07 09:20:50, incarnation was increased to 15 at that time, while primary was still running with incarnation 14. Then standby was rebuilt using fresh backup from primary and continued with recovery.
But every time delete Oracle managed file from db_recovery_area happens, it always follows by incarnation change, for example:
Deleted Oracle managed file /opt/oracle/share/flash_recovery_area/DB_2/flashback/o1_mf_526gg3co_.flb
Deleted Oracle managed file /opt/oracle/share/flash_recovery_area/DB_2/flashback/o1_mf_526kkg8b_.flb
Setting recovery target incarnation to 15
This caused standby to report ORA-19906:
Fast Parallel Media Recovery enabled
Managed Standby Recovery starting 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 60565076) is orphaned on incarnation#=14
MRP0: Background Media Recovery terminated with error 19909
Errors in file
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '/opt/oracle/db_2/database/system01.dbf'
Managed Standby Recovery not using Real Time Apply
Despite how many times standby rebuilt, it always report such error soon after rebuilt.
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