Restoring a GROUP READ LOCK Archive of Selected Partitions - TARA/ABU

Teradata Archive/Recovery Utility Reference

Product
TARA/ABU
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
utr1488824663491.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2412
lifecycle
previous
Product Category
Teradata Tools and Utilities

When specifying the GROUP READ LOCK option for an archive of selected partitions, use the next procedure to perform the restore. Ensure that the structure version of the tables being restored match the structure version of the tables stored on the backup file.

  1. Restore or copy the selected partitions to the target table using the NO BUILD option.
  2. Restore or copy journal tables of the journal backup associated with the time period of interest.
  3. Roll forward the restored tables using the USE RESTORED JOURNAL and PRIMARY DATA options.
  4. Submit a BUILD DATA TABLES statement to complete the build of the restored tables.

During this procedure, an “out-of-range” error condition can occur if the selected partitions for the restore are inconsistent with the change rows being rolled forward (that is, the journal contains rows outside of the selected partitions for the restore). ROLL processing continues on the indicated table and the out-of-range changes are made to the target table.

This procedure corrects the structural validity of the table. However, it does not reveal the nature of the updates applied by the ROLL operation that fall outside of the selected partitions for the restore. There might be significant partitions that were missed in the restore and that were only partially updated by the out-of-range changes. Audit the entire recovery process to ensure that no data is missing. If missing data is suspected, repeat the above procedure for the affected partitions.