Re: TDP for Oracle in AIX - Problem
Issue got Resolved. Thanks for all ur Support... Oracle Corporation has recommended to configure the TDP for Oracle in both the nodes and the both the nodes RMAN configuration as below.. - RMAN show all; RMAN configuration parameters are: CONFIGURE RETENTION POLICY TO REDUNDANCY 30; CONFIGURE BACKUP OPTIMIZATION OFF; CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE'; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F'; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2; CONFIGURE DEVICE TYPE DISK PARALLELISM 2; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1; CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' FORMAT BACKUP_%U CONNECT 'sys/s...@icropdb01'; CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)' FORMAT BACKUP_%U CONNECT 'sys/s...@icropdb02'; CONFIGURE MAXSETSIZE TO UNLIMITED; CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/product/9i/dbs/snapcf_icropdb01.f'; # default RMAN - In the above configuration, you can find two channels has been configured to communicate with both the nodes. So, the backup will happen from both the nodes coz the Oracle Undo files and Archive logs are unique in both the nodes. TSM Client and TDP for Oracle Configuration refer the below link.. http://www-01.ibm.com/support/docview.wss?uid=swg21260228 Backup is happening successfully now. Regards, Wellington Kirubhakaran M K Senior Engineer - Storage Management Wipro Infotech 88, MG Road, SB Towers, Bangalore - 560001, Karnataka, India Mob: +91 97400 68478 | Ph: +91 80 66292319 Email: wellington.kirubhaka...@wipro.com | Website: www.wipro.com -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of David McClelland Sent: Friday, November 13, 2009 10:34 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for Oracle in AIX - Problem But, I need to allocate two channels coz it Oracle 9i RAC DB(2 nodes)... That statement doesn't ring true with me - cards on the table, I'm not a DBA (so I may be missing a finer point of your Oracle config), but from working with quite a few RAC DB backups (and restores) using RMAN/TDPO over the years that's something that doesn't match my experiences. I perform a backup from one of the RAC nodes (any one in fact) allocating a single channel if that suits. I can perform a backup of the database from any node in the RAC, and restore it to any node in the RAC. Fundamentally, it's all the same database. I'd think about using two channels when backing up directly to tape (e.g. using the SAN Storage Agent) and wanted to maximise throughput. /David Mc London, UK -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Wellington KMK Sent: 13 November 2009 16:51 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for Oracle in AIX - Problem I had put the below entry in my dsm.sys file.. INCLUDE /ICROPDB/.../* TKMLMC_ORACLE And also the Management Class and copy group in the TSM Server side also. I had set the maxnummp as 2 set the resourceutilization as 5 in dsm.sys file... If I allocate single channel backup is happening successfully. But, I need to allocate two channels coz it Oracle 9i RAC DB(2 nodes)... Regards, Wellington Kirubhakaran M K Senior Engineer - Storage Management Wipro Infotech 88, MG Road, SB Towers, Bangalore - 560001, Karnataka, India Mob: +91 97400 68478 | Ph: +91 80 66292319 Email: wellington.kirubhaka...@wipro.com | Website: www.wipro.com -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Grigori Solonovitch Sent: Friday, November 13, 2009 10:05 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for Oracle in AIX - Problem It looks you have problem with backup destination (default is used). Have you configured Include/Exclude list for Oracle backups at client side? Management class and copy group at TSM Server site? From: ADSM: Dist Stor Manager [ads...@vm.marist.edu] On Behalf Of Wellington KMK [wellington.kirubhaka...@wipro.com] Sent: Friday, November 13, 2009 6:48 PM To: ADSM-L@VM.MARIST.EDU
Re: TDP for Oracle in AIX - Problem
Hi Wellington, Is anything showing up on your TSM Server actlog at the same time? I'm wondering if you have enough mount points allocated for that client node (e.g. UPDATE NODE NODE_TDPO MAXNUMMP=4). Also, for RAC config best practices, check out this useful article from IBM.COM: http://www-01.ibm.com/support/docview.wss?uid=swg21260228 I'm working on a similar config for a customer at the moment on Linux, works a treat using this method. Rgds, /David Mc London, UK -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Wellington KMK Sent: 13 November 2009 15:48 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TDP for Oracle in AIX - Problem Dear All, I am trying to configure TDP for Oracle Client on Oracle 9i RAC Database. We have two nodes in the RAC. TSM Server Information OS : AIX V5.3 TSM : V5.5 TSM Client Information OS : AIX V5.3 TSM BA Client API Client : V5.5.0.0 TDP : V5.4.1.0 Oracle : 9i RAC(Two Active Nodes) --- In the RMAN prompt if I configure two channels try to backup. it throws error as Failed to load media management library. RMAN backup database; Starting backup at 13-NOV-09 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure of backup command at 11/13/2009 16:07:52 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library Additional information: 2 If I configure single channel for one node backup is happening successfully. Is there any specific setting needs to be done for Oracle 9i RAC backup? Best practice to backup the Oracle 9i RAC DB? Regards, Wellington Kirubhakaran M K Senior Engineer - Storage Management Wipro Infotech 88, MG Road, SB Towers, Bangalore - 560001, Karnataka, India Mob: +91 97400 68478 | Ph: +91 80 66292319 Email: wellington.kirubhaka...@wipro.com | Website: www.wipro.com Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.707 / Virus Database: 270.14.62/2499 - Release Date: 11/12/09 14:33:00
Re: TDP for Oracle in AIX - Problem
It looks you have problem with backup destination (default is used). Have you configured Include/Exclude list for Oracle backups at client side? Management class and copy group at TSM Server site? From: ADSM: Dist Stor Manager [ads...@vm.marist.edu] On Behalf Of Wellington KMK [wellington.kirubhaka...@wipro.com] Sent: Friday, November 13, 2009 6:48 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TDP for Oracle in AIX - Problem Dear All, I am trying to configure TDP for Oracle Client on Oracle 9i RAC Database. We have two nodes in the RAC. TSM Server Information OS : AIX V5.3 TSM : V5.5 TSM Client Information OS : AIX V5.3 TSM BA Client API Client : V5.5.0.0 TDP : V5.4.1.0 Oracle : 9i RAC(Two Active Nodes) --- In the RMAN prompt if I configure two channels try to backup. it throws error as Failed to load media management library. RMAN backup database; Starting backup at 13-NOV-09 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure of backup command at 11/13/2009 16:07:52 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library Additional information: 2 If I configure single channel for one node backup is happening successfully. Is there any specific setting needs to be done for Oracle 9i RAC backup? Best practice to backup the Oracle 9i RAC DB? Regards, Wellington Kirubhakaran M K Senior Engineer - Storage Management Wipro Infotech 88, MG Road, SB Towers, Bangalore - 560001, Karnataka, India Mob: +91 97400 68478 | Ph: +91 80 66292319 Email: wellington.kirubhaka...@wipro.com | Website: www.wipro.com Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com Please consider the environment before printing this Email. This email message and any attachments transmitted with it may contain confidential and proprietary information, intended only for the named recipient(s). If you have received this message in error, or if you are not the named recipient(s), please delete this email after notifying the sender immediately. BKME cannot guarantee the integrity of this communication and accepts no liability for any damage caused by this email or its attachments due to viruses, any other defects, interception or unauthorized modification. The information, views, opinions and comments of this message are those of the individual and not necessarily endorsed by BKME.
Re: TDP for Oracle in AIX - Problem
I had put the below entry in my dsm.sys file.. INCLUDE /ICROPDB/.../* TKMLMC_ORACLE And also the Management Class and copy group in the TSM Server side also. I had set the maxnummp as 2 set the resourceutilization as 5 in dsm.sys file... If I allocate single channel backup is happening successfully. But, I need to allocate two channels coz it Oracle 9i RAC DB(2 nodes)... Regards, Wellington Kirubhakaran M K Senior Engineer - Storage Management Wipro Infotech 88, MG Road, SB Towers, Bangalore - 560001, Karnataka, India Mob: +91 97400 68478 | Ph: +91 80 66292319 Email: wellington.kirubhaka...@wipro.com | Website: www.wipro.com -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Grigori Solonovitch Sent: Friday, November 13, 2009 10:05 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for Oracle in AIX - Problem It looks you have problem with backup destination (default is used). Have you configured Include/Exclude list for Oracle backups at client side? Management class and copy group at TSM Server site? From: ADSM: Dist Stor Manager [ads...@vm.marist.edu] On Behalf Of Wellington KMK [wellington.kirubhaka...@wipro.com] Sent: Friday, November 13, 2009 6:48 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TDP for Oracle in AIX - Problem Dear All, I am trying to configure TDP for Oracle Client on Oracle 9i RAC Database. We have two nodes in the RAC. TSM Server Information OS : AIX V5.3 TSM : V5.5 TSM Client Information OS : AIX V5.3 TSM BA Client API Client : V5.5.0.0 TDP : V5.4.1.0 Oracle : 9i RAC(Two Active Nodes) --- In the RMAN prompt if I configure two channels try to backup. it throws error as Failed to load media management library. RMAN backup database; Starting backup at 13-NOV-09 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure of backup command at 11/13/2009 16:07:52 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library Additional information: 2 If I configure single channel for one node backup is happening successfully. Is there any specific setting needs to be done for Oracle 9i RAC backup? Best practice to backup the Oracle 9i RAC DB? Regards, Wellington Kirubhakaran M K Senior Engineer - Storage Management Wipro Infotech 88, MG Road, SB Towers, Bangalore - 560001, Karnataka, India Mob: +91 97400 68478 | Ph: +91 80 66292319 Email: wellington.kirubhaka...@wipro.com | Website: www.wipro.com Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com Please consider the environment before printing this Email. This email message and any attachments transmitted with it may contain confidential and proprietary information, intended only for the named recipient(s). If you have received this message in error, or if you are not the named recipient(s), please delete this email after notifying the sender immediately. BKME cannot guarantee the integrity of this communication and accepts no liability for any damage caused by this email or its attachments due to viruses, any other defects, interception or unauthorized modification. The information, views, opinions and comments of this message are those of the individual and not necessarily endorsed by BKME. Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via
Re: TDP for Oracle in AIX - Problem
But, I need to allocate two channels coz it Oracle 9i RAC DB(2 nodes)... That statement doesn't ring true with me - cards on the table, I'm not a DBA (so I may be missing a finer point of your Oracle config), but from working with quite a few RAC DB backups (and restores) using RMAN/TDPO over the years that's something that doesn't match my experiences. I perform a backup from one of the RAC nodes (any one in fact) allocating a single channel if that suits. I can perform a backup of the database from any node in the RAC, and restore it to any node in the RAC. Fundamentally, it's all the same database. I'd think about using two channels when backing up directly to tape (e.g. using the SAN Storage Agent) and wanted to maximise throughput. /David Mc London, UK -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Wellington KMK Sent: 13 November 2009 16:51 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for Oracle in AIX - Problem I had put the below entry in my dsm.sys file.. INCLUDE /ICROPDB/.../* TKMLMC_ORACLE And also the Management Class and copy group in the TSM Server side also. I had set the maxnummp as 2 set the resourceutilization as 5 in dsm.sys file... If I allocate single channel backup is happening successfully. But, I need to allocate two channels coz it Oracle 9i RAC DB(2 nodes)... Regards, Wellington Kirubhakaran M K Senior Engineer - Storage Management Wipro Infotech 88, MG Road, SB Towers, Bangalore - 560001, Karnataka, India Mob: +91 97400 68478 | Ph: +91 80 66292319 Email: wellington.kirubhaka...@wipro.com | Website: www.wipro.com -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Grigori Solonovitch Sent: Friday, November 13, 2009 10:05 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TDP for Oracle in AIX - Problem It looks you have problem with backup destination (default is used). Have you configured Include/Exclude list for Oracle backups at client side? Management class and copy group at TSM Server site? From: ADSM: Dist Stor Manager [ads...@vm.marist.edu] On Behalf Of Wellington KMK [wellington.kirubhaka...@wipro.com] Sent: Friday, November 13, 2009 6:48 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TDP for Oracle in AIX - Problem Dear All, I am trying to configure TDP for Oracle Client on Oracle 9i RAC Database. We have two nodes in the RAC. TSM Server Information OS : AIX V5.3 TSM : V5.5 TSM Client Information OS : AIX V5.3 TSM BA Client API Client : V5.5.0.0 TDP : V5.4.1.0 Oracle : 9i RAC(Two Active Nodes) --- In the RMAN prompt if I configure two channels try to backup. it throws error as Failed to load media management library. RMAN backup database; Starting backup at 13-NOV-09 RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03002: failure of backup command at 11/13/2009 16:07:52 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27211: Failed to load Media Management Library Additional information: 2 If I configure single channel for one node backup is happening successfully. Is there any specific setting needs to be done for Oracle 9i RAC backup? Best practice to backup the Oracle 9i RAC DB? Regards, Wellington Kirubhakaran M K Senior Engineer - Storage Management Wipro Infotech 88, MG Road, SB Towers, Bangalore - 560001, Karnataka, India Mob: +91 97400 68478 | Ph: +91 80 66292319 Email: wellington.kirubhaka...@wipro.com | Website: www.wipro.com Please do not print this email unless it is absolutely necessary. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com Please consider the environment before printing this Email. This email message and any attachments transmitted with it may contain confidential and proprietary information, intended only for the named recipient(s). If you have received this message in
Re: TDP for Oracle in AIX - Problem
-Wellington Kirubhakaran M K wrote: - I had put the below entry in my dsm.sys file.. INCLUDE /ICROPDB/.../* TKMLMC_ORACLE And also the Management Class and copy group in the TSM Server side also. I had set the maxnummp as 2 set the resourceutilization as 5 in dsm.sys file... If I allocate single channel backup is happening successfully. But, I need to allocate two channels coz it Oracle 9i RAC DB(2 nodes)... My site has a number of HP-UX Oracle servers. We used to send incoming backups to storage pools composed of sequential disk volumes (which TSM treats like tape volumes with respect to mount points and mount point limits), and data for Oracle restores is almost always read from tape. We started off setting maxnummp equal to the number of backup or restore streams TDP was configured for, and got lots of sessions failing with messages indicating that the client was trying to use too many mount points. We eliminated the problem by setting maxnummp to twice the number of streams TDP was configured for. We have never figured out why the extra mount points are needed.