What is Data instantiation
...
This database link is needed for the Datapump script that is created as APPLY.sh. The content of datapump script APPLY.sh is similar to :the following. DO NOT COPY THE CONTENT. This is just an example.
| No Format |
|---|
impdp SYSTEM/oracle@ttorcl_trg table_exists_action=TRUNCATE network_link=ttorcl_src directory=ttorcl_trg_DATA_PUMP_DIR flashback_scn=31442043046186 tables=OE.ADDRESSES,OE.CARD_DETAILS,OE.CMP3$95780,OE.CMP4$95780,OE.CUSTOMERS,OE.INVENTORIES,OE.LOGON,OE.ORDERENTRY_METADATA,OE.ORDERS,OE.ORDER_ITEMS,OE.PRODUCT_DESCRIPTIONS,OE.PRODUCT_INFORMATION,OE.PROMOTIONS,OE.WAREHOUSES logfile=OE_WAREHOUSES.log JOB_NAME=DP_dbvrep_orcl_0001 |
The flashback_scn number (in this case 3144204case3046186) determines the consistency point as to where the data will be loaded to. All data prior to this SCN will be loaded using the above DataPump script. All data past this SCN will be replicated using Dbvisit Replicate.
3. On the source server (dbv01) start the APPLY.sh script. This script will take approximately 5 - 25 minutes to complete.
| No Format |
|---|
cd ~oracle/dbvrep_orcl |
a. Run the script
| No Format |
|---|
./APPLY.sh
|
The output will be similar to:
| No Format |
|---|
Import: Release 12.1.0.1.0 - Production on Fri Aug 1 05:31:43 2014 Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options Starting "SYSTEM"."DP_DBVREP_ORCL_0001": SYSTEM/********@ttorcl_trg table_exists_action=TRUNCATE network_link=ttorcl_src directory=ttorcl_trg_DATA_PUMP_DIR flashback_scn=31442043046186 tables=OE.ADDRESSES,OE.CARD_DETAILS,OE.CMP35780,OE.CMP45780,OE.CUSTOMERS,OE.INVENTORIES,OE.LOGON,OE.ORDERENTRY_METADATA,OE.ORDERS,OE.ORDER_ITEMS,OE.PRODUCT_DESCRIPTIONS,OE.PRODUCT_INFORMATION,OE.PROMOTIONS,OE.WAREHOUSES logfile=OE_WAREHOUSES.log JOB_NAME=DP_dbvrep_orcl_0001 Estimate in progress using BLOCKS method... Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 1.016 GB Processing object type TABLE_EXPORT/TABLE/TABLE Table "OE"."PROMOTIONS" exists and has been truncated. Data will be loaded but all dependent metadata will be skipped due to table_exists_action of truncate . . imported "OE"."ORDER_ITEMS" 4291621 rows . . imported "OE"."INVENTORIES" 899846 rows . . imported "OE"."ORDERS" 1430027 rows . . imported "OE"."ADDRESSES" 1500112 rows . . imported "OE"."CUSTOMERS" 1000103 rows . . imported "OE"."CARD_DETAILS" 1500103 rows . . imported "OE"."LOGON" 2383613 rows . . imported "OE"."PRODUCT_DESCRIPTIONS" 1000 rows . . imported "OE"."PRODUCT_INFORMATION" 1000 rows . . imported "OE"."ORDERENTRY_METADATA" 4 rows . . imported "OE"."WAREHOUSES" 1000 rows . . imported "OE"."PROMOTIONS" 0 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/INDEX/FUNCTIONAL_INDEX/INDEX Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER ORA-39166: Object OE.CMP35780 was not found. ORA-39166: Object OE.CMP45780 was not found. Job "SYSTEM"."DP_DBVREP_ORCL_0001" completed with 2 error(s) at Fri Aug 1 05:38:02 2014 elapsed 0 00:06:14 [oracle@source dbvrep_orcl]$ successfully completed |
| Note | ||
|---|---|---|
During the import of the data, the archiver may become stuck because there may not be enough space. Run the following script a few times on the target server (dbv02) to ensure that the flash recovery area does not fill up and pause the import:
|