Skip to main content
Question

Do Oracle DB restores supports multiple streams?

  • October 30, 2023
  • 4 replies
  • 301 views

PedroRocha
Novice
Forum|alt.badge.img+10

Hi,

 

I see that the stream count is defaulted to 2. But I also read the all restores are single streamed except for a few iDAs. And oracle iDA is not one of them.

 

Regards,

Pedro

4 replies

Chris Hollis
Vaulter
Forum|alt.badge.img+14
  • Vaulter
  • October 30, 2023

Hi @PedroRocha 

As per this article: https://documentation.commvault.com/2023e/expert/92576_multi_stream_restore_operations.html

Oracle doesn’t support multiple stream restores: 


Hopefully this helps,


Regards,​​​​​​​

Chris


  • November 29, 2023

Hi @PedroRocha 

As per this article: https://documentation.commvault.com/2023e/expert/92576_multi_stream_restore_operations.html

Oracle doesn’t support multiple stream restores: 


Hopefully this helps,


Regards,

Chris

Is this something that will be changing in the future or is there a feature request for multiple streams for Oracle iDA restores?


PedroRocha
Novice
Forum|alt.badge.img+10
  • Author
  • Novice
  • December 5, 2023

Hi,

 

I notice that changing the stream count to higher number caused RMAN to allocate and use more channels during the datafile restoration process. 

What does that mean?

I notice though that archive log restore operation used only one channel.

 

Regards,

Pedro


Forum|alt.badge.img+4
  • Novice
  • December 6, 2023

Hi

I am pretty sure you can run multiple channels with RMAN, but this depends whether you have Standard or Enterprise Edition of Oracle from memory - Standard only allows one channel

I looked at this many years ago, to speed up some Oracle backups / restore times which luckily had Enterprise Edition

You had to backup with multiple streams, to restore with multiple streams eg: 1 backup stream cannot be two restore streams!