Purpose
You can use this statement to show all backup sets and archivelog pieces required to restore to the specified timestamp by specifying the original tenant-level archive and backup paths and the expected time to restore to.
Required privileges
To execute this statement, you must have the ALTER SYSTEM privilege.
Syntax
ALTER SYSTEM RESTORE FROM 'uri' UNTIL { TIME='timestamp' | SCN=scn } PREVIEW;
Parameters
| Parameter | Description |
|---|---|
| uri | The original data backup and log archive paths, which must be separated with a comma (,). |
| TIME='timestamp' | SCN=scn | The timestamp or SCN to restore to. You must explicitly specify this parameter in the statement. |
Examples
Specify the original data backup and log archive paths, and specify the SCN to restore to as
1712650554000909004.ALTER SYSTEM RESTORE FROM 'file:///ob_backup/data, file:///ob_backup/archive' UNTIL SCN = 1712650554000909004 PREVIEW;Specify the original data backup and log archive paths, and specify the timestamp to restore to as
2024-04-09 16:15:54.ALTER SYSTEM RESTORE FROM 'file:///ob_backup/data, file:///ob_backup/archive' UNTIL TIME = '2024-04-09 16:15:54' PREVIEW;