2 ayri standby ortamini replike ediyorsaniz (ayrica prod, standby1 ve standby2 olarak her 3 ortamda da dataguard config’leri set edilmis ise) ve birinde flashback ile restore point’e döndügünüzde diger standby ortaminda
redo appyl ederken alertlog’da asagidaki gibi hata alabilirsiniz. prod ve standby db’nin incarnation degeri degistigi için match etmiyor ve bu hatayi aliyoruz.
MRP0 started with pid=36, OS id=24117256 MRP0: Background Managed Standby Recovery process started (TESTDB) started logmerger process Tue Nov 20 12:01:31 2018 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 7784353096122) is orphaned on incarnation#=1 MRP0: Detected orphaned datafiles! Recovery will possibly be retried after flashback... Errors in file /oracle/app/oracle/diag/rdbms/testdb/TESTDB/trace/TESTDB_pr00_38469770.trc: ORA-19909: datafile 1 belongs to an orphan incarnation ORA-01110: data file 1: '+DATA/testdb/datafile/system.345.973781957' Completed: alter database recover managed standby database disconnect from session Recovery Slave PR00 previously exited with exception 19909 Tue Nov 20 12:01:49 2018
asagidaki komutla prod ve standby ortamlarinda incarnation bilgilerini görebilirsiniz:
RMAN> list incarnation of database;
standby ortamda incarnation degerini 1’e set ediniz:
RMAN> reset database to incarnation 1;
daha sonra tekrar standby redo apply’i baslatabilirsiniz:
alter database recover managed standby database disconnect from session; select process, status, sequence# from v$managed_standby;
Referans: ORA-19906 and ORA-19909 at standby site (Doc ID 1509932.1)