Purpose
You can use this statement to set a recovery system change number (SCN) for a standby tenant.
Syntax
/* Recover to a specified timestamp */
ALTER SYSTEM RECOVER STANDBY
[TENANT tenant_name] UNTIL TIME 'timestamp'
/* Recover to a specified SCN */
ALTER SYSTEM RECOVER STANDBY
[TENANT tenant_name] UNTIL SCN scn_no
/* Unlimited recovery */
ALTER SYSTEM RECOVER STANDBY
[TENANT tenant_name] UNTIL UNLIMITED
/* Cancel recovery of the database from archived redo logs */
ALTER SYSTEM RECOVER STANDBY
[TENANT tenant_name] CANCEL
Note
- You must specify the
TENANT tenant_nameparameter when you execute this statement under the system tenant. - You can execute this statement only for the current user tenant.
Parameters
| Field | Description |
|---|---|
| timestamp | The timestamp to recover to. |
| scn_no | The SCN to recover to. |
| UNLIMITED | Indicates unlimited recovery. |
Examples
Enable continuous synchronization for the standby tenant restore_oracle_tenant.
obclient> ALTER SYSTEM RECOVER STANDBY TENANT restore_oracle_tenant UNTIL UNLIMITED;
Query OK, 0 rows affected