Product Information > Version 7.1 Release Information > Upgrading to JADE Release 7.1 > SDS Database Role (PAR 63603)

SDS Database Role (PAR 63603)

In earlier releases, the JADE Database utility batch clearRole command could be performed on a backup of a secondary system leaving it in an inconsistent state.

It is generally unsafe to clear the role of a secondary system, as they almost always require recovery. You should clear the role by specifying the clearSDSRole parameter in the recovery from backup. If you do not specify the clearSDSRole parameter in the recovery from backup, the recovery operation is recovering a secondary database as a secondary. This means that:

  1. No undo will be performed

  2. A partial final journal will not be processed (when the secondary initializes, it re-fetches the journal from the primary)

The expectation is that the database will connect to the primary and then synchronize. When the last journal is not applied when recovering from a backup, the backup recovery is incomplete and file integrity is not restored. The undo action is suppressed, so there are further complications if there are incomplete transactions.

This has been corrected. The clearRole command is no longer permitted on SDS Secondary systems, and the jdbutil and jdbutilb executables showInfo command now always shows SDS Secondary systems as requiring recovery.