Purpose
This statement is used to load the path to be restored.
Privilege requirements
The current user must have the ALTER SYSTEM privilege to execute this statement.
Syntax
ALTER SYSTEM ADD RESTORE SOURCE 'restore_path';
Parameters
Parameters |
Description |
|---|---|
| restore_path | Enter the data backup set to be loaded (backup_set) or log archiving (archivelog_piece). It can be one or multiple paths.
Notice
|
Examples
Load the backup_set to be restored.
obclient [oceanbase]> ALTER SYSTEM ADD RESTORE SOURCE 'file:///ob_backup/data/backup_set_1_full';Load the archive log piece to be restored.
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 's3://test_bucket/archive/piece_1?host=***&access_id=x****&access_key=****';