Appendix B. DDL order when using oraAdapter

DDL execution order when using oraAdapter

When using oraAdapter, DDL that is performing replication must be executed in the following order.

No	Active Server	oraAdapter	Standby Server
1. Create schema on both servers	CREATE TABLE T1 ( C1 INTEGER PRIMARY KEY, C2 SMALLINT );		CREATE TABLE T1 ( C1 INTEGER PRIMARY KEY, C2 SMALLINT );
2 Creating replication with .ANALYSIS	CREATE REPLICATION ala FOR ANALYSIS WITH 'Standby IP', Standby Port FROM SYS.T1 TO SYS T1;
3. Start oraAdapter		$ oaUtility start
4. Start replication	ALTER REPLICATION ala START;
5. Flush syntax to remove replicaiton gaps	ALTER REPLICATION ALA FLUSH ALL;
6. Set property values related to replication for DDL execution	ALTER SYSTEM SET REPLICATION_DDL_ENABLE = 1;   ALTER SYSTEM SET REPLICATION_DDL_ENABLE_LEVEL = 1;
7. Execute DDL on the active server		Adapter termination (due to DDL log processing)
8. Check the oraAdapter trc log	SELECT REP_NAME, STATUS FROM V$REPSENDER; Check with STATUS to 2	'Log Record : Meta change xlog was arrived, adapter will be finished' Check trc log messages
9. Execute DDL on the standby server			DDL
10. Restart oraAdapter		$ oaUtility start
11. Stop and restart replication (optional)	(optional) ALTER REPLICATION ALA STOP; ALTER REPLICATION ALA START;
12. Check for data replication	DML ( Service )		Verify data replication
13. Setting property values related to replication to stop DDL	ALTER SYSTEM SET REPLICATION_DDL_ENABLE = 0; ALTER SYSTEM SET REPLICATION_DDL_ENABLE_LEVEL = 0;