on 07-19-2016 7:50 AM
Hi guys,
Our HANA DB server had hung last week and after reboot we noticed backups are failing with SSFS inconsistency error.
We dont have data volume encryption enabled. Also checked note 2097613 - Database is running with inconsistent Secure
Storage File System (SSFS) and followed step B.
Even after this backup is failing with same error. Unfortunately dont have backup of key files as suggested in Solution A.
Was there restart required after implementation of below commands?
Following was output
<hostname>:/usr/sap/SID/HDB04>hdbcons "crypto ssfs resetConsistency"
SAP HANA DB Management Client Console (type '\?' to get help for client commands)
Try to open connection to server process 'hdbindexserver' on system 'EP4', instance '04'
SAP HANA DB Management Server Console (type 'help' to get help for server commands)
Executable: hdbindexserver (PID: 36808)
[OK]
--
This command will completely rewrite the consistency informations about the ssfs,
please ensure that this is the last resort for fixing the ssfs
and you did all means to restore the consistent ssfs.
If you are sure about this, call the command again within 20s to rewrite ssfs consistency information.
[OK]
--
[EXIT]
--
[BYE]
<hostname>:/usr/sap/SID/HDB04> hdbcons "crypto ssfs resetConsistency"
SAP HANA DB Management Client Console (type '\?' to get help for client commands)
Try to open connection to server process 'hdbindexserver' on system 'EP4', instance '04'
SAP HANA DB Management Server Console (type 'help' to get help for server commands)
Executable: hdbindexserver (PID: 36808)
[OK]
--
rewriting ssfs consistency information...
done.
[OK]
--
[EXIT]
--
[BYE]
ALTER SYSTEM APPLICATION ENCRYPTION CREATE NEW KEY
Could not execute 'ALTER SYSTEM APPLICATION ENCRYPTION CREATE NEW KEY'
SAP DBTech JDBC: [7]: feature not supported: Application encryption not possible without secure store
Issue has been resolved. Seems the SSFS_key_file_path was pointing to wrong path. Restored it back to original. Then reset the consistency again with hdbcons "crypto ssfs resetConsistency" twice. After which issue was resolved.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.