02-26-2013 08:09 AM
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
Solved! Go to Solution.
02-27-2013 03:28 AM
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.
02-26-2013 04:19 PM
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?
02-27-2013 03:28 AM
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.