SET DECRYPTION

Purpose

This statement is used to set the password for restoring data. It is only necessary to set the password for restoring data when a password was added during the backup process.

This statement can only be executed by the sys tenant.

Syntax

SET DECRYPTION IDENTIFIED BY  ('password'[, 'password' ...]);

Parameters

Examples

• Set the same password for full backups and incremental backups.

  obclient> SET DECRYPTION IDENTIFIED BY '***1***';
  

• Set different passwords for full backups and incremental backups. The first password is for full backups, and the second password is for incremental backups.

  obclient> SET DECRYPTION IDENTIFIED BY '***1***','***2***';