Oracle RAC backups

[Peaches_K]

Hi,

We have around 200 RAC DBs. We are trying to add them into Netbackup using oracle scripts.

We have a script that will backup each DB , so this way we will have one policy per cluster and in the backup selection we can have several scripts - one for each db.

The client requirement is to have one generic script - which will pull the online dbs in each cluster and run backups on it. This way, we can have very few policies in netbackup and deploy the generic script for all clusters.

I want to know -- how are oracle dbs in large environments backed up. Are we in the right direction to have a generic script. If we go for one script per DB, we will have lot of manual work and numerous policies and plenty of scripts in backup selection of each policy. What should be our approach.

Request your suggestions on this.

[RamNagalla]

Hello,

i would suggest to go with below approch to minimize number of policies and manual work. however it will require 3rd party scheduler or cron on each DB server needs to be used to trigger the backups.

1) create one Generic policy for oracle DB and another one of Oracle log

2) Do not put any Automatic schedule, however make sure application is schedule is avaliable.

3) Add all oracle client names into client of policy

4) Do not add anything in backup selection.

in DB side

in RMAN script, use NB_ORA_POLICY = <Netbackup policy Name>  then trigger the RMAN script using the cron or 3rd party scheduler.

[Peaches_K]

Hi Ram,

Thanks for your response.

This would still mean we need to have one script for each DB. We would like to have one script per cluster and that script should backup all online DBs in that cluster. --> Is this approach commonly used in large Oracle environments.

Thanks