Hello,
I am currently building a backup and recovery strategy for several new databases via RMAN and I am trying to figure out a way to periodically test a validity of a backup that will not increase a license cost for the entire database environment. I am not able to find a clear answer… maybe I am not searching hard enough or I am looking at the problem the wrong way, but I would like your advice on following matter…
I would like to know whether it is needed to secure an extra license (like for another database server with certain number of CPUs) if I use a RMAN duplicate command to replicate the production database to another server to test the backup and once the operation is successful, the duplicated database will be stopped and probably deleted?
I am not sure if such case is treated as an installation for testing/development purposes or if it requires an extra license, since it is a copy of a production database/instance (that won't be accessed by any user except the one that will be connected to it via RMAN and performing the restore/duplicate).
Also - in case the extra license is needed, is there any recommended way to periodically test the backup, such as “restore validate” command?
Thank you.