Is this of any real value?

[GregE]

Oracle RAC - asnodename

I can't wrap my arms around what this really does for me, over the old tried and true method of Oracle TDP configuration. We're soon moving to Oracle RAC so I'm wondering if anyone is using this method and what you gain from it?

http://www-01.ibm.com/support/docview.wss?uid=swg21260228

(slowly getting a grasp. Maybe I need to better grasp how a RAC database "floats" between multiple host servers. The wheels are turning, but the day has been long.

 

[GregE]

Anyone using the asnodename method for Oracle RAC?

Something from the document.......
Note that in this situation, the TDPO_FS option must be set with indentical values for all Data Protection for Oracle nodes involved in the Tivoli Storage Manager asnodename environment.

So this means that if I have 10 DBs on a RAC cluster consisting of 3 Unix servers, all data must be stored in a single filespace?

 

[THE_WIPET]

GregE: we are using RAC with the Oracle GRID. We dont use the ASNODENAME with proxying.. etc... we use the regular "Cluster Configuration" as we do with SQL. But on the grid. the backup is started on one server. I no ORACLE or RAC expert.. But with the DBA feedback. They are able to backup et restore everything they want!

 

[GregE]

Thanks, are you running your Oracle on Unix or Windows?

 

[THE_WIPET]

Solaris and RedHat!

 

[THE_WIPET]

Exemple of my dsm.sys. This is on both of my physical servers.

In solaris they are in the /usr/bin.

************************************************************************
* IBM Tivoli Storage Manager *
* *
* Sample Client System Options file for UNIX (dsm.sys.smp) *
************************************************************************
* This file contains the minimum options required to get started
* using TSM. Copy dsm.sys.smp to dsm.sys. In the dsm.sys file,
* enter the appropriate values for each option listed below and
* remove the leading asterisk (*) for each one.
* If your client node communicates with multiple TSM servers, be
* sure to add a stanza, beginning with the SERVERNAME option, for
* each additional server.
************************************************************************
SErvername tsm_hq
EXCLUDE.DIR "/tmp"
EXCLUDE.DIR "/var/tmp"
EXCLUDE.DIR "/db/admin"
EXCLUDE.DIR "/db/arch"
EXCLUDE.DIR "/db/BIN"
EXCLUDE.FILE "/db/swap1"
MANAGEDSERVICES WEBCLIENT SCHEDULE
SCHEDLOGNAME "/var/tmp/dsmsched.log"
SCHEDMODE PROMPTED
ERRORLOGNAME "/var/tmp/dsmerror.log"
COMMMethod TCPip
TCPPort 1500
TCPServeraddress xxx.xxx.xxx.xxx
PASSWORDACCESS generate

SErvername tsm_archives
EXCLUDE.DIR "/tmp"
EXCLUDE.DIR "/var/tmp"
EXCLUDE.DIR "/db/admin"
EXCLUDE.DIR "/db/arch"
EXCLUDE.DIR "/db/BIN"
EXCLUDE.FILE "/db/swap1"
MANAGEDSERVICES WEBCLIENT SCHEDULE
SCHEDLOGNAME "/var/tmp/dsmsched.log"
SCHEDMODE PROMPTED
ERRORLOGNAME "/var/tmp/dsmerror.log"
COMMMethod TCPip
TCPPort 1502
TCPServeraddress xxx.xxx.xxx.xxx
PASSWORDACCESS generate

SErvername CLUSTER1-2_ORA ( This is the Oracle part()
COMMMethod TCPip
TCPServeraddress XXX.xxx.xxx.xxx.
passwordaccess generate
passworddir /home/oracle
nodename CLUSTER1-2_ORA
inclexcl /usr/bin/include.def


This is the tdpo.opt

***************************************************************************
* IBM Tivoli Storage Manager for Databases
* Data Protection for Oracle
*
* Sample tdpo.opt for the Solaris 64bit Data Protection for Oracle
*********************************************************************
DSMI_ORC_CONFIG /opt/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /var/tmp/
TDPO_FS oracle

*TDPO_NODE CLUSTER1-2_ORA
*TDPO_OWNER oradba
*TDPO_PSWDPATH /home/oracle

TDPO_DATE_FMT 4
TDPO_NUM_FMT 4
TDPO_TIME_FMT 1

*TDPO_MGMT_CLASS_2 mgmtclass2
*TDPO_MGMT_CLASS_3 mgmtclass3
*TDPO_MGMT_CLASS_4 mgmtclass4

dsm.opt file in the oracle/bin64 folder
************************************************************************
* IBM Tivoli Storage Manager *
* *
* Sample Client User Options file for UNIX (dsm.opt.smp) *
************************************************************************
* This file contains an option you can use to specify the TSM
* server to contact if more than one is defined in your client
* system options file (dsm.sys). Copy dsm.opt.smp to dsm.opt.
* If you enter a server name for the option below, remove the
* leading asterisk (*).
************************************************************************
* SErvername A server name defined in the dsm.sys file
SERVERNAME CLUSTER1-2_ORA


This is the include.def file. store in /usr/bin
include /oracledbname1/.../* oracle
include /oracledbname2/.../* oracle
include /oracledbname3/.../* oracle

 

[GregE]

Thank you! Do you only have one oracle database you are backing up?
nodename CLUSTER1-2_ORA

 

[THE_WIPET]

the dbs are in the include.def files and redirtected on a special management class that let RMAN controle the retention.
One system, we have 7 differents DB's that are on one RAC servers.

 

[THE_WIPET]

tdpo_fsSpecify a file space name on the Tivoli Storage Manager server for Data Protection for Oracle backup, delete, and restore operations. The file space name can contain a string of 1 to 1024 characters.

• The default file space name is adsmorc.
• When you have more than one Oracle database, use this option to back up each Oracle target database to its own file space on the Tivoli Storage Manager server.
• If this option was set during Data Protection for Oracle backup operations, this option must be set during restore and delete operations.
• The file space name in the include/exclude statement must match the file space name specified in the tdpo_fs option for include/exclude processing to function correctly.

 

[GregE]

Thanks for your info, I appreciate it.

In your RAC environment, you said the backup is started on one server. What is starting the backup? And how does it know which server the database is actually running from?

We call our backups with an enterprise scheduler, and in a Veritas cluster situation (our current cluster method), we use a virtual IP which sends the call to the "Active" server in the cluster.

But as we are about to move to Oracle RAC, how is the backup called?

 

[THE_WIPET]

All our Oracle backup are call from Oracle Grid the DBA manage the schedule. Same for SAP, We use Brtool and SAP scheduler. So how the grid is setup i dont know but i'll ask my DBA how they did it. The only thing that i know is it'sthe same one server of the active server that the grid call.

 

[GregE]

Do you use Storage Agent to back up these databases? Do you have it installed on the servers that make up the grid? Is it clustered using a cluster product? I'm just trying to figure out how a backup can failover in a RAC setup. I assume the same as a non-RAC, meaning you need a separate cluster product to handle it.