[Profile Register/Log In] (What's This?)

From: "Sorrin, Eric" <Eric.Sorrin@childrenscolorado.org>
Subject: [techies] CDC
Date: Tue Jan 12 17:15:50 2016



We are looking into using CDC to populate our data warehouse.  We would like to minimize impact to our source database, which currently is not in archivelogmode.


I’ve been staring at Oracle documentation and web posts for days, and find the information confusing and conflicting.


Specifically, one source shows that database links are necessary with all but synchronous and Asynchronous Hotlog – so needed for Asynchronous Distributed Hotlog, Asynchronous Autolog online, and Asynchronous Autolog archive.  However, the Oracle documentation shows DB link only for Asynchronous Distributed Hotlog.


So, Question 1, when are db links necessary?


Next question regards archivelogmode.  We really do not want to put the source in archivelogmode.  It would seem that Asynchronous Autolog Online is the way to go to minimize impact to the source system, but also looks complicated with lots of moving pieces.  Furthermore, the Oracle documentation states “It is assumed that the database is currently running in ARCHIVELOG mode”.


So, question 2, when is it mandatory that the source DB be in archivelogmode?  It’s not needed for synchronous, obviously needed for Asynchronous Autolog archive, not so clear for the rest.


Question 3.    This regards data integrity.  What happens in all of the cases where the staging/destination reside somewhere else (Asynchronous Distributed Hotlog, Asynchronous Autolog Online, Asynchronous Autolog archive) and that database is down?  Are all of these options viable ways to ensure we will not lose data if the source is up and the destination is down?


Hopefully someone out there has struggled through this already.


Thanks in advance,


Eric Sorrin


Children’s Hospital Colorado

CONFIDENTIALITY NOTICE: This e-mail is confidential, may be legally privileged,
and for the intended recipient only. Access, disclosure, copying, forwarding and
distribution by any means is strictly prohibited. If received in error,
do not read but delete and e-mail confirmation to the sender.