We're here to help!

Dbvrep Console Output Malformed on Solaris

Follow
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

Have more questions? Submit a request

Comments