Purpose
You can use this statement to set a backup password.
This statement takes effect only at the session level. A backup password is cleared after a backup is initiated. If you need a backup password, you must configure a new password each time before a backup is initiated.
Syntax
SET ENCRYPTION ON IDENTIFIED BY 'password' ONLY;
Parameters
| Parameter | Description |
|---|---|
| password | The encryption password for the backup. |
Examples
Set a backup password.
obclient> SET ENCRYPTION ON IDENTIFIED BY '***1***' ONLY;