...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbvrep> choose show
Process MINE chosen, it is a MINE.
Process APPLY chosen, it is a APPLY.
dbvrep> pause apply
Apply requested to pause.
dbvrep> choose replication mine1
Process type MINE set to: mine1.
Process type APPLY set to: APPLY1.
dbvrep> choose show
Process mine1 chosen, it is a MINE.
Process APPLY1 chosen, it is a APPLY.
dbvrep> pause apply1
Apply requested to pause.
dbvrep> list status
MINE IS running. Currently at plog 10441 and SCN 43299785 (03/14/2013 11:50:59).
APPLY is PAUSED. Currently at plog 10441 and SCN 43299607 (01/01/1988 00:00:00).
MINE1 IS running. Currently at plog 3298 and SCN 43252417 (03/14/2013 11:50:59).
APPLY1 is PAUSED. Currently at plog 3298 and SCN 43252398 (03/14/2013 11:50:49).
|
|
|
2. PREPARE the new table.
Dbvisit Replicate will give the SCN of where the table will be replicated from.
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbvrep> choose show
Process MINE chosen, it is a MINE.
Process APPLY chosen, it is a APPLY.
dbvrep> prepare table SCHEMA_RECREATE.schema_recreate_tbl
Connecting to running apply [SCHEMA_RECREATE.schema_recreate_tbl]: [Apply table removed (0 metadata record(s)). Apply table added (1 metadata record(s)).]
Connecting to running mine [SCHEMA_RECREATE.schema_recreate_tbl]: [Table (un)prepared (4 internal records).]
Table SCHEMA_RECREATE.schema_recreate_tbl instantiated at SCN 43348595
dbvrep> choose replication MINE1
Process type MINE set to: MINE1.
Process type APPLY set to: APPLY1.
dbvrep> show choose
dbvrep> choose show
Process MINE1 chosen, it is a MINE.
Process APPLY1 chosen, it is a APPLY.
dbvrep> prepare table SCHEMA_RECREATE.schema_recreate_tbl
Connecting to running apply [SCHEMA_RECREATE.schema_recreate_tbl]: [Apply table removed (0 metadata record(s)). Apply table added (1 metadata record(s)).]
Connecting to running mine [SCHEMA_RECREATE.schema_recreate_tbl]: [Table (un)prepared (4 internal records).]
Table SCHEMA_RECREATE.schema_recreate_tbl instantiated at SCN 43298074
dbvrep> |
|
|
3. Synchronize data
Use the SCN from step 2 to load the historical data (Example use datapump with flashback_scn=xxx)
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbvrep> show apply_database
APPLY1.APPLY_DATABASE = UNITSRC
APPLY.APPLY_DATABASE = UNITTRG
APPLY1.APPLY_DATABASE_DBID = 433515465
*.APPLY_DATABASE =
APPLY.APPLY_DATABASE_DBID = 742136697
*.APPLY_DATABASE_DBID = |
|
|
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| SET TRANSACTION NAME 'DBREPL_DB_UNITSRC_XID_UNITSRC'
insert into SCHEMA_RECREATE.schema_recreate_tbl (id, member)
select id, member from SCHEMA_RECREATE.schema_recreate_tbl@unittrg
as of scn 43298074; |
|
|
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| SET TRANSACTION NAME 'DBREPL_DB_UNITTRG_XID_UNITTRG'
insert into SCHEMA_RECREATE.schema_recreate_tbl (id, member)
select id, member from SCHEMA_RECREATE.schema_recreate_tbl@unitsrc
as of scn 43348595; |
|
|
4. Resume the
...
replication
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbvrep> choose replication MINE
Process type MINE set to: MINE.
Process type APPLY set to: APPLY.
dbvrep> resume apply
Apply requested to resume. dbvrep> choose replication MINE1
Process type MINE set to: MINE1.
Process type APPLY set to: APPLY1.
dbvrep> resume apply1
Apply requested to resume. |
|
|
Note that the table needs to exist on the target side before the apply process can be resumed. Using a datapump in step 3 is a good choice, since the import creates table automatically if it does not exist.
...