SAP HANA log backup frequency

log_backup_interval_mode = Default

log_backup_timeout_s = 900

log_segement_size_mb = 1024

具体设置位置:

Machine generated alternative text:OverviewLandscape厶改§PeformanceVolumesConfigurationSystemInformationDiagnosisFil凸TraceConfigurationFilter:Vglobal.ini[]a小/0file認t妇“已Defa凵false720〕immediateDataba..Ho-山auditingconfigurationauthenticationauthorlzation匚pbackintresponsetimeoutcatalogbackupparameterfilecatalogbackupusingbackintdatabackupbuffersizedata匚pmaxchunk5尾edata匚pparameterfiledatabackupsavepoint《0timeoutenableaccumulatedcatalog匚p凸databackupbuffer5e《og匚pbuffersize《og匚pintervalmode《og匚pparameterfile《og匚pusingbackint《ogrecoveryresume_pointintervalmaxdetebackintentriesinquiremax《og匚psizemaxrecoverybackintchannelsr引回data匚pbackintchannels

 

 

global–> persistant

Machine generated alternative text:》ogencryptionthreadcount》ogformatstep5ekb《ogmode《ogpreformatsegmentcount《ogreplaystep_size《ogsegmentcreation0匚疑ingthreshold》ogsegment5性embm山5summation《ogi匚maxgc_parallelity5尾er毆corruptg凸runtimedump_corruptpagessavepointinterval§凵nd0ficache5eDefault1D24107彐7418241D24

关于备份的参数设置可以从视图M_BACKUP_CONFIGURATION查询到:

select * from M_BACKUP_CONFIGURATION

Machine generated alternative text:3"SQL垡R凸select*from卜1BACKUPCONFIGURATIONMAXRECOVERYFILEAGELOGREPLAYSTEPSIZE1,07《741霪24MAXRECOVERY8厶〔℃NTCHANNELS8监〔℃NTEXECUTABLE凵N卜

本文作者: GavinDong

版权属于: GavinDong博客

文章链接: https://gavindong.com/3048.html

如果使用过程中遇到问题,可 **点击此处** 交流沟通。

版权所有,转载时必须以链接形式注明作者和原始出处及本声明。

(0)

相关文章

发表回复

登录后才能评论