Solved

Oracle RMAN backup

  • 11 November 2021
  • 9 comments
  • 925 views

Userlevel 7
Badge +1

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?

icon

Best answer by JMeixner 11 November 2021, 09:15

View original

9 comments

Userlevel 7
Badge +12

Ir 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.

Userlevel 7
Badge +17

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.

Userlevel 7
Badge +17

The 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

Userlevel 7
Badge +1

can we set time for scheduling backup on the database? I referred all the articles where they specified retention policies but not schedule time

Userlevel 7
Badge +17

The 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.

Userlevel 7
Badge +12

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.

 

 

https://docs.oracle.com/database/121/ADMQS/GUID-D77B0526-13F6-4570-9C74-6436B76DEA43.htm#GUID-D3CFC309-9F8B-4C48-B7EB-97EA66FE8315

Userlevel 7
Badge +1

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.

 

 

https://docs.oracle.com/database/121/ADMQS/GUID-D77B0526-13F6-4570-9C74-6436B76DEA43.htm#GUID-D3CFC309-9F8B-4C48-B7EB-97EA66FE8315

Is this possible for windows?

Userlevel 7
Badge +12

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.

 

 

https://docs.oracle.com/database/121/ADMQS/GUID-D77B0526-13F6-4570-9C74-6436B76DEA43.htm#GUID-D3CFC309-9F8B-4C48-B7EB-97EA66FE8315

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

Userlevel 7
Badge +8

I think @Mildur and @JMeixner  gave you the most important informations about it.

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