Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

ALTER SYSTEM SET ENCRYPTION ROOT KEYS BACKUP PASSWORD

|| 2

ALTER SYSTEM SET ENCRYPTION ROOT KEYS BACKUP PASSWORD
Stechies

Backup Encryption Root Key

Hello SAP Experts,

While executing a command mentioned on point 20 in SAP document 2444090

  • Could not execute 'ALTER SYSTEM SET ENCRYPTION ROOT KEYS BACKUP PASSWORD "password"'

  • SAP DBTech JDBC: [257]: sql syntax error: Incorrect syntax near "ENCRYPTION": line 1 col 18 (at pos 18)

Can I encrypt Redo Log Volume like Data Volume in this version?

In order to re0generate this error please execute the command 

./hdbnsutil -backupRootKeys <filename>.rkb --dbid=<dbid> --type='ALL'

Please help me to resolve this issue.


Comments

  • 28 Aug 2017 5:16 pm Helpful Answer

    There is no method available to only backup the SSFS, however, you can copy the SSFS + KEY file.

    All the key required are the part of normal HANA Backup, but if you want a separate backup of the SSFS you can copy the files.

  • 28 Aug 2017 5:17 pm Helpful Answer

    The error you are facing can occur due to following:

    • The command ‘hdbnsutil -backupRootkeys in not supported by HANA 1.0 SP12 and therefore it doesn't support ‘ALTER SYSTEM SET ENCRYPTION ROOT KEYS BACKUP PASSWORD 'password' statement
    • The REDO log is not supported in SP12. It’s supported since HANA 2.0 SP00

    Note: The HANA backup encryption is supported since HANA 2.0 SP01.


Advertisement
Advertisement
Advertisement