2 Replies Latest reply: Aug 30, 2013 10:12 AM by saurabh RSS

    Is that possible to convert logical standby to physical standby ?

    User593499-OC

      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