Home Topics HVR Real-time Replicator Knowledge Base Problem Summary: How to determine the Oracle SCN from hvr_tx_seq in the HVR Transaction files
Problem Summary: How to determine the Oracle SCN from hvr_tx_seq in the HVR Transaction files
- This topic has 0 replies, 1 voice, and was last updated 3 months ago by
Pallavik.
- AuthorPosts
- September 3, 2019 at 1:05 pm #22547
Pallavik
KeymasterProblem Summary: How to determine the Oracle SCN from hvr_tx_seq in the HVR Transaction files
Description:
This article demonstrates how to determine the Oracle SCN from the hvr_tx_seq number using the command, hvrrouterview.
Details:
The hvr_tx_seq can be found in the transaction files in the router directory $HVR_CONFIG/router/<hubname>/<channel name>/loc_<src location>/loc_<tgt location>/ <filename>.tx_<tgt location>
The example below shows a snippet of output from hvrrouterview repoting the contents of the transaction file
Overview:
- Determine the hvr tx seq number
- Convert the hex value to decimal
Step 1) Determine the hvr_tx_seq using hvrrouterview
$hvrrouterview x x <filename>.tx_<tgt_location>
<row><column name=”hvr_tx_seq“>000001A06A910001</column>
<column name=”hvr_tx_countdown“>1</column>
<column name=”hvr_op“>1</column>
<column name=”hvr_cap_loc“>orcln</column>
<column name=”hvr_cap_tstamp“>2019-08-28 20:25:48</column>
<column name=”hvr_cap_user“>TPCC</column>
<column name=”c1“>36</column>
<column name=”c2“>PK26</column>
<column name=”c3“>2019-08-28 12:25:46.000000</column></row>
In the above snippet 000001A06A910001 is the hvr_tx_seq number.
In some cases this sequence number is displayed in the error message. Like below
F_JT147B: The previous error occurred during integration from burst table test1__b into base table testdb.test1 where hvr_op=1 and hvr_colval_mask=’vvvvvvjvvvv’ and hvr_cap_tstamp>=’2019-08-28T12:25:48-07:00′ hvr_cap_tstamp<=’2019-08-28T12:32:31-07:00′ and hvr_tx_seq>=’000001A06A910001‘ and hvr_tx_seq<=’000001A071010001‘ and hvr_cap_loc=’orcln’ (3 rows).
Step 2] Use hexadecimal calculator to divide sequence number by 10000
Step 3] Convert the result to decimal
i.e. hex value 1A06A91 is equivalent to 27290257 in decimal.
You can use this value to get the oracle archive log file which contains the record which is failing/ has issues with like below
select first_change#, next_change#, name from V$ARCHIVED_LOG where 27290257 between first_change# and next_change#;
This shows the path of the archive log which contains erroneous record in oracle database
- AuthorPosts
- You must be logged in to reply to this topic.