My Oracle Support Banner

Is It Possible To Replicate The DBID From A Source Database To A Target Database When Replicating Da (Doc ID 2930229.1)

Last updated on FEBRUARY 25, 2024

Applies to:

Oracle GoldenGate - Version 19.1.0.0.4 and later
Information in this document applies to any platform.

Goal



Is it possible due to a GoldenGate configuration to replicate the DBID value from a source database to a target database when replicating data?

SQL> alter session set container=<pdb name>;

Session altered.

SQL> select dbid,sql_id,plan_hash_value,operation from dba_hist_sql_plan where sql_id in ('3nz32x9gcr9w5') and plan_hash_value in (3043250274) order by dbid,sql_id,id;

  DBID SQL_ID PLAN_HASH_VALUE OPERATION
---------- ------------- --------------- ------------------------------
1879584437 3nz32x9gcr9w5 3043250274 DELETE STATEMENT
1879584437 3nz32x9gcr9w5 3043250274 DELETE
1879584437 3nz32x9gcr9w5 3043250274 COUNT
1879584437 3nz32x9gcr9w5 3043250274 HASH JOIN
1879584437 3nz32x9gcr9w5 3043250274 TABLE ACCESS
1879584437 3nz32x9gcr9w5 3043250274 TABLE ACCESS
2006906039 3nz32x9gcr9w5 3043250274 DELETE STATEMENT
2006906039 3nz32x9gcr9w5 3043250274 DELETE
2006906039 3nz32x9gcr9w5 3043250274 COUNT
2006906039 3nz32x9gcr9w5 3043250274 HASH JOIN
2006906039 3nz32x9gcr9w5 3043250274 TABLE ACCESS

  DBID SQL_ID PLAN_HASH_VALUE OPERATION
---------- ------------- --------------- ------------------------------
2006906039 3nz32x9gcr9w5 3043250274 TABLE ACCESS

12 rows selected.

SQL> select dbid from gv$database;

  DBID
----------
2006906039
2006906039
2006906039
2006906039
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.