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