Problem Description
On a Solaris platform, the dbvrep console might show malformed output like:
dbvrep> unprepare table ahorejsp.segments
Kables listed.--------------------------------[Table unprepared (1 internal records).]or
dbvrep> prepare table AHOREJSP.TABLES
KLY IS running. Currently at plog 1928 and SCN 0 (01/01/1988 00:00:00).9:55).pires in 15 days
...Solution
This happens because of the default STATUS_BAR output configuration variable. The default is STATUS+LIST.
If you disable the LIST from the STATUS_BAR, the output of the console should look better:
dbvrep> set STATUS_BAR=status
Variable STATUS_BAR set to status for process *.
dbvrep> unprepare table AHOREJSP.TABLES
Connecting to running mine [AHOREJSP.TABLES]: [Table unprepared (1 internal records).]
Connecting to running apply:[Apply table removed (103122529 metadata record(s)). Apply table added (0 metadata record(s)).]
Table AHOREJSP.TABLES processed. (no counter resync)See: https://dbvisit.atlassian.net/wiki/display/ugd7/Configuration+Variable+Reference for more info about the STATUS_BAR variable.
There may still be some output errors:
dbvrep> prepare table AHOREJSP.TABLES
KLY IS running. Currently at plog 1942 and SCN 73052159 (04/15/2015 20:22:31).ires in 14 days
consistent export....Waited 2 seconds until scn_to_timestamp changed.
Connecting to running apply [AHOREJSP.TABLES]: [Apply table removed (0 metadata record(s)). Apply table added (1 metadata record(s)).]
KLY IS running. Currently at plog 1942 and S[Table prepared (1 internal records).]
Table AHOREJSP.TABLES instantiated at SCN 73052193<The best way of getting rid of the malformed output is to start the dbvrep console with --no-termcap:
start-console.sh --no-termcap
dbvrep> unprepare table AHOREJSP.TABLES
Connecting to running mine [AHOREJSP.TABLES]: [Table unprepared (1 internal records).]
Connecting to running apply:[Apply table removed (103122529 metadata record(s)). Apply table added (0 metadata record(s)).]
Table AHOREJSP.TABLES processed. (no counter resync)
dbvrep> prepare table AHOREJSP.TABLES
Prepare enabled supplemental logging, waiting for SCN advance enough to prevent ORA-01466 during consistent export....Waited 1 seconds until scn_to_timestamp changed.
Connecting to running apply [AHOREJSP.TABLES]: [Apply table removed (0 metadata record(s)). Apply table added (1 metadata record(s)).]
Connecting to running mine [AHOREJSP.TABLES]: [Table prepared (1 internal records).]
Table AHOREJSP.TABLES instantiated at SCN 73053451
dbvrep>See: https://dbvisit.atlassian.net/wiki/display/ugd7/Command+Console wiki page for more info about the --no-termcap option of the dbvrep command.
Petr Horejs April 15, 2015 21:32
Comments