This discussion is archived
2 Replies Latest reply: Aug 30, 2013 8:12 AM by saurabh RSS

Is that possible to convert logical standby to physical standby ?

User593499-OC Newbie
Currently Being Moderated

Hi guys,

 

My steps for testing as below:

1.create a primary database

2.duplicate a physical standby database;

3.turn on flashback on both databases.

4.record SCN xxx on physical standby database.

5.convert physical standby to logical standby (using keep identity statement)

6.flashback to logical standby to xxx

7.convert logical standby to physical standby

8.using real time apply

 

I got errors:

Fast Parallel Media Recovery enabled

Managed Standby Recovery starting Real Time Apply

MRP0: Background Media Recovery waiting for new incarnation during transient logical upgrade procedure

Errors in file /home/ora/app/oracle/diag/rdbms/ora11gr1dg/ora11gr1dg/trace/ora11gr1dg_mrp0_10120.trc:

ORA-19906: recovery target incarnation changed during recovery

Managed Standby Recovery not using Real Time Apply

Errors in file /home/ora/app/oracle/diag/rdbms/ora11gr1dg/ora11gr1dg/trace/ora11gr1dg_mrp0_10120.trc:

ORA-19906: recovery target incarnation changed during recovery

 

Errors appears every 10 seconds. Seems MPR0 is waiting for new incarnation for a long time. So am I.

Standby database incarnation:

List of Database Incarnations

DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1 1 ORA11GR1 3853851354 CURRENT 1 08/09/2013 01:02:18

2 2 ORA11GR1 3853851354 ORPHAN 2127877 08/28/2013 19:22:01     BGV

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points