Video Screencast Help

Netbackup rman script for multiple instances on same host

Created: 26 Feb 2013 • Updated: 27 Feb 2013 | 2 comments
This issue has been solved. See solution.

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.



Operating Systems:

Comments 2 CommentsJump to latest comment

Yasuhisa Ishikawa's picture

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?

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

Andrew Madsen's picture

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.

The above comments are not to be construed as an official stance of the company I work for; hell half the time they are not even an official stance for me.