cancel
Showing results for 
Search instead for 
Did you mean: 

Netbackup rman script for multiple instances on same host

Abhishek_Shar1
Level 3

Hi All,


We are doing oracle agent based backups and to backup multiple Oracle instances on a same host we have to create a seperate script for each

instance and a seperate policy for each instance. 

Is it possible if we can backup all Oracle instances using one policy and this can be achieved from one RMAN script ...?

As in the rman script we mention only one Oracle SID , if somehow we can mention multiple SID.

Please if you can suggest a solution /workaround for this as creating new policy for each instance will increase the number of policies.

 

Regards,

Abhishek

1 ACCEPTED SOLUTION

Accepted Solutions

Andrew_Madsen
Level 6
Partner

The way you describe your desired endstate is how we do it at our data center. We serialize the backups on multiple data base instances on a single server to a single policy. No muss no fuss no bother.

View solution in original post

2 REPLIES 2

Yasuhisa_Ishika
Level 6
Partner Accredited Certified

It is possible by modifying the script so that it rman command for each SID changing ORACLE_SID environment.

BTW, why don't you consider adding multiple backup script(or template) for each instance into single policy?

Andrew_Madsen
Level 6
Partner

The way you describe your desired endstate is how we do it at our data center. We serialize the backups on multiple data base instances on a single server to a single policy. No muss no fuss no bother.