1 Reply Latest reply: Jan 27, 2012 4:27 AM by user11981754 RSS

    Change Data Capture reading archived redo logs?

    Stefan S
      We have configured change data capture in async hotlog mode for capturing changes from several tables.
      Everything is working fine but when i check the alertlog i see logminer reading ARCHIVED redologs.
      a) Is this normal behaviour?
      b) is RMAN aware of this? In our development environment i once deleted all archived redologs (rm...), so my streams processes couldn't find the logs anymore.


      2012-01-06 10:43:48.113000 +01:00
      Thread 1 advanced to log sequence 2938 (LGWR switch)
      Current log# 6 seq# 2938 mem# 0: /ora/redologs/inst11/redo6_1.log
      Current log# 6 seq# 2938 mem# 1: /ora/redologs/inst11/redo6_2.log
      2012-01-06 10:43:58.461000 +01:00
      Archived Log entry 2890 added for thread 1 sequence 2937 ID 0x3cdbc994 dest 1:
      2012-01-06 10:44:52.447000 +01:00
      LOGMINER: End mining logfile for session 195 thread 1 sequence 2916, /ora/archived_redologs/inst11/1_2916_743181908.dbf
      LOGMINER: Begin mining logfile for session 195 thread 1 sequence 2917, /ora/archived_redologs/inst11/1_2917_743181908.dbf
      LOGMINER: End mining logfile for session 194 thread 1 sequence 2916, /ora/archived_redologs/inst11/1_2916_743181908.dbf
      LOGMINER: Begin mining logfile for session 194 thread 1 sequence 2917, /ora/archived_redologs/inst11/1_2917_743181908.dbf
      2012-01-06 10:47:10.847000 +01:00
        • 1. Re: Change Data Capture reading archived redo logs?
          user11981754
          a) It's normal behaviour. Infact if you look at the DBA_CAPTURE you can check the columns REQUIRED_CHECKPOINT_SCN. Capture process needs all archivelogs from this SCN on.
          b) RMAN is aware of this infact if you try to delete an archivelog file needed by your capture process, rman will not delete it and will give you a warning "RMAN-08137: WARNING: archive log not deleted as it is still needed "