Re: RMAN error allocating TDP channel....
After Creating the symbolic link... Please check the oracle user having read & write access on below files... 1) dsmerror.log 2) tdpoerror.log 3) TSM.PWD(tsm password file) Test the connectivity from oracle user by issuing the below cmd... Tdpoconf showenv -tdpo_optfile= Regards, Wellington -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Grigori Solonovitch Sent: Monday, January 18, 2010 10:27 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] RMAN error allocating TDP channel I have no experience with Solaris, but in AIX after installing TDP (I hope you have installed 5.5.2 not 5.2.0) you need to link TDP library in $ORACLE_HOME/lib to TDP directory: [LPAR05]>ls -ltr $ORACLE_HOME/lib/*obk* lrwxrwxrwx1 oracle dba 19 Jun 24 2007 /home/oracle/product/10g/lib/libobk.a -> /usr/lib/libobk64.a [LPAR05]> Maybe you need to do the same. Grigori G. Solonovitch Senior Technical Architect Information Technology Bank of Kuwait and Middle East http://www.bkme.com Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail: g.solonovi...@bkme.com Please consider the environment before printing this Email -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Mario Behring Sent: Monday, January 18, 2010 5:13 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] RMAN error allocating TDP channel Hi list, I´ve installed TDP for Oracle 5.2.0.0 on a Solaris 8 machine. The BA Client is 5.5.2.0 and works fine. I am getting an RMAN error when trying to execute a RMAN backup script. Looks like RMAN cannot allocate a channel through TDP Oracle RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03007: retryable error occurred during execution of command: allocate RMAN-07004: unhandled exception during command execution on channel t1 RMAN-10035: exception raised in RPC: ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-19557: device error, device type: SBT_TAPE, device name: ORA-27000: skgfqsbi: failed to initialize storage subsystem (SBT) layer SVR4 Error: 106: Error 106 Additional information: 7011 ORA-19511: SBT error = 7011, errno = 106, sbtopen: system error RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.DEVICEALLOCATE Any help is appreciated. Mario 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 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
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?
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:
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
Microsoft Cluster Server - Bare Metal Recovery
Hi, I need to plan BMR for two Microsoft Cluster Servers(Failover Cluster). Is the below steps are enough or something need to add up for cluster services.. Backup Plan i) Backup all local drives ii) Backup shared drives iii) System State Backup Restoration Plan i) Install the OS & network drivers ii) Install the TSM Client iii) Restore the data (local drives & shared drives) iv) Apply Systemstate backup v) Restart the Server. Please correct me if I miss anything... TSM Server Details Version 5.5 OS AIX 5.3 Regards, Wellington K 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