All keywords are case-insensitive.
...
| No Format |
|---|
|
dbvrep> DUMP MINE ALL
Dump complete. dbvrep>Â dbvrep>
dbvrep> DUMP MINE MESSAGES
Trace messages dump complete. dbvrep>
dbvrep> DUMP MINE MEMORY_ACCOUNTING
Memory accounting dump complete.
dbvrep>Â dbvrep> |
| Anchor |
|---|
| ENCRYPT password |
|---|
| ENCRYPT password |
|---|
|
ENCRYPT
...
| No Format |
|---|
|
dbvrep>EXCLUDE COLUMN SCOTT.DEPT.LOC
Connecting to running mine [SCOTT.DEPT.LOC] 2: [Column excluded (1 internal records).]
Exclude Column [SCOTT.DEPT.LOC] set.
dbvrep> |
| Anchor |
|---|
| EXCLUDE CREATE TABLE |
|---|
| EXCLUDE CREATE TABLE |
|---|
|
EXCLUDE CREATE TABLE
...
| No Format |
|---|
|
dbvrep> EXCLUDE CREATE TABLE scott2%.%
Exclude rule created.
dbvrep>
dbvrep> EXCLUDE CREATE TABLE SHOW
List of excluded (included) tables:
EXCLUDE CREATE TABLE CLEAR
EXCLUDE CREATE TABLE scott2%.%
1 rule(s) listed.
dbvrep> Â
dbvrep> EXCLUDE CREATE TABLE CLEAR
1 rule(s) deleted.
dbvrep> |
...
| No Format |
|---|
|
dbvrep> FILTER TABLE SCOTT.DEPT ON INSERT SET TO deptno > 50
Connecting to running apply: [Apply table removed (1 metadata record(s)). Apply table added (1 metadata record(s)).]
Filter condition on table SCOTT.DEPT set.
dbvrep>
dbvrep> FILTER SCHEMA SCOTT ON INSERT SET TO where id >20
Connecting to running apply: [Apply table removed (0 metadata record(s)). Apply table added (0 metadata record(s)).]
Filter condition on table SCOTT.BONUS set.
Connecting to running apply: [Apply table removed (0 metadata record(s)). Apply table added (0 metadata record(s)).]
Filter condition on table SCOTT.DEPT
Connecting to running apply: [Apply table removed (0 metadata record(s)). Apply table added (0 metadata record(s)).]
Filter condition on table SCOTT.EMP set.
Connecting to running apply: [Apply table removed (0 metadata record(s)). Apply table added (0 metadata record(s)).]
Filter condition on table SCOTT.SALES set.
Connecting to running apply: [Apply table removed (0 metadata record(s)). Apply table added (0 metadata record(s)).]
Filter condition on table SCOTT.SALGRADE set.
Connecting to running apply: [Apply table removed (0 metadata record(s)). Apply table added (0 metadata record(s)).]
dbvrep>
dbvrep> filter show table scott.sales
Filter conditions on table SCOTT.SALES are set as follows:
insert : deptno>50
pre-update : (no filter)
post-update: (no filter)
delete : (no filter)
dbvrep>
dbvrep> filter show schema scott
Filter conditions on schema SCOTT are set as follows:
insert : (no filter)
pre-update : (no filter)
post-update: (no filter)
delete : (no filter)
dbvrep> |
HEALTHCHECK
...
| No Format |
|---|
|
dbvrep> INCLUDE CREATE TABLE SCOTT2.%
Include rule created.
dbvrep>
dbvrep> INCLUDE CREATE TABLE SHOW
List of excluded (included) tables:
EXCLUDE CREATE TABLE CLEAR
EXCLUDE CREATE TABLE scott2%.%
INCLUDE CREATE TABLE SCOTT2.%
2 rule(s) listed.
dbvrep> dbvrep> INCLUDE CREATE TABLE CLEAR2 rule(s) deleted.
dbvrep> |
LICENSE
...
| No Format |
|---|
|
dbvrep> LIST MINE REDOLOGS
O Seq# FirstSCN NextSCN ReadCount StartDate EndDate FileName
-----------------------------------------------------------------------------------------------
N 3267 79626512 79634437 1 30.03.2015 03:23:40 30.03.2015 03:23:53
/u01/app/oracle/fast_recovery_area/SDB11/archivelog/2015_03_30/o1_mf_1_3267_bkkyb3jm_.arc
N 3268 79634437 79635588 1 30.03.2015 03:23:54 30.03.2015 03:24:06
/u01/app/oracle/fast_recovery_area/SDB11/archivelog/2015_03_30/o1_mf_1_3268_bkkyb7gq_.arc
N 3269 79635588 79635595 1 30.03.2015 03:24:06 30.03.2015 03:24:06
/u01/app/oracle/fast_recovery_area/SDB11/archivelog/2015_03_30/o1_mf_1_3269_bkkybcsz_.arc
N 3270 79635595 79635664 1 30.03.2015 03:24:06 30.03.2015 03:24:06
/u01/app/oracle/fast_recovery_area/SDB11/archivelog/2015_03_30/o1_mf_1_3270_bkkybkz1_.arc
N 3271 79635664 79635727 1 30.03.2015 03:24:06 30.03.2015 03:25:57 Â
dbvrep>
dbvrep> LIST APPLY PLOGS
O Seq# FirstSCN NextSCN LastSCN ProcessDate FileName
--------------------------------------------------------------------
N 3267 79626512 79634434 79632380 30.03.2015 03:24:03 /home/oracle/review/apply/3267.plog
N 3268 79634437 79635583 79635587 30.03.2015 03:24:19 /home/oracle/review/apply/3268.plog
N 3269 79635588 79635589 79635594 30.03.2015 03:24:49 /home/oracle/review/apply/3269.plog
N 3270 79635595 79635659 79635663 30.03.2015 03:24:50 /home/oracle/review/apply/3270.plog
|
...
| No Format |
|---|
|
dbvrep> LIST PROGRESS SCOTT
Progress of replication review: total/this execution
--------------------------------------------------------------------------------------------------------------------------------------------
SCOTT.T2: 100% Mine:23/23 Unrecov:0/0 Applied:23/23 Conflicts:0/0 Last:30/03/2015 03:27:19/OK
SCOTT.DEPT: 100% Mine:27/27 Unrecov:0/0 Applied:27/27 Conflicts:0/0 Last:30/03/2015 03:26:16/OK
SCOTT.EMP: 100% Mine:14/14 Unrecov:0/0 Applied:14/14 Conflicts:0/0 Last:30/03/2015 03:26:16/OK
--------------------------------------------------------------------------------------------------------------------------------------------
3 tables listed. |
LIST PREPARE. Shows list of prepared tables. You can optionally specify a schema to filter the results to a particular database schema (this is source schema if renaming is used). Use ALL to see everything including internal tables.
...
| Anchor |
|---|
| PREPARE_AND_LOAD |
|---|
| PREPARE_AND_LOAD |
|---|
|
PREPARE_AND_LOAD
DESCRIPTION
Prepares the new table to be added into the replication stream. Also LOADs the table at the same time. With this one command the table is prepared for all future changes and then loads the target table with all of the historical rows in the source table. The target table will have to be created before running this command. The dbvrep user on the SOURCE database will need to have SELECT and FLASHBACK privileges on the table that is being prepared and loaded.
Example:
| No Format |
|---|
|
dbvrep> MAKE example PREPARE_AND_LOAD TABLE SCOTT.REPTEST4
Connecting to running apply [SCOTT.REPTEST4]: [Apply table removed (0 metadata record(s)). Apply table added (1 metadata record(s)).]
Connecting to running mine [SCOTT.REPTEST4]: [Table prepared (1 internal records).]
Table OLLIE.REPTEST4 instantiated at SCN 31096663
Table OLLIE.REPTEST4 will be loaded using SCN 31096663.
Connecting to running mine [SCOTT.REPTEST4]: [1 records processed.]
dbvrep> |
| Anchor |
|---|
| PROCESS LOAD_REQUEST |
|---|
| PROCESS LOAD_REQUEST |
|---|
|
PROCESS LOAD_REQUEST
...
The DEFAULT conflict handler will not be applied to existing prepared (replicated) tables. The DEFAULT conflict handler will only be applied to tables that are prepared after the DEFAULT conflict handler is set. To change the conflict handler for existing prepared tables, each table has to be individually set using FOR TABLE conflict handler.
Example:
| No Format |
|---|
|
dbvrep> SET_CONFLICT_HANDLERS FOR TABLE SCOTT.DEPT FOR UPDATE on NO_DATA TO OVERWRITE
Connecting to running apply: [The table called SCOTT.DEPT on source is handled on apply (APPLY) as follows:
UPDATE (error): handler: RETRY logging: LOG
UPDATE (no_data): handler: OVERWRITE logging: LOG
UPDATE (too_many): handler: RETRY logging: LOG
DELETE (error): handler: RETRY logging: LOG
DELETE (no_data): handler: RETRY logging: LOG
DELETE (too_many): handler: RETRY logging: LOG
INSERT (error): handler: RETRY logging: LOG
TRANSACTION (error): handler: RETRY logging: LOG]
dbvrep> |
...