...
Once the above scripts are created, copy the TEST-EC2-ec2-54-82-3-111.compute-1.amazonaws.com.sh and TEST-EC2-APPLY.ddc to the ec2-54-82-3-111.compute-1.amazonaws.com server, example:as directed by the Nextsteps.txt document.
| Code Block | ||
|---|---|---|
| ||
[oracle@ ]$ scp /home/oracle/TEST/TEST-EC2-TEST-run-ec2-54-82-3-111.compute-1.amazonaws.com.sh ec2-54-82-3-111.compute-1.amazonaws.com:/home/oracle/TEST/ [oracle@ ]$ scp /home/oracle/TEST/TEST-EC2-TEST-APPLY.ddc ec2-54-82-3-111.compute-1.amazonaws.com:/home/oracle/TEST/ |
...
| Code Block | ||
|---|---|---|
| ||
SQL> create public database link XX connect to system identified by manager using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SOURCESERVER.COM)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SOURCE_DB)))';
Database link created.
SQL> select * from v$instance@SOURCE_DB;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT
----------------- --------- ------------ --- ---------- ------- ---------------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO EDITION
---------- --- ----------------- ------------------ --------- --- -------
1 SOURCE_DB
sourceserver.com
11.2.0.2.0 30-SEP-13 OPEN NO 1 STARTED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO XE
|
...
Start the import process
...
| Code Block | ||
|---|---|---|
| ||
[oracle\]$ cat APPLY.sh impdp system/xxxx@EC2_TARGET table_exists_action=TRUNCATE network_link=XEXX directory=DATA_PUMP_DIR flashback_scn=1229827 tables=SCOTT.EMP SCOTT.DEPT SCOTT.SALGRADE SCOTT.LOADTEST logfile=OE_WAREHOUSES.log JOB_NAME=DP_EC2-TEST_0001 exclude=statistics [oracle@]$ ./APPLY.sh ***GOT TO HERE**** Import: Release 11.2.0.2.0 - Production on Mon Sep 30 15:45:45 2013 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 11g Release 11.2.0.2.0 - 64bit Production Starting "DBVADMINSYSTEM"."DP_RDSPOCC_0001": dbvadminSYSTEM/********@AWSDB@EC2_TARGET table_exists_action=TRUNCATE network_link=XEXX directory=DATA_PUMP_DIR flashback_scn=1229827 tables=OESCOTT.CUSTOMERSEMP,OESCOTT.INVENTORIESDEPT,OE SCOTT.LOGONSALGRADE,OE.ORDERENTRY_METADATA,OE.ORDERS,OE.ORDER_ITEMS,OE.PRODUCT_DESCRIPTIONS,OE.PRODUCT_INFORMATION,OE.WAREHOUSES logfile=OE_WAREHOUSES.log SCOTT.LOADTEST JOB_NAME=DP_RDSPOC_0001 exclude=statistics Estimate in progress using BLOCKS method... Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 102.6 MB Processing object type TABLE_EXPORT/TABLE/TABLE . . imported "SSCOTT"."ORDER_ITEMSEMP" 120067214 rows . . imported "OESCOTT"."CUSTOMERSDEPT" 354141 rows . . imported "OE"."ORDERS" 401688 rows . . imported "OE"."INVENTORIES" 900441 rows . . imported "OE"."LOGON" 114403 rows . . imported "OE"."PRODUCT_DESCRIPTIONS" 1000 rows . . imported "OE"."PRODUCT_INFORMATION" 10004 rows . . imported "OESCOTT"."ORDERENTRY_METADATASALGRADE" 45 rows . . imported "OESCOTT"."WAREHOUSESLOADTEST" 1000 rows100 rows Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Job "DBVADMIN"."DP_RDSPOC_0001" successfully completed at 02:46:32 |
...
| Code Block | ||
|---|---|---|
| ||
[oracle@]$ ./C-run-dbvrds01TEST-EC2.sourceserver.com.sh Initializing......done [oracle@ ]$ DDC loaded from database (266 variables). Dbvisit Replicate version 2.6 Copyright (C) Dbvisit Software Limited. All rights reserved. DDC file /home/oracle/RDSPOCTEST/RDSPOCTEST=EC2-MINE.ddc loaded. Starting process MINE...Created directory /home/oracle/RDSPOCTEST/ddc_backup Created directory /home/oracle/RDSPOCTEST/log/ Created directory /home/oracle/RDSPOCTEST/log/trace/ Created directory /home/oracle/RDSPOCTEST/mine/ started |
Apply Server -
...
EC2:
| Code Block | ||
|---|---|---|
| ||
[oracle@dbvrds02 RDSPOCoracle@]$ ./RDSPOCTEST-EC2-run-dbvrds02-ec2-54-82-3-111.compute-1.amazonaws.com.sh Initializing......done DDC loaded from database (266 variables). Dbvisit Replicate version 2.5.08.33416 Copyright (C) Dbvisit Software Limited. All rights reserved. DDC file /home/oracle/RDSPOCTEST/RDSPOCTEST-EC2-APPLY.ddc loaded. Starting process APPLY...Created directory /home/oracle/RDSPOCTEST/ddc_backup Created directory /home/oracle/RDSPOCTEST/log/ Created directory /home/oracle/RDSPOCTEST/log/trace/ Created directory /home/oracle/RDSPOCTEST/apply started |
Starting the Dbvisit Replicate console
...
The console can be started from the Mine server (source) using the “start-console.sh” script
[oracle@dbvrds01 RDSPOCoracle@ ]$ ./start-console.sh
Example output can be seen below. Note that the mine and apply process does take some time to initialize.
...
The next step is to generate some load on the XE source database using swingbench. This This can be done using the generate_load script. To see the status of the replicate you can open a second terminal and open the replicate console with “start-console.sh”. Example:
...