Restore - Undo Phase

[javelin]

Hello all.

We recently migrated to a new server and changed our backup script to write to file instead of tape device. During restore, we saw some messages we didn't see before when restoring from tape:



Are those Undo messages normal? Can someone shed some lights into these please. Searched the forum and net but didn't see anything useful.

before migration:

probkup online gpodb /dev/rmt0.1​

after migration:

probkup online gpodb $backupDIR/GPO/gpodb.bkup.$DIA

[root]:/mfgpro/backup/GPO # ls -al gpo*
-rw-r--r-- 1 root system 6145446912 Dec 16 09:02 gpodb.bkup.Tue​

Our db person checked the database and tables and he think "it looks OK" but we're still unsure about those Undo messages if they are something we need to worry about.

Any suggestion or comment is much appreciated.

Thanks!
jav

 

[TheMadDBA]

Those are normal. In your exact case it means that 2 transactions were active but not completed at the time of the online backup. When the database starts up it reconciles the BI file against the DB and backs out any uncompleted transactions.

Your db person might want to read up on the Progress documentation again

 

[javelin]

Those are normal. In your exact case it means that 2 transactions were active but not completed at the time of the online backup. When the database starts up it reconciles the BI file against the DB and backs out any uncompleted transactions.

Your db person might want to read up on the Progress documentation again

Thank you! I appreciate it. : )

 

[Cringer]

This presentation from the EMEA PUG might help shed light on what the BI is doing. http://www.pugchallenge.eu/images/2014pdfs/gus_bjorklund_BICheckpointsCrashes.pdf