Test Environment Configuration

• Server Name: Tibero
• OS version: CentOS Stream release 10 (Coughlan)
• DB Version: Tibero 7.2.3

Method

What is tbdv?

It is a utility added in Tibero5sp1 version to check the integrity of Tibero data files.

It can be usefully used to check the integrity of backed up files.

[tibero@node1 ~]$ tbdv
==================================================================
= Database Verifier (DV) starts                                  =
=                                                                =
= TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. =
==================================================================
Usage: tbdv [options] <fpath>
  <fpath>	path to datafile to verify 

Options:
  -s	data block size (default: 8192)
  -m	multi block read count (default: 1)
  -l	the number of bytes to be checked
  -f	check if space management information is consistent. (default: 1)

How to Use tbdv

The format is tbdv file_path [options], and if options are omitted, the default values are applied.

File Backup

[tibero@node1 ~/backup]$ tbsql sys/tibero

tbSQL 7

TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.

Connected to Tibero.

SQL> alter database begin backup;

Database altered.

SQL> !cp /home/tibero/tbdata/*.dtf /home/tibero/backup/
SQL> alter database end backup;

Database altered.

SQL> q
Disconnected.
[tibero@node1 ~/backup]$ ls -rlt
Total 1581288
-rw-------. 1 tibero dba   94371840 Dec 16  10:35 syssub001.dtf
-rw-------. 1 tibero dba  104857600 Dec 16  10:35 system001.dtf
-rw-------. 1 tibero dba 1480589312 Dec 16  10:35 usr001.dtf
-rw-------. 1 tibero dba  209715200 Dec 16  10:35 undo001.dtf
-rw-------. 1 tibero dba  104857600 Dec 16  10:35 temp001.dtf

Check Normal File

[tibero@node1 ~/backup]$ tbdv syssub001.dtf 
==================================================================
= Database Verifier (DV) starts                                  =
=                                                                =
= TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. =
==================================================================
Datafile blk cnt = 11520
Multiblock cnt = 1
Verifying 'syssub001.dtf'...

  Gathering space information by reading space management blocks...
  74 space management blocks are detected.

  Start to verify blocks.
  11520 blocks are verified.

Verifying complete.

Total blocks: 11520
Processed blocks: 2729
Empty blocks: 8791
Corrupt blocks: 0

Check Abnormal File

#The file content was arbitrarily changed using hexedit

[tibero@node1 ~/backup]$ tbdv syssub001.dtf 
==================================================================
= Database Verifier (DV) starts                                  =
=                                                                =
= TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. =
==================================================================
Datafile blk cnt = 11520
Multiblock cnt = 1
Verifying 'syssub001.dtf'...

header is not datafile header.
  Gathering space information by reading space management blocks...
  74 space management blocks are detected.

  Start to verify blocks.
  11520 blocks are verified.

Verifying complete.

Total blocks: 11520
Processed blocks: 2729
Empty blocks: 8791
Corrupt blocks: 1

If the File Is Not a Tibero Data File

[tibero@node1 ~/install]$ tbdv tibero7-bin-FS02_PS03-linux64_4.18-301867-20250911103443.tar.gz 
==================================================================
= Database Verifier (DV) starts                                  =
=                                                                =
= TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. =
==================================================================
Datafile blk cnt = 84533
Multiblock cnt = 1
Verifying 'tibero7-bin-FS02_PS03-linux64_4.18-301867-20250911103443.tar.gz'...

Enter wrong block size (input: 8192, actual: 9254)