Infrastructure at your Service

Dbvisit replicate Archives - Blog dbi services

Pierre Sicot

DBVISIT from Oracle to Postgres

By | Database Administration & Monitoring | No Comments

As I regularly work on Oracle and PostgreSQL, I decided to test the replication from Oracle to PostgreSQL using the Dbvisit Replicate tool. Dbivisit Replicate does not use Oracle logminer ot triggers but its own mining processes to get the changes when they are written to the redo logs. When a change appears in the redo log, an external file called PLOG is generated and transferred to the target. The architecture is quite easy to…

 
Read More
Franck Pachot

Dbvisit replicate when you flashback the target

By | Database Administration & Monitoring | No Comments

I had a quick question today about Dbvisit replicate as a solution to feed an Operational Data Store. The need is to run some end-of-month jobs on data from a specific state. The best way is to stop the APPLY at that fixed state for the duration of the job. Then no need for flashback query and no risk of ORA-1555. And what if we know this state only afterwards? Easy if the target is…

 
Read More
Franck Pachot

Dbvisit replicate REDO_READ_METHOD

By | Database management, Oracle | No Comments

A frequent question about replication is the overhead in the source, because in a lot of cases the source is production. Dbvisit replicate comes with the possibility to do the minimum on the source: only the FETCHER process is there to read de redo logs and sends it to the MINE process wich can be on another server. But maybe even that – reading those critical online redo logs – is worrying you. That’s not…

 
Read More
Franck Pachot

Solving customer issues at OOW14: Dbvisit Replicate can replicate tables without primary key

By | Database management, Oracle | No Comments

Usually, the logical replication of changes uses the primary key. Each row updated or deleted generate a statement to be applied on the target, which affects only one row because it accesses with the primary key. If there is no primary key, we need to have something unique and at worst it is the whole row. But sometimes old applications were designed before being implemented into relational database and have no unicity. It it a…

 
Read More
Franck Pachot

OOW14 Day 1 – Dbvisit #repattack

By | Database management, Oracle | No Comments

Oracle Open World is not only conferences but also practice and networking. Today at the OTN lounge have installed the following demos on my laptop: a Dbvisit replicate #repattack with a Delphix cloning environement #cloneattack I’ll detail the former below and the latter tomorrow, but if you are at San Francisco and missed it, please come tomorrow to the same kind of session at the Oak Table World! You don’t even need the OOW registration…

 
Read More
Franck Pachot

Oracle et Dbvisit Replicate pour migrer sans arrêt de service… et sans stress

By | Hardware & Storage, Oracle | No Comments

Je viens d’assister au Webinar Zero Downtime Migration pour Oracle, présenté par Chris Lawless qui est récemment passé de Product Manager Golden Gate à Product Manager Dbvisit.  Je vais détailler ici un point très important évoqué par Chris Lawless. La migration par réplication n’est pas seulement envisagée pour éviter un arrêt de service. Arrêt nécéssaire lors de la migration proprement dite (qui peut aller de quelques minutes à plusieurs heures en fonction de la taille…

 
Read More