16.10 - REPOSITORY RESYNC - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty

Purpose

Resync a standby unsynced Repository in an high availability configuration.

Syntax

REPOSITORY RESYNC [BY FORCE] [TIMEOUT<n>]

Parameters

BY FORCE
Use to override requirements and force a resync.
TIMEOUT <n>
Use to specify the waiting period for the resync in seconds.

Usage Considerations

If you do not specify BY FORCE, one of the following requirements must exist:
  • Standby repository is unsynced.
  • State of the standby repository is invalid and cannot be recognized by Unity.
  • State of the standby repository cannot be read due to column, table, or database corruptions.

When you specify BY FORCE, Unity only checks if the standby repository database is connected and skips the requirements.

To start the job, REPOSITORY RESYNC waits for all in-flight transactions executed in the databases to complete unless you specify a TIMEOUT.

If the TIMEOUT>0, REPOSITORY RESYNC waits for the timeout specified for all in-flight transactions to complete. All in-flight Repository transactions must finish within this time or the command fails.

REPOSITORY RESYNC resumes repository sync after the standby repository is resynced.

Examples

If the alternate repository is unsynced, the command will execute.

unityadmin> REPOSITORY INFO;
Repository info
===============
Sync status: Paused [Encountering error(s)]
    ERROR: Alt repository has been disabled/unsynced
    Sync is behind by: Calculation unavailable

Local Repository:
-----------------
State            : Active
 
Alt Repository:
---------------
State            : Unsynced/Disabled
 

unityadmin> REPOSITORY RESYNC TIMEOUT 10;
Operation Number : 25
Operation Name   : Repository Resync
User             : admin
User Name        : Main Administration User
Start Time       : 05/30 15:07:59
Updates										:	05/30 15:07:59 [-] Info: Starting repository resync
05/30 15:07:59 [-] Info: Sync is paused
05/30 15:07:59 [-] Info: Local repository backup starts...
05/30 15:08:06 [-] Info: Alt repository restore starts...
05/30 15:08:54 [-] Info: Repository resync succeeded
05/30 15:08:54 [-] Info: Operation finished
Status      				: Finished (1)
Finish Time 				: 05/30 15:08:54