If a database is using Transparent data encryption(TDE) and master key stored on wallet/hardware module is lost.
will it result in data lost in the database or what should be the repercussions if master key is lost in TDE enabled datbaase ?
As far as I know, it is recommended to make backups from the wallet, because if you lose the master key you won't be able to decrypt the database, because the encryption keys are encrypted by the master key.
But if your database is still running, your master encryption key might still be in the memory.
if I lose the master key, can I reset a new one using alter administrater command.
Will it encrypt the database with new master key?