Adding New Master Sites Without Quiescing the Master Group for Oracle10g 10.2.0.1 in CentOS 4.1 (RHEL AS 4 U1) environment
This technical exercise follows up known bug in 10.1.0.2.
All three databases are ASM in CentOS 4.1 environment
Establishing asynchronous multi-master replication between two sites completed OK.
Attempt to add third follows standard guidelines:-
Step1. Set up:
1.The replication administrator at new master site
2.A scheduled link from each existing master site to new master site
3.A scheduled link from new master site to each existing master site
4.A schedule purge job at new master site
Status OK
Step 2. CONNECT repadmin/repadmin@orcldata (MasterDef Site)
BEGIN
DBMS_REPCAT.SPECIFY_NEW_MASTERS (
gname => 'hr_repg',
master_list => 'qws3data');
END;
Status OK
Next step:-
variable masterdef_flashback_scn number;
variable extension_id varchar2(50);
BEGIN
DBMS_REPCAT.ADD_NEW_MASTERS (
export_required => true,
available_master_list => 'qws3data',
masterdef_flashback_scn => :masterdef_flashback_scn,
extension_id => : extension_id,
break_trans_to_masterdef => false,
break_trans_to_new_masters => false,
percentage_for_catchup_mdef => 80,
cycle_seconds_mdef => 60,
percentage_for_catchup_new => 80,
cycle_seconds_new => 60);
END;
PL/SQL procedure completed OK
select count(*) from DBA_REPCATLOG;
gives "0"
Create a directory object at each database.
CONNECT SYSTEM/drbrxa@qws3data;
CREATE DIRECTORY DPUMP_DIR AS '/usr/dpump_dir';
CONNECT SYSTEM/drbrxa@orcldata;
CREATE DIRECTORY DPUMP_DIR AS '/usr/dpump_dir';
Perform object-level export of tables at master definition database.
SELECT FLASHBACK_SCN FROM DBA_REPEXTENSIONS;
497533
$export ORACLE_SID=orcldata
$expdp system/drbrxa TABLES=SCOTT.DEPT,SCOTT.EMP,DIRECTORY=DPUMP_DIR
DUMPFILE=scott_tables.dmp CONTENT=data_only FLASHBACK_SCN=497533
Resume propagation at the master definition site.
CONNECT repadmin/repadmin@orcldata; (MasterDef Site)
BEGIN
DBMS_REPCAT.RESUME_PROPAGATION_TO_MDEF (
extension_id => :extension_id);
END;
Transfer the export dump files to the new master site.
Perform object-level import at new master site.
$export ORACLE_SID=qws3data
$impdp system/drbrxa TABLES=SCOTT.DEPT,SCOTT.EMP, DIRECTORY=DPUMP_DIR
DUMPFILE=scott_tables.dmp CONTENT=data_only TABLE_EXISTS_ACTION=append
Allow new masters to receive deferred transactions.
CONNECT repadmin/repadmin@qws3data; (Newly added site)
BEGIN
DBMS_REPCAT.PREPARE_INSTANTIATED_MASTER (
extension_id => :extension_id);
END;
