ADD RESTORE SOURCE

Purpose

This statement is used to load the path that needs to be restored.

Privilege requirements

To execute this statement, the current user must have the ALTER SYSTEM privilege.

Syntax

ALTER SYSTEM ADD RESTORE SOURCE 'restore_path';

Parameters

Examples

1. Load the backup_set to be restored.

   obclient [oceanbase]> ALTER SYSTEM ADD RESTORE SOURCE 'file:///ob_backup/data/backup_set_1_full';
   

2. Load the archivelog_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 'oss://test_bucket/archive/piece_1?host=***&access_id=x****&access_key=****';
   

References

• CLEAR RESTORE SOURCE
• RESTORE PREVIEW
• Execute a restore operation on a specified path