Skip to main content
  • EN

If Oracle backup provided over backup job with application aware processing, has limitation with restore i regards of number of channels.

 

Restore via gui is possible over Veeam Enterprise and via Veeam Oracle Explorer:

  1. Veeam Enterprise Manager is restore possible only via 1 channel
  2. Veeam Oracle Explorer by default has set 1 channel

 

To change number of channels for Veeam Enterprise manager is not possible, but is possible to change number of channels via Veeam Oracle Explorer via config.xml file:

 

%programdata%\Veeam\Backup\OracleExplorer\Config.xml

 

Content example:

 

<Veeam>
  <OracleExplorer>
    <Oracle RmanCopyJobChannelsCount="4" />
    <Oracle RmanCopyJobChannelsByDatafilesCount="true" />
  </OracleExplorer>
</Veeam>

 

 

Our tests speed:

>> - 1 channel: - 115 GB, 18 mins 109 MByte/sec

>> - 4 channels: - 115 GB, 15 mins 130 Mbyte/sec

>> - 12 channels: - 115 GB, 14 mins 135 Mbyte/sec

 

The speed could not be much difference, but in case of TB of data in database, RTO could be different in hours.

Interesting Marcel. I don’t backup or mess with Oracle much so wasn’t aware. Nice to know # of channels can be modified to hopefully provide better restore performance. Thanks for sharing.

It is interesting to see how going from 1 to 4 channels is the biggest jump in both timing and speed of backup but then hitting 12 is not a lot of difference.  Interesting to see and how you can tweak this.

Nice one 🙂

Comment


Terms & Conditions