we are in the process of migrating the database from one data center to other using DR method. After migration we are converting non-cdb to cdb database.
There are 2 databases involved in this and we have a replication between these 2 db's using ogg. There are set of tables which i need to ensure are in Sync in both the tables which are part of ogg replication. There are some dbms jobs which might update them and can make the tables go out of sync between source and target during this migration, causing the OGG replication to be in jeoparty requiring initial loading.
During cutover from source, can i disable dbms jobs ie before cutover on source and ensure that no dbms jobs is running causing mismatch in table data ?
i was thinking of making job_queue_process 0 in source and target both to ensure no data changes happen until we setup OGG replication in new environment
is this approach correct.