5 Replies Latest reply on Jul 17, 2014 8:53 AM by Nip-Oracle

    v$archived_log Deleted status


      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.