Resume point interval during log recovery: Sets resume point interval. with service it will by default be every 15 minutes, with immediate as soon as the log segment becomes full. User-specific, can be done as "service" or "immediate". Sets how often log backups should be made. Defines the buffer size used to copy data for page into backups for dynamic tiering/ extended storage systems. Also consider the increased memory usage with this parameter.īuffer size for copying data backups.
The default value is 512MB.ĥ12-> 4096 depending on paralell_data_backup_backint_channels value. It defines the buffer size used to copy data for page into backups. This is the buffer size for creating backups of the backup catalog.īuffer size for copying data backup. Set the Optional Backup Configuration Parametersįor the level of granularity required (System, tenant) backup operations can be optimized in terms of performance and recovery strategy. To view or set parameters in SAP HANA Studio, navigate to the Configuration view and in the Global.ini file find the section for backup: Note that the log backups will need to be set to use backint as well.ĪLTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('backup', 'LOG_BACKUP_USING_BACKINT') = 'true' WITH RECONFIGURE" To set the log backup parameter file using native SQL:ĪLTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('backup', 'LOG_BACKUP_PARAMETER_FILE') = 'file location' WITH RECONFIGURE" To set the data backup parameter file using native SQL:ĪLTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('backup', 'DATA_BACKUP_PARAMETER_FILE') = 'file location' WITH RECONFIGURE" Note that the catalog backups will need to be set to use Backint as well, this can be done with the following native SQL statement:ĪLTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('backup', 'CATALOG_BACKUP_USING_BACKINT') = 'true' WITH RECONFIGURE"
To set the catalog backup parameter file using native SQL:ĪLTER SYSTEM ALTER CONFIGURATION ('global.ini', 'SYSTEM') SET ('backup', 'CATALOG_BACKUP_PARAMETER_FILE') = 'file location' WITH RECONFIGURE" To override the values set at the System layer either connect to the tenant database with the administrative user and set the parameters there, or set the parameter at the Tenant layer. When setting System layer parameters all tenants will inherit the property unless otherwise overridden specifically for that tenant. All of the below native SQL configuration examples are setting values for the System layer.
0 kommentar(er)
