standalone SAP HANA data archiving

[former_member514240]

Hi,

We would like to know Data Archiving capabilities of standalone SAP HANA tables.

Currently we are on HANA 2.00.024.02.1525857514 (fa/hana2sp02)

We have auditing enabled in the system. The audit log table growth is huge(Around 350GB) which effects the backup size.

Schema Name : _SYS_AUDIT

Table Name : CS_AUDIT_LOG_

Table Size : 340GB

Few SAP notes saying to delete old data from the table but in our case the retention has to be 2 months. Even though we haven't completed 2 months, our database size is growing rapidly.

Also the schema(_SYS_AUDIT) is not visible under Catalog even with SYSTEM user. Is there a way to see the schema under catalog?

Also we would like to know if any standard archiving techniques in SAP HANA . preferably moving data from table level to filesystem level?

Thanks and Regards

Sampath R.

[lbreddemann]

There is no standard archiving feature for the audit log available. What you can do is

- exporting it to file or copying to another table

And then

- delete the audit log entries via the ALTER SYSTEM command.

[HakanHaslaman]

Please check this blog for details.