Database Backup and Recovery (MOSC)

MOSC Banner

Change data capture and archivelog deletion

edited Aug 10, 2015 2:31PM in Database Backup and Recovery (MOSC) 8 commentsAnswered

Hello,

I am using a third party change data capture(CDC) product that uses archivelogs for input.  We use an Oracle 12c RAC database.  After we back up archivelogs we keep them around on disk for several backups until CDC scrapes them sequentially for transactions it wants to replicate.  There is no communication between CDC and Oracle as to when CDC has finished processing the log.  We just estimate that we are keeping the log around enough (3 log backups).  It works, but is expensive because CDC has usually processed the log long before the delete policy removes it.   I do have

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center