How to trigger Savepoint?
SOLUTION
Scenario | Details |
---|---|
Savepoint interval (automatic) | Savepoints are automatically triggered during normal operations when a predefined time since the last savepoint is passed. The time interval between two consecutive savepoints can be controlled via the following parameter: global.ini -> [persistence] -> savepoint_interval_s Its default value is 300, therefore the intervals between savepoints are 300 seconds (5 min). |
Soft shutdown |
|
System command (manual) | Savepoint can be used manually via command ALTER SYSTEM SAVEPOINT |
Startup | A savepoint is performed after a consistent database state is reached while startup |
Backup |
|
Snapshots | Snapshots are those savepoints which are kept for longer use, therefore, they are not overwritten by the next savepoint. |