How to trigger Savepoint?
|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
|A savepoint is performed after a consistent database state is reached while startup|
|Snapshots||Snapshots are those savepoints which are kept for longer use, therefore, they are not overwritten by the next savepoint.|