IQ_POINT_IN_TIME_RECOVERY_LOG_BACKUP_INTERVAL Option

Sets a time interval between automatic backups of the point in time recovery logs.

Allowed Values

0 to <num> minutes

Default

Scope

Option can be set at the database (PUBLIC) level only.

Requires the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately.

Remarks

The IQ_POINT_IN_TIME_RECOVERY_LOG_BACKUP_INTERVAL option sets a time interval between automatic backups of the point-in-time recovery log:

SET OPTION PUBLIC.IQ_POINT_IN_TIME_RECOVERY_LOG_BACKUP_INTERVAL='30' // backups at 30 min intervals

The minimum supported backup interval is 5 minutes. Setting the IQ_POINT_IN_TIME_RECOVERY_LOG_BACKUP_INTERVAL to 0 (default) disables automatic backups.