Skip to main content
commvault.com commvault.com
Question

Oracle Database Appliance (ODA-HA) Backup

  • February 12, 2025
  • 1 reply
  • 41 views
M
Byte
Forum|alt.badge.img+2

Hello everyone,

our DBAs are currently in the process of consolidating our Oracle databases onto new ODAs.
These have HA capabilities with two nodes each and shared storage underneath.

We already have a single node ODA for a while and we are doing regular Oracle agent backups on it.

For the new HA ODAs the plan is to set up databases on fixed nodes and only switch to another node in case of an issue.
So under normal circumstances backups will be just fine running directly from the node associated with the database.

 

I was wondering if there is any possibility to set up this kind of HA inside Commvault?

As far as I understand from my DBAs Oracle RAC is working a bit different with active-active configurations and is therefore not a suitable solution in our case.

 

Maybe someone has a similar setup to share their experience with ODAs?

 

Thanks in advance for any advice!

1 reply

M
Byte
Forum|alt.badge.img+2
  • Marcel_RE
  • Author
  • Byte
  • 4 replies
  • March 4, 2025

For anyone facing the same challenge, here is what I ended up with for this setup:

  • Put the ODA HA nodes in an Oracle RAC pseudo client
  • Configure the database(s) with the primary node first and the other one(s) (which will only host the databse in case of a failover) afterwards
  • Set the log threshold streams on the subclients to 1

Backups will then be streamed from the primary node and switch to the other nodes(s) in case of a failover.

A backup after a failover will also result in a critical event which says that the database is offline on the primary node.

This event will also occur if the primary node was not configured first because Commvault will try to stream from one of the failover nodes first which is not possible as the database is only open on one node at a time.

One small annoyance I noticed later on is that this critical event will also occur on a daily basis as the agent seems to check the database availability every 24h.

But to have a continous backup in case of a failover it seems you would need to accept that (at least to my knowledge).

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings