Skip to main content

Search

Welcome to Tibero GTS!

Internal Error Occurs When Recovering Data from hotbackup Copy

Document Type | Troubleshooting 

Category | Backup/Recovery

Applicable Product Versions | 6FS06, 6FS07, 6FS07PS, 7FS01, 7FS02, 7FS02PS

Document Number | TBATS008

 

Issue

An Internal Error occurs when recovering data from a hotbackup copy, and after recovery, a 2131 Generic I/O error is raised.
SQL> alter database recover automatic;

TBR-2131: Generic I/O error.

Slog
Internal Error with condition '(dfhdrblk->status & (DFHDR_FUZZY_BACKUP | DFHDR_FUZZY_ONLINE | DFHDR_FUZZY_MR)) == 0' (1 args)

 

Cause

The error occurred because a DataFile copied during operation, not a hotbackup copy, was used for recovery.
[09-12T17:52:41.294993] [RV-94] [I] DF #0(0) CKPT 2024-09-12 01:30:02,0000.65520be5(431563,431564) CF[CKPT 2024-09-12 01:30:02,0000.65520be5(431564), STOP 2024-09-12 17:49:33,ffff.ffffffff] FUZZY(online=1,backup=1,mr=0) rf(0000.00000000) 3
...omitted

[09-12T17:52:41.295694] [RV-94] [I] DF #22(17) CKPT 2024-09-12 01:36:04,0000.6552172f(430491,430492) CF[CKPT 2024-09-12 01:36:04,0000.6552172f(430492), STOP 2024-09-12 17:49:33,ffff.ffffffff] FUZZY(online=1,backup=0,mr=0) rf(0000.00000000) 3
โ€ฆomitted

[09-12T17:52:43.379852] [CLL-94] [I] logfile 1 is invalid online log file
[09-12T17:52:44.051391] [COM-94] [I] Internal Error with condition '(dfhdrblk->status & (DFHDR_FUZZY_BACKUP | DFHDR_FUZZY_ONLINE | DFHDR_FUZZY_MR)) == 0'
  • Media recovery should be fully completed and the DataFile header updated, but since the above flags have not all finished, an error occurs if media recovery is incomplete.
  • It appears that a Datafile backed up at a timing other than begin backup ~ end backup exists.

 

Solutions

Perform hotbackup script and Datafile backup properly.
 

Verify Proper Backup Execution

1. Check the Datafile header status value of the backed-up Datafile

Using the tbhdreditor tool, check one by one if the DFhdr (datafile header) status of the backed-up Datafile (hereafter DF) has reached the value 6. (online value: 2, backup value: 4 => 2 + 4 = 6)

How to use tbhdreditor tool

tbhdreditor -d system001.dtf -v > output
After execution, check the Status value.
 

2. Perform MR with the backup copy

Perform MR with the backup copy and verify in the Slog that all DFs have backup = 1.
[09-09T12:56:50.789296] [RV-105] [I] DF #0(0) CKPT 2024-09-09 01:30:01,0000.6529b4ac(430669,430670) CF[CKPT 2024-09-09 01:30:01,0000.6529b4ac(430670), STOP 2024-09-09 12:53:48,ffff.ffffffff] FUZZY(online=1,backup=1,mr=0) rf(0000.00000000) 3[09-09T12:56:50.789399] [CLR-105] [I] DF #1 (ts 1) resetlogs tsn=0, CF resetlogs tsn=0
[09-09T12:56:50.789404] [RV-105] [I] DF #1(1) CKPT 2024-09-09 01:30:02,0000.6529b4c3(234476,234477) CF[CKPT 2024-09-09 01:30:02,0000.6529b4c3(234477), STOP 2024-09-09 12:53:48,ffff.ffffffff] FUZZY(online=1,backup=1,mr=0) rf(0000.00000000) 3[09-09T12:56:50.789459] [CLR-105] [I] DF #2 (ts 3) resetlogs tsn=0, CF resetlogs tsn=0
[09-09T12:56:50.789464] [RV-105] [I] DF #2(3) CKPT 2024-09-09 01:30:03,0000.6529b4dc(430665,430666) CF[CKPT 2024-09-09 01:30:03,0000.6529b4dc(430666), STOP 2024-09-09 12:53:48,ffff.ffffffff] FUZZY(online=1,backup=1,mr=0) rf(0000.00000000) 3[09-09T12:56:50.789512] [CLR-105] [I] DF #3 (ts 4) resetlogs tsn=0, CF resetlogs tsn=0
[09-09T12:56:50.789516] [RV-105] [I] DF #3(4) CKPT 2024-09-09 01:30:04,0000.6529b4ee(430629,430630) CF[CKPT 2024-09-09 01:30:04,0000.6529b4ee(430630), STOP 2024-09-09 12:53:48,ffff.ffffffff] FUZZY(online=1,backup=1,mr=0) rf(0000.00000000) 3[09-09T12:56:50.789571] [CLR-105] [I] DF #4 (ts 5) resetlogs tsn=0, CF resetlogs tsn=0

 

 

 

Related to