DGMGRL> set trace_level support DGMGRL> ADD PLUGGABLE DATABASE pdbdc2 AT oradbdc1 SOURCE IS pdbdc2 AT oradbdc2 PDBFILENAMECONVERT IS "'oradbdc2/pdbdc2','oradbdc1/pdbdc2'"; [W000 2022-08-02T22:14:41.593+02:00] DGCI for database oradbdc2 is oradbdc2 [W000 2022-08-02T22:14:41.593+02:00] DGCI for database oradbdc1 is oradbdc1 [W000 2022-08-02T22:14:41.593+02:00] Executing query [SELECT db_unique_name FROM v$database]. [W000 2022-08-02T22:14:41.602+02:00] Query result is 'oradbdc1' [W000 2022-08-02T22:14:41.602+02:00] Connected to target database oradbdc1 [W000 2022-08-02T22:14:41.602+02:00] Executing query [SELECT count(*) FROM v$pdbs WHERE name='PDBDC2']. [W000 2022-08-02T22:14:41.605+02:00] Query result is '0' [W000 2022-08-02T22:14:41.605+02:00] Given PDB PDBDC2 does not exist at this database [W000 2022-08-02T22:14:41.605+02:00] Executing query [SELECT count(*) FROM container$ WHERE status=9]. [W000 2022-08-02T22:14:41.606+02:00] Query result is '0' [W000 2022-08-02T22:14:41.606+02:00] PDBs of type 2 does not exist at this database [W000 2022-08-02T22:14:41.606+02:00] Executing query [SELECT dbid FROM v$database]. [W000 2022-08-02T22:14:41.614+02:00] Query result is '2977563181' [W000 2022-08-02T22:14:41.614+02:00] DBID of target is 2977563181 [W000 2022-08-02T22:14:41.614+02:00] Verifying credential DGPDB_TO_ORADBDC1 at db oradbdc2 with CI oradbdc2 [W000 2022-08-02T22:14:41.614+02:00] Connect to database oradbdc2 using oradbdc2 [W000 2022-08-02T22:14:41.614+02:00] Connecting to database using oradbdc2. [W000 2022-08-02T22:14:41.614+02:00] Attempting to attach to oradbdc2 [W000 2022-08-02T22:14:41.633+02:00] Attempting logon as SYSDBA [W000 2022-08-02T22:14:41.757+02:00] Successfully logged on as SYSDBA [W000 2022-08-02T22:14:41.757+02:00] Executing query [select sys_context('USERENV','CON_ID') from dual]. [W000 2022-08-02T22:14:41.758+02:00] Query result is '1' [W000 2022-08-02T22:14:41.758+02:00] Executing query [select value from v$parameter where name = 'db_unique_name']. [W000 2022-08-02T22:14:41.762+02:00] Query result is 'oradbdc2' [W000 2022-08-02T22:14:41.762+02:00] Executing query [SELECT instance_name from v$instance]. [W000 2022-08-02T22:14:41.763+02:00] Query result is 'oradbdc22' [W000 2022-08-02T22:14:41.763+02:00] Connected to instance oradbdc22 of oradbdc2. Connected to "oradbdc2" [W000 2022-08-02T22:14:41.763+02:00] Checking broker version [BEGIN :version := dbms_drs.dg_broker_info('VERSION'); END;]. [W000 2022-08-02T22:14:41.764+02:00] Oracle database version is '21.7.0.0.0' [W000 2022-08-02T22:14:41.764+02:00] Connected to database 'oradbdc2' [W000 2022-08-02T22:14:41.764+02:00] Executing query [SELECT count(*) FROM v$pdbs WHERE name='PDBDC2']. [W000 2022-08-02T22:14:41.764+02:00] Query result is '1' [W000 2022-08-02T22:14:41.765+02:00] Executing query [SELECT count(*) FROM container$ c, v$pdbs p WHERE c.status=9 AND c.con_id#=p.con_id AND p.name='PDBDC2']. [W000 2022-08-02T22:14:41.766+02:00] Query result is '0' [W000 2022-08-02T22:14:41.766+02:00] Executing query [SELECT count(*) FROM container$ c, ropp$x$pdbhistory r, dgpdb_site$ dp, data_guard_site$ dg, v$pdbs p WHERE bitand(r.flags,1)=1 AND c.status!=9 AND dp.cdbdbid=dg.cdbdbid AND r.local_pdbid=c.con_id# AND r.local_pdbid=dp.con_id AND r.local_pdbid=p.con_id AND p.name='PDBDC2']. [W000 2022-08-02T22:14:41.769+02:00] Query result is '0' [W000 2022-08-02T22:14:41.769+02:00] Executing query [SELECT value FROM x$drc WHERE attribute='DRC']. [W000 2022-08-02T22:14:41.779+02:00] Query result is 'dc2' [W000 2022-08-02T22:14:41.779+02:00] Config name: dc2, len: 3 [W000 2022-08-02T22:14:41.779+02:00] Executing query [SELECT count(*) FROM dba_credentials WHERE username='DGPDB_INT' AND credential_name='DGPDB_TO_ORADBDC1']. [W000 2022-08-02T22:14:41.781+02:00] Query result is '0' [W000 2022-08-02T22:14:41.781+02:00] DGPDB_TO_ORADBDC1 credential does not exist at database oradbdc2; [W000 2022-08-02T22:14:41.781+02:00] Verifying DGPDB_INT setup at database 'oradbdc2' [W000 2022-08-02T22:14:41.781+02:00] Executing query [SELECT count(*) FROM dba_users WHERE username='DGPDB_INT' AND account_status='OPEN']. [W000 2022-08-02T22:14:41.783+02:00] Query result is '0' Enter password for DGPDB@oradbdc2: [W000 2022-08-02T22:14:46.483+02:00] DGPDB_INT account at database oradbdc2 must be unlocked... [W000 2022-08-02T22:14:46.483+02:00] Executing statement [ALTER USER DGPDB_INT IDENTIFIED BY oracle ACCOUNT UNLOCK]. [W000 2022-08-02T22:14:47.070+02:00] Statement [ALTER USER DGPDB_INT IDENTIFIED BY oracle ACCOUNT UNLOCK] executed successfully. [W000 2022-08-02T22:14:47.070+02:00] creating DGPDB_TO_ORADBDC1 credential at database oradbdc2; [W000 2022-08-02T22:14:47.070+02:00] Executing statement [begin dbms_credential.create_credential('DGPDB_TO_ORADBDC1','DGPDB_INT','oracle'); end;]. [W000 2022-08-02T22:14:47.092+02:00] Statement [begin dbms_credential.create_credential('DGPDB_TO_ORADBDC1','DGPDB_INT','oracle'); end;] executed successfully. [W000 2022-08-02T22:14:47.092+02:00] Executing statement [ALTER SESSION SET CONTAINER=PDBDC2]. [W000 2022-08-02T22:14:47.101+02:00] Statement [ALTER SESSION SET CONTAINER=PDBDC2] executed successfully. [W000 2022-08-02T22:14:47.101+02:00] Executing statement [GRANT SYSDG to DGPDB_INT container=current]. [W000 2022-08-02T22:14:47.165+02:00] Statement [GRANT SYSDG to DGPDB_INT container=current] executed successfully. [W000 2022-08-02T22:14:47.165+02:00] Executing statement [ALTER SESSION SET CONTAINER=CDB$ROOT]. [W000 2022-08-02T22:14:47.166+02:00] Statement [ALTER SESSION SET CONTAINER=CDB$ROOT] executed successfully. [W000 2022-08-02T22:14:47.166+02:00] Executing statement [GRANT execute on DGPDB_TO_ORADBDC1 to DGPDB_INT]. [W000 2022-08-02T22:14:47.189+02:00] Statement [GRANT execute on DGPDB_TO_ORADBDC1 to DGPDB_INT] executed successfully. [W000 2022-08-02T22:14:47.189+02:00] Executing query [SELECT dbid FROM v$database]. [W000 2022-08-02T22:14:47.204+02:00] Query result is '3458508890' [W000 2022-08-02T22:14:47.204+02:00] DBID of source is 3458508890 [W000 2022-08-02T22:14:47.204+02:00] Executing query [SELECT count(*) FROM data_guard_site$ WHERE cdbdbid=2977563181 AND db_unique_name='oradbdc1' AND connect_identifier='oradbdc1']. [W000 2022-08-02T22:14:47.206+02:00] Query result is '0' [W000 2022-08-02T22:14:47.206+02:00] sql to update dgs table at oradbdc2 is [INSERT INTO data_guard_site$ (cdbdbid, db_unique_name, connect_identifier) VALUES (2977563181,'oradbdc1','oradbdc1')] [W000 2022-08-02T22:14:47.206+02:00] Executing statement [INSERT INTO data_guard_site$ (cdbdbid, db_unique_name, connect_identifier) VALUES (2977563181,'oradbdc1','oradbdc1')]. [W000 2022-08-02T22:14:47.213+02:00] Statement [INSERT INTO data_guard_site$ (cdbdbid, db_unique_name, connect_identifier) VALUES (2977563181,'oradbdc1','oradbdc1')] executed successfully. [W000 2022-08-02T22:14:47.213+02:00] Executing statement [commit]. [W000 2022-08-02T22:14:47.213+02:00] Statement [commit] executed successfully. [W000 2022-08-02T22:14:47.213+02:00] Verifying credential DGPDB_TO_ORADBDC2 at db oradbdc1 with CI oradbdc1 [W000 2022-08-02T22:14:47.213+02:00] Connect to database oradbdc1 using oradbdc1 [W000 2022-08-02T22:14:47.215+02:00] Connecting to database using oradbdc1. [W000 2022-08-02T22:14:47.215+02:00] Attempting to attach to oradbdc1 [W000 2022-08-02T22:14:47.234+02:00] Attempting logon as SYSDBA [W000 2022-08-02T22:14:47.363+02:00] Successfully logged on as SYSDBA [W000 2022-08-02T22:14:47.363+02:00] Executing query [select sys_context('USERENV','CON_ID') from dual]. [W000 2022-08-02T22:14:47.363+02:00] Query result is '1' [W000 2022-08-02T22:14:47.363+02:00] Executing query [select value from v$parameter where name = 'db_unique_name']. [W000 2022-08-02T22:14:47.368+02:00] Query result is 'oradbdc1' [W000 2022-08-02T22:14:47.368+02:00] Executing query [SELECT instance_name from v$instance]. [W000 2022-08-02T22:14:47.368+02:00] Query result is 'oradbdc12' [W000 2022-08-02T22:14:47.368+02:00] Connected to instance oradbdc12 of oradbdc1. Connected to "oradbdc1" [W000 2022-08-02T22:14:47.368+02:00] Checking broker version [BEGIN :version := dbms_drs.dg_broker_info('VERSION'); END;]. [W000 2022-08-02T22:14:47.369+02:00] Oracle database version is '21.7.0.0.0' [W000 2022-08-02T22:14:47.369+02:00] Connected to database 'oradbdc1' [W000 2022-08-02T22:14:47.369+02:00] Executing query [SELECT value FROM x$drc WHERE attribute='DRC']. [W000 2022-08-02T22:14:47.374+02:00] Query result is 'dc1' [W000 2022-08-02T22:14:47.374+02:00] Config name: dc1, len: 3 [W000 2022-08-02T22:14:47.374+02:00] Executing query [SELECT count(*) FROM dba_credentials WHERE username='DGPDB_INT' AND credential_name='DGPDB_TO_ORADBDC2']. [W000 2022-08-02T22:14:47.376+02:00] Query result is '1' [W000 2022-08-02T22:14:47.376+02:00] DGPDB_TO_ORADBDC2 credential already exists at database oradbdc1! [W000 2022-08-02T22:14:47.376+02:00] Executing statement [GRANT execute on DGPDB_TO_ORADBDC2 to DGPDB_INT]. [W000 2022-08-02T22:14:47.416+02:00] Statement [GRANT execute on DGPDB_TO_ORADBDC2 to DGPDB_INT] executed successfully. [W000 2022-08-02T22:14:47.416+02:00] Executing query [SELECT count(*) FROM data_guard_site$ WHERE cdbdbid=3458508890 AND db_unique_name='oradbdc2' AND connect_identifier='oradbdc2']. [W000 2022-08-02T22:14:47.417+02:00] Query result is '1' [W000 2022-08-02T22:14:47.417+02:00] data_guard_site table at oradbdc1 contains target information [W000 2022-08-02T22:14:47.417+02:00] Executing statement [create pluggable database PDBDC2 as standby from PDBDC2 at oradbdc2 file_name_convert=('oradbdc2/pdbdc2','oradbdc1/pdbdc2') ]. [W000 2022-08-02T22:14:50.800+02:00] ORA-17628: Oracle error 11402 returned by remote Oracle server ORA-11402: Oracle Data Guard site entry not found ORA-17628: Oracle error 11402 returned by remote Oracle server ORA-11402: Oracle Data Guard site entry not found [W000 2022-08-02T22:14:50.800+02:00] Error executing create pluggable database PDBDC2 as standby from PDBDC2 at oradbdc2 file_name_convert=('oradbdc2/pdbdc2','oradbdc1/pdbdc2') ; status -1 Failed. DGMGRL> DGMGRL> ADD PLUGGABLE DATABASE pdbdc2 AT oradbdc1 SOURCE IS pdbdc2 AT oradbdc2 PDBFILENAMECONVERT IS "'oradbdc2/pdbdc2','oradbdc1/pdbdc2'"; [W000 2022-08-02T22:14:59.958+02:00] DGCI for database oradbdc2 is oradbdc2 [W000 2022-08-02T22:14:59.958+02:00] DGCI for database oradbdc1 is oradbdc1 [W000 2022-08-02T22:14:59.958+02:00] Executing query [SELECT db_unique_name FROM v$database]. [W000 2022-08-02T22:14:59.967+02:00] Query result is 'oradbdc1' [W000 2022-08-02T22:14:59.967+02:00] Connected to target database oradbdc1 [W000 2022-08-02T22:14:59.967+02:00] Executing query [SELECT count(*) FROM v$pdbs WHERE name='PDBDC2']. [W000 2022-08-02T22:14:59.968+02:00] Query result is '0' [W000 2022-08-02T22:14:59.968+02:00] Given PDB PDBDC2 does not exist at this database [W000 2022-08-02T22:14:59.968+02:00] Executing query [SELECT count(*) FROM container$ WHERE status=9]. [W000 2022-08-02T22:14:59.969+02:00] Query result is '0' [W000 2022-08-02T22:14:59.969+02:00] PDBs of type 2 does not exist at this database [W000 2022-08-02T22:14:59.969+02:00] Executing query [SELECT dbid FROM v$database]. [W000 2022-08-02T22:14:59.979+02:00] Query result is '2977563181' [W000 2022-08-02T22:14:59.979+02:00] DBID of target is 2977563181 [W000 2022-08-02T22:14:59.979+02:00] Verifying credential DGPDB_TO_ORADBDC1 at db oradbdc2 with CI oradbdc2 [W000 2022-08-02T22:14:59.979+02:00] Connect to database oradbdc2 using oradbdc2 [W000 2022-08-02T22:14:59.979+02:00] Connecting to database using oradbdc2. [W000 2022-08-02T22:14:59.979+02:00] Attempting to attach to oradbdc2 [W000 2022-08-02T22:14:59.996+02:00] Attempting logon as SYSDBA [W000 2022-08-02T22:15:00.130+02:00] Successfully logged on as SYSDBA [W000 2022-08-02T22:15:00.130+02:00] Executing query [select sys_context('USERENV','CON_ID') from dual]. [W000 2022-08-02T22:15:00.130+02:00] Query result is '1' [W000 2022-08-02T22:15:00.130+02:00] Executing query [select value from v$parameter where name = 'db_unique_name']. [W000 2022-08-02T22:15:00.135+02:00] Query result is 'oradbdc2' [W000 2022-08-02T22:15:00.135+02:00] Executing query [SELECT instance_name from v$instance]. [W000 2022-08-02T22:15:00.135+02:00] Query result is 'oradbdc21' [W000 2022-08-02T22:15:00.135+02:00] Connected to instance oradbdc21 of oradbdc2. Connected to "oradbdc2" [W000 2022-08-02T22:15:00.136+02:00] Checking broker version [BEGIN :version := dbms_drs.dg_broker_info('VERSION'); END;]. [W000 2022-08-02T22:15:00.136+02:00] Oracle database version is '21.7.0.0.0' [W000 2022-08-02T22:15:00.136+02:00] Connected to database 'oradbdc2' [W000 2022-08-02T22:15:00.136+02:00] Executing query [SELECT count(*) FROM v$pdbs WHERE name='PDBDC2']. [W000 2022-08-02T22:15:00.137+02:00] Query result is '1' [W000 2022-08-02T22:15:00.137+02:00] Executing query [SELECT count(*) FROM container$ c, v$pdbs p WHERE c.status=9 AND c.con_id#=p.con_id AND p.name='PDBDC2']. [W000 2022-08-02T22:15:00.138+02:00] Query result is '0' [W000 2022-08-02T22:15:00.138+02:00] Executing query [SELECT count(*) FROM container$ c, ropp$x$pdbhistory r, dgpdb_site$ dp, data_guard_site$ dg, v$pdbs p WHERE bitand(r.flags,1)=1 AND c.status!=9 AND dp.cdbdbid=dg.cdbdbid AND r.local_pdbid=c.con_id# AND r.local_pdbid=dp.con_id AND r.local_pdbid=p.con_id AND p.name='PDBDC2']. [W000 2022-08-02T22:15:00.142+02:00] Query result is '0' [W000 2022-08-02T22:15:00.142+02:00] Executing query [SELECT value FROM x$drc WHERE attribute='DRC']. [W000 2022-08-02T22:15:00.145+02:00] Query result is 'dc2' [W000 2022-08-02T22:15:00.145+02:00] Config name: dc2, len: 3 [W000 2022-08-02T22:15:00.145+02:00] Executing query [SELECT count(*) FROM dba_credentials WHERE username='DGPDB_INT' AND credential_name='DGPDB_TO_ORADBDC1']. [W000 2022-08-02T22:15:00.150+02:00] Query result is '1' [W000 2022-08-02T22:15:00.150+02:00] DGPDB_TO_ORADBDC1 credential already exists at database oradbdc2! [W000 2022-08-02T22:15:00.150+02:00] Executing statement [ALTER SESSION SET CONTAINER=PDBDC2]. [W000 2022-08-02T22:15:00.152+02:00] Statement [ALTER SESSION SET CONTAINER=PDBDC2] executed successfully. [W000 2022-08-02T22:15:00.152+02:00] Executing statement [GRANT SYSDG to DGPDB_INT container=current]. [W000 2022-08-02T22:15:00.233+02:00] Statement [GRANT SYSDG to DGPDB_INT container=current] executed successfully. [W000 2022-08-02T22:15:00.233+02:00] Executing statement [ALTER SESSION SET CONTAINER=CDB$ROOT]. [W000 2022-08-02T22:15:00.234+02:00] Statement [ALTER SESSION SET CONTAINER=CDB$ROOT] executed successfully. [W000 2022-08-02T22:15:00.234+02:00] Executing statement [GRANT execute on DGPDB_TO_ORADBDC1 to DGPDB_INT]. [W000 2022-08-02T22:15:00.254+02:00] Statement [GRANT execute on DGPDB_TO_ORADBDC1 to DGPDB_INT] executed successfully. [W000 2022-08-02T22:15:00.254+02:00] Executing query [SELECT dbid FROM v$database]. [W000 2022-08-02T22:15:00.261+02:00] Query result is '3458508890' [W000 2022-08-02T22:15:00.261+02:00] DBID of source is 3458508890 [W000 2022-08-02T22:15:00.261+02:00] Executing query [SELECT count(*) FROM data_guard_site$ WHERE cdbdbid=2977563181 AND db_unique_name='oradbdc1' AND connect_identifier='oradbdc1']. [W000 2022-08-02T22:15:00.262+02:00] Query result is '1' [W000 2022-08-02T22:15:00.262+02:00] data_guard_site table at oradbdc2 contains target information [W000 2022-08-02T22:15:00.262+02:00] Verifying credential DGPDB_TO_ORADBDC2 at db oradbdc1 with CI oradbdc1 [W000 2022-08-02T22:15:00.262+02:00] Connect to database oradbdc1 using oradbdc1 [W000 2022-08-02T22:15:00.268+02:00] Connecting to database using oradbdc1. [W000 2022-08-02T22:15:00.268+02:00] Attempting to attach to oradbdc1 [W000 2022-08-02T22:15:00.284+02:00] Attempting logon as SYSDBA [W000 2022-08-02T22:15:00.567+02:00] Successfully logged on as SYSDBA [W000 2022-08-02T22:15:00.567+02:00] Executing query [select sys_context('USERENV','CON_ID') from dual]. [W000 2022-08-02T22:15:00.567+02:00] Query result is '1' [W000 2022-08-02T22:15:00.567+02:00] Executing query [select value from v$parameter where name = 'db_unique_name']. [W000 2022-08-02T22:15:00.571+02:00] Query result is 'oradbdc1' [W000 2022-08-02T22:15:00.571+02:00] Executing query [SELECT instance_name from v$instance]. [W000 2022-08-02T22:15:00.571+02:00] Query result is 'oradbdc11' [W000 2022-08-02T22:15:00.571+02:00] Connected to instance oradbdc11 of oradbdc1. Connected to "oradbdc1" [W000 2022-08-02T22:15:00.571+02:00] Checking broker version [BEGIN :version := dbms_drs.dg_broker_info('VERSION'); END;]. [W000 2022-08-02T22:15:00.572+02:00] Oracle database version is '21.7.0.0.0' [W000 2022-08-02T22:15:00.572+02:00] Connected to database 'oradbdc1' [W000 2022-08-02T22:15:00.572+02:00] Executing query [SELECT value FROM x$drc WHERE attribute='DRC']. [W000 2022-08-02T22:15:00.580+02:00] Query result is 'dc1' [W000 2022-08-02T22:15:00.580+02:00] Config name: dc1, len: 3 [W000 2022-08-02T22:15:00.580+02:00] Executing query [SELECT count(*) FROM dba_credentials WHERE username='DGPDB_INT' AND credential_name='DGPDB_TO_ORADBDC2']. [W000 2022-08-02T22:15:00.581+02:00] Query result is '1' [W000 2022-08-02T22:15:00.581+02:00] DGPDB_TO_ORADBDC2 credential already exists at database oradbdc1! [W000 2022-08-02T22:15:00.581+02:00] Executing statement [GRANT execute on DGPDB_TO_ORADBDC2 to DGPDB_INT]. [W000 2022-08-02T22:15:00.633+02:00] Statement [GRANT execute on DGPDB_TO_ORADBDC2 to DGPDB_INT] executed successfully. [W000 2022-08-02T22:15:00.633+02:00] Executing query [SELECT count(*) FROM data_guard_site$ WHERE cdbdbid=3458508890 AND db_unique_name='oradbdc2' AND connect_identifier='oradbdc2']. [W000 2022-08-02T22:15:00.635+02:00] Query result is '1' [W000 2022-08-02T22:15:00.635+02:00] data_guard_site table at oradbdc1 contains target information [W000 2022-08-02T22:15:00.635+02:00] Executing statement [create pluggable database PDBDC2 as standby from PDBDC2 at oradbdc2 file_name_convert=('oradbdc2/pdbdc2','oradbdc1/pdbdc2') ]. [W000 2022-08-02T22:15:06.903+02:00] Statement [create pluggable database PDBDC2 as standby from PDBDC2 at oradbdc2 file_name_convert=('oradbdc2/pdbdc2','oradbdc1/pdbdc2') ] executed successfully. Pluggable Database "PDBDC2" added [W000 2022-08-02T22:15:06.903+02:00] Setting redo transport from dc2 to dc1 [W000 2022-08-02T22:15:06.903+02:00] Redo transport between configs [BEGIN :status := DBMS_DRS.SET_CONFIGURATION_SOURCE('dc2', 'dc1', FALSE); END;]. DGMGRL>