2 Replies Latest reply on Jul 26, 2019 12:54 PM by CSShah

    RMAN is not deleting foreign archivelog from downstream in Oracle DB12.2

    CSShah

      Hi,

       

      We have Oracle 12.2 Source and Downstream DB .. and as per the Oracle Doc ID Golden Gate Configuration, How To Delete Archive Logs From Downstream Database (Doc ID 2011174.1)

      from DB version 12.2, RMAN will purge the archive logs shipped from Primary to Downstream automatically.

       

      But somehow, it's not working as expected.. Anyone experience the same ?

      Or have any idea how to achieve the same with RMAN !!?

       

      Br,

      Chirag

        • 1. Re: RMAN is not deleting foreign archivelog from downstream in Oracle DB12.2
          ORASCN

          Hi Chirag,

           

          Yes, this was an enhancement request which I had opened when I was in Oracle supporting for OGG product. They had included this enhancement as part of RDBMS 12.2. If this is still not working, open an SR with Oracle and check it.

           

          Are you getting any errors?

           

          Regards,

          Veera

          • 2. Re: RMAN is not deleting foreign archivelog from downstream in Oracle DB12.2
            CSShah

            Hi Veera,

             

            Okay.. Nope, we are not getting any error. Also I'm not aware whether we need special setup in RMAN to achieve this or not.

             

            I've tried by 'crosscheck foreign archivelog all;'  --> which list all foreign archive logs - shipped from Source DB to Downstream DB

            But when we execute 'list expired foreign archivlog all' or 'delete expired foreign archivelog all; ' it gives below message.

             

            RMAN> list expired foreign archivelog all;

             

            specification does not match any foreign archived log in the repository

             

             

            However, we have already created Oracle SR for the same..

             

            Br,

            Chirag