Removing Advanced Replication in preparation for 11g to 19c upgrade

From: Leng Burgess <lkaing_at_gmail.com>
Date: Tue, 4 Jan 2022 16:27:34 +1100
Message-Id: <F7390FF5-C15F-4728-B57D-D26E010E6D5F_at_gmail.com>

Happy New Year, listers,

How did you go about removing advanced replication from your 11g databases in preparation for upgrading to 19c?

I’ve been told that the advanced replication is no longer in use in our databases but I’d to know that I won’t hit an issue during an upgrade that will force me to rollback the upgrade. How does DBUA deal with Oracle advanced replication? Does it simply call a script to drop the advanced replication views?

Is there an equivalent of emremove.sql for advanced replication that we can run first before upgrading?

I’ve run the following queries and only dba_repconflict returned  4 rows. The other views returned no rows.

Would the upgrade with DBUA work? Or will I still need to resolve the repconflicsts listed below. Given that there are no rows returned from the other views, how do I purge/remove theses conflicts? Sorry it's been a LONG time since I've really had anything to do with advanced replication.

set echo on

select * from DBA_REPSITES;
select * from DBA_REPGROUP;
select * from DBA_REPOBJECT;
select * from DBA_REPCONFLICT;
select * from DBA_REPCATLOG ;
select * from dba_repcat;
select * from DEFTRAN;
select * from  DEFERROR;
select * from DEFERRCOUNT;

select count(*) from defcall;
select count(*) from deftrandest;

select * from dba_represolution_method;
select * from dba_repcolumn_group;
select * from dba_repgrouped_column;
select * from dba_repparameter_column;
select * from dba_represolution_statistics;
select * from dba_repprop;

SELECT to_char(timestamp, 'DD Mon HH24:MI') timestamp, request, status, message   FROM sys.dba_repcatlog ORDER BY timestamp;

sql> select * from DBA_REPCONFLICT;

SNAME                          ONAME                          CONFLICT_T REFERENCE_NAME
------------------------------ ------------------------------ ---------- ------------------------------
DICT                           STATION_ALIAS_TB               UPDATE     epoch
DICT                           STATION_LOG_TB                 UPDATE     epoch
DICT                           STATION_REPL_TB                UPDATE     epoch
DICT                           STATION_TB                     UPDATE     epoch

Thanks in advance,

Leng.--
http://www.freelists.org/webpage/oracle-l Received on Tue Jan 04 2022 - 06:27:34 CET