Purpose
You can use this statement to load the path of the data to be restored.
Required privileges
To execute this statement, you must have the ALTER SYSTEM privilege.
Syntax
ALTER SYSTEM ADD RESTORE SOURCE 'restore_path';
Parameters
| Parameter | Description |
|---|---|
| restore_path | The path of the data backup set or archivelog piece to be loaded. You can specify one or more paths.
Notice
|
Examples
Load the backup set to restore from.
obclient [oceanbase]> ALTER SYSTEM ADD RESTORE SOURCE 'file:///ob_backup/data/backup_set_1_full';Load the archivelog piece to restore from.
obclient [oceanbase]> ALTER SYSTEM ADD RESTORE SOURCE 'file:///ob_backup/archive/piece_d1002r1p1,file:///ob_backup/archive/piece_d1002r1p2';obclient [oceanbase]> ALTER SYSTEM ADD RESTORE SOURCE 'oss://test_bucket/archive/piece_1?host=***&access_id=x****&access_key=****';