Example
Once confirm that no transactions are pending on the source database and all the tables to be replicated are idle, get the current SCN.In section 2 of the Setup Wizard there is a question about what data instantiation script to create. One of the choices available is called 'load'. The option for load will not create a script. A second question will be asked regarding if you want to keep the table on the target or create it anew. By choosing this method Replicate will automatically load the data when you start up the MINE process and APPLY process, no export/import or additional scripts are needed.
Example
| No Format | ||
|---|---|---|
| ||
Lock and copy the data initially one-by-one or at a single SCN? one-by-one : Lock tables one by one and capture SCN single-scn : One SCN for all tables ddl-only : Only DDL script for target objects resetlogs : Use SCN from last resetlogs operation (standby activation, rman incomplete recovery) (one-by-one/single-scn/ddl-only/resetlogs) [single-scn] What data instantiation script to create? dp_networklink : Data Pump with network link. No export datafile is created (APPLY.sh) dp_exp : Data Pump with export datafile. Creates an export datafile (APPLY.sh) exp : Pre-datapump exp/imp with export datafile (APPLY.sh) ddl_file : DDL file created (APPLY.sql) ddl_run : DDL is automatically executed on target load : All replicated data is created and loaded automatically none (dp_networklink/dp_exp/exp/ddl_file/ddl_run/load/none) [dp_networklink] load Do you want to (re-)create the tables on target or keep them (they are already created)? (create/keep) [keep] create |
| Note |
|---|
You can either lock the table or ensure in other ways (like application downtime) that no transactions are pending on the tables as of the SCN because pending and non-committed transactions would be lost. |
3. Recover standby database up to that SCN and then activate it.If there are columns in the tables that contain datatypes that are not currently supported, you are replicating they will automatically be excluded from that load utility. You will see warning messages like this:
| No Format | ||
|---|---|---|
| ||
SQL>dbvrep> recoverPREPARE standbyOFFLINE databaseSCHEMA until"SCOTT" changeTable 1094745 ORA-00279: change 1094505 generated at 06/21/2013 17:37:11 needed for thread 1 ORA-00289: suggestion : /u01/app/oracle/oraarch/reptest2/1_38_818678256.dbf ORA-00280: change 1094505 for thread 1 is in sequence #38 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} /u01/app/oracle/oraarch/reptest2/o1_mf_1_38_8w7spsss_.arc Log applied. Media recovery complete. SQL> alter database activate standby database; Database altered. SQL> alter database open; Database altered. |
4. Now, you can configure Dbvisit Replicate by running setup wizard normally on the source server. Select 'resetlogs' as data instantiation method in step 2 of setup wizard.
| No Format | ||
|---|---|---|
| ||
Step 2 - Replication pairs
========================================
The second step is to set source and targets for each replication pair. This is usually just choosing the first database as
source and the second one as target, but many more configurations are possible.
Let's configure the replication pair, selecting source and target.
Following databases are described:
1: reptest1 (Oracle)
2: reptest2 (Oracle)
Select source database: [1]
Select target database: [2]
Will be DDL replication enabled? (If YES, the script will grant more privileges to the Dbvisit Replicate users and enable database-wide supplemental logging): [yes]
Use fetcher to offload the mining to a different server? (yes/no) [no]
Would you like to encrypt the data across the network (yes or no) [no]
Would you like to compress the data across the network (yes or no) [no]
How long do you want to set the network timeouts. Recommended range between 60-300 seconds [60]
Lock and copy the data initially one-by-one or at a single SCN? (one-by-one/single-scn/ddl-only/resetlogs) [single-scn] resetlogs
What data copy script to create? (dp_networklink/dp_exp/exp/ddl_file/ddl_run/none) [none]
Following replication pairs are now configured:
1: reptest1 (Oracle) ==> reptest2 (Oracle), DDL: yes, fetcher: no, process suffix: (no suffix),
compression: no, encryption: no, network timeout: 60, prepare type: resetlogs, data load: none
Enter number of replication pair to modify it, or "add", or "done": [done] |
5. Run the reptest1-all.sh script followed by starting MINE and APPLY processes.
| Note |
|---|
SCOTT.REPTEST1 instantiated at SCN 20246293
Table SCOTT.REPTEST2 instantiated at SCN 20246293
WARN-9086: Unsupported datatype ROWID found in table SCOTT.TAB7. Do not
forget to exclude the column.
Table SCOTT.TAB7 instantiated at SCN 20246293
WARN-9086: Unsupported datatype XMLTYPE found in table SCOTT.TAB8. Do not
forget to exclude the column.
Table SCOTT.TAB8 instantiated at SCN 20246293 |