Point-in-Time Recovery

The point-in-time recovery (PIT) feature allows you to make the state of an archive consistent with a primary database. In cases where the primary database or the archive (e.g. Hadoop) has been restored to a certain moment and is now in an inconsistent state, this function analyzes the situation and synchronizes the archive with the primary database.

 

There are two supported use cases:

  1. The archive is restored to a point in time when it does not correspond with the primary database. In this case, the necessary data for the recovery is stored in the change log in the primary database.

  2. The primary database is restored to a point in time when it does not correspond with the archive. In this case, the change log is stored in the archive

You can either use these use cases separately or combine them.

The PIT recovery feature only recovers changes made by SNP Outboard™ Datatiering with NLS. These changes are:

  • Archiving

  • Reloading

  • Writer operations

  • Changing the structure

The table below lists other limitations:

Functions

Limitations

InfoProvider type

DataStore Objects, write-optimized DataStore Objects and InfoCubes are supported

Aging profile

Aging profiles with only one target storage are supported

Target storage type

Hadoop as the target storage is supported