Hey guys,
If I want to initiate oracle RMAN backup in veeam by running the backup from database, backup will run in veeam repo, but what about the schedule settings for that? where can I edit that?
Solved
Oracle RMAN backup
Best answer by JMeixner
Yes, scheduling and the selection whether a full or incremental db backup or a log backup is done is written in an Oracle RMAN script which has to be run by cron on the system the db resides.
The settings for RMAN compression are done there, too.
The plugin configuration consists of the connection to the VBR server with the user and password, repository and the amount of parallel backup streams.
My recommendation is to use an own repository for the RMAN data. These backups have a lot of files and are better to handle in a separate repository.
And - perhaps most important - the amount of days after Veeam deletes the backup files from the repository is set in the plugin config. The deletion by RMAN is not reliable, so set this parameter to some days mare than the retention set in RMAN. Then the deletion of the files is working fine.
+12Ir you are using Veeam Plugin for Oracle RMAN, then the scheduling is not done by veeam itself.
You need to script the rman backups in the oracle server with rman commands and create a cron job, as far as I understand the implementation.
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmbckba.htm
If you are talking about VM or Agent Backup of a Oracle Server, then the backup job schedule is done in VBR.
Update
from the Guide:
https://helpcenter.veeam.com/docs/backup/plugins/rman_job_vbr.html?ver=110
You cannot start or edit Oracle RMAN backup jobs in the Veeam Backup & Replication console. You can manage backup operations only on the Oracle side using RMAN.
Product Management Analyst @ Veeam Software
+17Yes, scheduling and the selection whether a full or incremental db backup or a log backup is done is written in an Oracle RMAN script which has to be run by cron on the system the db resides.
The settings for RMAN compression are done there, too.
The plugin configuration consists of the connection to the VBR server with the user and password, repository and the amount of parallel backup streams.
My recommendation is to use an own repository for the RMAN data. These backups have a lot of files and are better to handle in a separate repository.
And - perhaps most important - the amount of days after Veeam deletes the backup files from the repository is set in the plugin config. The deletion by RMAN is not reliable, so set this parameter to some days mare than the retention set in RMAN. Then the deletion of the files is working fine.
Jochen (Joe) Meixner | Veeam Vanguard 2024 | Veeam Legend 2021 - 2024 | Veeam Certified Architect (VMCA) | Twitter: @JoMeix | BlueSky: @jmeixner.bsky.social
+17The parameter for the deletion of the files is not set with the config wizard. You have to set it with the following command:
[Linux] OracleRMANConfigTool --set-force-delete <number of days>
[Windows] OracleRMANConfigTool.exe --set-force-delete <number of days>
https://helpcenter.veeam.com/docs/backup/plugins/force_delete_rman.html?ver=110
Jochen (Joe) Meixner | Veeam Vanguard 2024 | Veeam Legend 2021 - 2024 | Veeam Certified Architect (VMCA) | Twitter: @JoMeix | BlueSky: @jmeixner.bsky.social
can we set time for scheduling backup on the database? I referred all the articles where they specified retention policies but not schedule time
+17The retention is set in the RMAN script. Please refer to the Oracle documentation.
The only “retention” parameter you can set in the plugin configuration is the --set-force-delete parameter. And this is more a housekeeping than a retention.
Jochen (Joe) Meixner | Veeam Vanguard 2024 | Veeam Legend 2021 - 2024 | Veeam Certified Architect (VMCA) | Twitter: @JoMeix | BlueSky: @jmeixner.bsky.social
+12Anandu wrote:
can we set time for scheduling backup on the database? I referred all the articles where they specified retention policies but not schedule time
You can't do it in veeam.
You need todo it in oracle rman. Create your full backup script and use the scheduler of the os system to start the script.
Product Management Analyst @ Veeam Software
Mildur wrote:
Anandu wrote:
can we set time for scheduling backup on the database? I referred all the articles where they specified retention policies but not schedule time
You can't do it in veeam.
You need todo it in oracle rman. Create your full backup script and use the scheduler of the os system ro start the script.
Is this possible for windows?
+12Anandu wrote:
Mildur wrote:
Anandu wrote:
can we set time for scheduling backup on the database? I referred all the articles where they specified retention policies but not schedule time
You can't do it in veeam.
You need todo it in oracle rman. Create your full backup script and use the scheduler of the os system ro start the script.
Is this possible for windows?
Yes, windows has the task scheduler to start a script.
A guide I found with google:
https://www.support.dbagenesis.com/post/schedule-rman-backup-on-windows
Product Management Analyst @ Veeam Software
+8I think
You can choose to enable compression or not on RMAN, i prefer to do it after performance test on veeam rather than on rman.
You can up channel (by default 5), it will depend of your load on backup repo and servers.
5 channel = 1Core/Vcpu on backup repo
If you raise numbers of channel rman backup could be faster.
Comment
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.