Multiple Oracle DB/Instances on single machine, how to include in one script.
I am in desperate need of some assitance configuring Oracle Database backups and i would really value your suggestions and input.
We have two Oracle Database servers running on HP-UX with multiple database instances running on them, we shall call them node6 and node7.
Each servers houses approximately 60-70 small databases ranging from 2GB to about 80GB in size.
The problem is not the size but rather the amount of database instances, this involves a backup script for each database instance, which is becoming a nightmare to setup firstly and then to get backed up. We have written a script that copies and edits the Netbackup RMAN template into individual scripts that get added into Netbackup.
We have configured a policy per server and then added all of the scripts into the policies but in my eyes this is rather inefficient and cumbersome, as the backup will backup each DB one by one which takes over 24 hours, the other option we tried but was even worse was a policy per script, HORRIBLE idea.
So my question is, (and yes i have googled to the point of raw fingers) to find a solution similar to the Microsoft SQL Agent backups where you can have one script and just specify $ALL to backup any added or removed database from the server, is there any similar way to do this with Oracle?
I have also looked through the Netbackup for Oracle guide but cannot find anything unless i am missing it.
I have come across a post detailing the use of a file called db_channels which allows you to specify RMAN to use a channel per Database in the script but was wondering if anyone has tried this or knows of a way.
You assistance in this matter will be highly appreicated.