Dear DR Experts,
@ Shivananda Rao wrote
If the standby has not applied the redo data past the new resetlog SCN of the primary, then the standby catches up automatically with the primary with new branch of the redo.
If the standby has already applied the redo data past the new resetlog SCN of the primary, then manual intervention would be needed to either rebuild the standby (or flashback if flashback is enabled).
REF_LINK : Controlfile Recovery on Primary
I did one more testings (LOST ALL REDO LOG FILES AND CONTROL FILES ON PRIMARY)
Flashback option NOT enabled on standby database.
The standby database and primary is showing new redo branch id 910483903
then whenever i start MRP , why it is going down ??
Incarnation has been changed , its ok. but still i expect some more clean information.
>> On Primary
SQL> select resetlogs_id, resetlogs_change# from v$database_incarnation where status='CURRENT';
RESETLOGS_ID RESETLOGS_CHANGE#
------------ -----------------
910483903 903622
>> Standby
select resetlogs_id, resetlogs_change# from v$database_incarnation where status='CURRENT';
RESETLOGS_ID RESETLOGS_CHANGE#
------------ -----------------
910483903 903622
>> alert log snippet from standby database
Sat Apr 30 00:23:12 2016
alter database recover managed standby database using current logfile disconnect
Attempt to start background Managed Standby Recovery process (stbycrms)
Sat Apr 30 00:23:13 2016
MRP0 started with pid=20, OS id=20098
MRP0: Background Managed Standby Recovery process started (stbycrms)
Serial Media Recovery started
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 905257) is orphaned on incarnation#=2
MRP0: Detected orphaned datafiles!
Recovery will possibly be retried after flashback...
Errors in file /u01/app/oracle/diag/rdbms/stbycrms/stbycrms/trace/stbycrms_mrp0_20098.trc:
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '/u01/app/oracle/oradata/stbycrms/system01.dbf'
Managed Standby Recovery not using Real Time Apply
Errors in file /u01/app/oracle/diag/rdbms/stbycrms/stbycrms/trace/stbycrms_mrp0_20098.trc:
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '/u01/app/oracle/oradata/stbycrms/system01.dbf'
Completed: alter database recover managed standby database using current logfile disconnect
Sat Apr 30 00:23:40 2016
MRP0: Background Media Recovery process shutdown (stbycrms)
Sat Apr 30 00:23:43 2016
RFS[8]: Selected log 6 for thread 1 sequence 4 dbid 1612532377 branch 910483903
Sat Apr 30 00:23:45 2016
Archived Log entry 12 added for thread 1 sequence 3 ID 0x601d2800 dest 1:
in this case , do i need to rebuild standby or any other options ??
Thanks .