ldmwndletsm
ADSM.ORG Senior Member
- Joined
- Oct 30, 2019
- Messages
- 232
- Reaction score
- 5
- Points
- 0
This will be on a Linux DR test server, not the production sever, but running same release.
Can you restore the database without the keys, as a test? If so, is it necessary to have first backed it up on the production server without the keys?
If you are able to restore without the keys then I would expect that you should be able to restore data from a non-encrypted tape since that wouldn't require a key. However, what happens if you then attempt to restore from an encrypted tape? Will it fail immediately? Or will it succeed, but the data will be unintelligible? Either way, it seems a fair test to ensure that the data really is being encrypted on the production server.
Also, does the password for the database instance user have to be the same as the server where the database backup was created? If not, then all you will need is the password used to protect the master key? That it?
Can you restore the database without the keys, as a test? If so, is it necessary to have first backed it up on the production server without the keys?
If you are able to restore without the keys then I would expect that you should be able to restore data from a non-encrypted tape since that wouldn't require a key. However, what happens if you then attempt to restore from an encrypted tape? Will it fail immediately? Or will it succeed, but the data will be unintelligible? Either way, it seems a fair test to ensure that the data really is being encrypted on the production server.
Also, does the password for the database instance user have to be the same as the server where the database backup was created? If not, then all you will need is the password used to protect the master key? That it?