07-15-2010 10:07 PM
Solved! Go to Solution.
07-15-2010 11:19 PM
07-15-2010 10:27 PM
07-15-2010 10:36 PM
07-15-2010 10:49 PM
07-15-2010 10:51 PM
07-15-2010 11:19 PM
07-15-2010 11:48 PM
07-16-2010 06:19 AM
07-18-2010 11:27 PM
07-19-2010 01:47 AM
From what I'm reading, you are perhaps trying to backup the "sub" SIDs? Each active node in the RAC will have <sid><instance>, so in your case, bwdb is possibly the actual SID, and bwdb1 in running on node 1, and bwdb2 is running on node 2?
If that is not the case, and these are actually two separate databases, I think you should use another approach. When using the SID, the Oracle listener will re-direct the request to the next node in queue (like round-robin), as this distributes the query load.
Using the VIP address as required interface in NBU could potentially add backup/restore issues. I always use the physical node's IP address, and use two NBU policies; one for Default-Application-Backup schedule, and one "kick-off" policy. The first policy lists all possible phyiscal nodes in the RAC, and have a dummy backup selection (never used), as no backups will ever be started using this poilcy. The kick-off policy will use the VIP hostname, and the executing script as backup selection.
In your backup scripts it looks as if you use both VIP to allocate channels, why? I think this may add problems.
I suggest you only run the backup on one node, especially as you don't seem to use RMAN Catalog. This will only add to more work if you have to restore the complete database.
Change the allocate channel to somethins along the lines for bwdb1;
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS='ENV='NB_ORA_SERV=adsrv-01,NB_ORA_POLICY=bwdb' CONNECT='sys/oracle@bwdb1';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS='ENV='NB_ORA_SERV=adsrv-01,NB_ORA_POLICY=bwdb' CONNECT='sys/oracle@bwdb1';
and for bwdb2;
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS='ENV='NB_ORA_SERV=adsrv-01,NB_ORA_POLICY=bwdb' CONNECT='sys/oracle@bwdb2';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS='ENV='NB_ORA_SERV=adsrv-01,NB_ORA_POLICY=bwdb' CONNECT='sys/oracle@bwdb2';
/A
07-19-2010 08:32 PM
07-19-2010 08:40 PM
07-19-2010 10:18 PM
08-01-2010 06:45 PM
08-02-2010 01:17 AM
08-03-2010 07:16 AM