When we use Veeam Plug-in for backup Oracle DB inside Solaris OS, as RMAN do backup and restore to Veeam Server, how do we fully control backup and restore, retention policy setting for Oracle DB from Veeam Backup V11 Console?
Answer
Veeam V11 plug-in for oracle
Best answer by JMeixner
Hi,
you set the retention time in RMAN, not in VBR.
Additionally there is a parameter you can set in the plugin config whre you can set a number of days after them the files in der VBR repository are deleted. Set the number of days in the parameter to a higher number than your retention tume in RMAN. RMAN will not be recognized about the deletion when the number of days is less the retention tume in RMAN.
You set the parameter with this command
OracleRMANConfigTool --set-force-delete <number of days>
+16Hi,
you set the retention time in RMAN, not in VBR.
Additionally there is a parameter you can set in the plugin config whre you can set a number of days after them the files in der VBR repository are deleted. Set the number of days in the parameter to a higher number than your retention tume in RMAN. RMAN will not be recognized about the deletion when the number of days is less the retention tume in RMAN.
You set the parameter with this command
OracleRMANConfigTool --set-force-delete <number of days>
Jochen (Joe) Meixner | Veeam Vanguard 2024 | Veeam Legend 2021 - 2024 | Veeam Certified Architect (VMCA) | X: @JoMeix | BlueSky: @jmeixner.bsky.social
+16The RMAN plugin is like a device on which RMAN writes and reads its data. RMAN manages the data.
VBR repository is the storage for the RMAN data. You can setup copy jobs for the RMAN data.
But RMAN is the real manager of all this. So, the Oracle admins can backup and restore by themself without interaction from the backup admin.
The only “control" of all this by the backup admin is the set-force-delete parameter. In my environments the deletion of the files in repository after the RMAN retention time was nor reliable. after we have set the value of this parameter the deletion is reliable.
Please be aware to set the value of the parameter slightly higher than the RMAN retention, otherwise you will delete files RMAN uses and RMAN will not be notified about the deletion.
Jochen (Joe) Meixner | Veeam Vanguard 2024 | Veeam Legend 2021 - 2024 | Veeam Certified Architect (VMCA) | X: @JoMeix | BlueSky: @jmeixner.bsky.social
+7You can use Veeam to:
- Copy backup to an other site
- Publish and restore data with explorer
Don’t forget to encrypt, compress and dedup at rman level
Our DBA love oracle explorer because they can publish data to other Rac Cluster and doing instant recovery 
+22You can also create a backup copy job for Rman plugin backup jobs in order to follow the 3 2 1 rule. However, for now Cloud Connect Backup Copy jobs are not supported.
VMCA2024, VMCE2023, VMCE2024-SP,CKA, LFCS
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.