"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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Wellington KMK
Sent: 13 November 2009 16:51
To: ADSM-L AT VM.MARIST DOT 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.kirubhakaran AT wipro DOT com | Website: www.wipro.com
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Grigori Solonovitch
Sent: Friday, November 13, 2009 10:05 PM
To: ADSM-L AT VM.MARIST DOT 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 [ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Wellington KMK [wellington.kirubhakaran AT WIPRO DOT COM]
Sent: Friday, November 13, 2009 6:48 PM
To: ADSM-L AT VM.MARIST DOT 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.kirubhakaran AT wipro DOT 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 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
|
