5 Replies Latest reply: Jul 17, 2014 3:53 AM by Nip-Oracle RSS

    v$archived_log Deleted status

    891445

      I am trying to get the Archive deletion status of standby on Primary side. But it is not reflecting the status propery.

       

      (on primary)

      Select Name,Deleted from v$archived_log where dest_id=2;

       

      On standby, we are deleting the applied Archives using rman command.

      On primary, the deleted status is always NO for dest_id 2, in spite of deleted arcs on standby.

       

      I don't know if this is the correct way.