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)

Reklamlar