how to install and configure tdp for oracle on rac on solaris

badoo

ADSM.ORG Member
Joined
Sep 22, 2008
Messages
20
Reaction score
0
Points
0
how to install and configure tdp for oracle on rac on solaris and especially how to make the scheduler on the rac to take backup in the failover status .

and thanks
 
below are steps to configure TDP oracle on AIX but on Solaris it should be same steps with different file system path

this steps can be used on rac also if you have rac cluster on two different server's you need to configure tdp on both server with same settings,
as per my knowledge the service will be running on only one server,
or you can configure sched start and stop script under rac app as well

1. Register the node to the Tivoli Storage Manager server with the following command:
[FONT=LDCKB F+ Book Master] [/FONT]
[FONT=LDCKB F+ Book Master]REG[FONT=LDCKB F+ Book Master] NODE hostname_oracle password maxnummp=2 [/FONT][/FONT]
[FONT=LDCIH J+ Palatino] [/FONT]
[FONT=LDCIH J+ Palatino]Where [FONT=LDCJA H+ Palatino]hostname [/FONT][FONT=LDCIH J+ Palatino]is the name of the machine where Data Protection for Oracle is installed and [/FONT][FONT=LDCJA H+ Palatino]password [/FONT][FONT=LDCIH J+ Palatino]is the password for this node.[/FONT][/FONT]

2. [FONT=LDCIH J+ Palatino]Install Data Protection for Oracle. [/FONT]
[FONT=LDCIH J+ Palatino] [/FONT]
[FONT=LDCIH J+ Palatino]3. Link the Oracle target database instance with Data Protection for Oracle by performing the following steps[FONT=LDCIH J+ Palatino][/FONT][/FONT]
a. Set the Oracle LD_LIBRARY_PATH option to specify [FONT=LDCIH J+ Palatino]/oracle/rdbms/ as the first entry:[FONT=LDCIH J+ Palatino][/FONT][/FONT]
[FONT=LDCIH J+ Palatino]LD_LIBRARY_[FONT=LDCIH J+ Palatino]PATH[/FONT][FONT=LDCIH J+ Palatino]=/oracle/rdbms/lib[/FONT][/FONT]
[FONT=LDCIH J+ Palatino]b. Shut down all Oracle instances that use [FONT=LDCIH J+ Palatino]/oracle/rdbms/[/FONT][FONT=LDCIH J+ Palatino][/FONT][/FONT]
[FONT=LDCIH J+ Palatino]c. Go to the [FONT=LDCIH J+ Palatino]/oracle/rdbms/[/FONT][FONT=LDCIH J+ Palatino] [/FONT]directory.[/FONT]
d. Symbolically link the library file to [FONT=LDCJA H+ Palatino]libobk.a[/FONT]
ln -s /usr/lib/libobk64.a [FONT=LDCIH J+ Palatino]/oracle/rdbms/lib/libobk.a[/FONT]
e. [FONT=LDCIH J+ Palatino]Start the Oracle instances.[/FONT]
[FONT=LDCIH J+ Palatino] [/FONT]
4. [FONT=LDCIH J+ Palatino]Make sure the following link exists: [/FONT]
[FONT=LDCIH J+ Palatino] /oracle/rdbms[FONT=LDCKB F+ Book Master]/lib/libobk.a -> /usr/lib/libobk64.a [/FONT][FONT=LDCIH J+ Palatino][/FONT][/FONT]
[FONT=LDCKB F+ Book Master] [/FONT]
5. [FONT=LDCIH J+ Palatino]Edit the [FONT=LDCKB F+ Book Master]/usr/tivoli/tsm/client/oracle/bin64/[/FONT][FONT=LDCIH J+ Palatino]tdpo.opt[/FONT][FONT=LDCIH J+ Palatino] file to include these options[/FONT][/FONT]
[FONT=LDCIH J+ Palatino] [/FONT]
[FONT=LDCIH J+ Palatino] [/FONT]DSMI_ORC_CONFIG /usr/tivoli/tsm/client/oracle/bin64/dsm.opt
DSMI_LOG /usr/tivoli/tsm/client/oracle/bin64/
TDPO_FS adsmorc
TDPO_NODE PROD1_ORADB
TDPO_OWNER PROD1_ORADB
TDPO_PSWDPATH /usr/tivoli/tsm/client/oracle/bin64[FONT=LDCIH J+ Palatino][/FONT]
[FONT=LDCIH J+ Palatino] [/FONT]
6. [FONT=LDCIH J+ Palatino]In this same directory ([FONT=LDCKB F+ Book Master]/usr/[/FONT][FONT=LDCKB F+ Book Master]tivoli[/FONT][FONT=LDCKB F+ Book Master]/tsm/client/oracle/bin64/)[/FONT][FONT=LDCIH J+ Palatino], create a dsm.opt file. [/FONT][/FONT]
[FONT=LDCIH J+ Palatino] Edit the dsm.opt file to include the following server stanza: [/FONT]
[FONT=LDCIH J+ Palatino] [/FONT]
SErvername TDPORA[FONT=LDCKB F+ Book Master][/FONT]
[FONT=LDCKB F+ Book Master] [/FONT]
[FONT=LDCKB F+ Book Master] [/FONT]7. Edit [FONT=LDCKB F+ Book Master]usr/tivoli/tsm/client/ba/bin/dsm.sys file to include another server stanza with the following options[/FONT]
[FONT=LDCKB F+ Book Master] [/FONT]
SErvername TDPORA
PASSWORDACCESS prompt
NODENAME PROD1_ORADB
COMMmethod TCPip
TCPPort 1500
TCPServeraddress 172.16.101.26
Schedlogname /usr/tivoli/tsm/client/oracle/bin64/ora_dsmsched.log
Errorlogname /usr/tivoli/tsm/client/oracle/bin64/ora_dsmerror.log


[FONT=LDCIH J+ Palatino]8. Change to the [FONT=LDCKB F+ Book Master]/usr/[/FONT][FONT=LDCKB F+ Book Master]tivoli[/FONT][FONT=LDCKB F+ Book Master]/tsm/client/api/bin64 [/FONT][FONT=LDCIH J+ Palatino]directory and create a symbolic link[/FONT][/FONT]
[FONT=LDCIH J+ Palatino] [FONT=LDCKB F+ Book Master]/usr/tivoli/tsm/client/ba/bin/dsm.sys[/FONT][FONT=LDCIH J+ Palatino].[/FONT][/FONT]
[FONT=LDCIH J+ Palatino] [/FONT]
[FONT=LDCIH J+ Palatino] [FONT=LDCIH J+ Palatino]ln -s [/FONT][FONT=LDCKB F+ Book Master]/usr/tivoli/tsm/client/ba/bin/dsm.sys[/FONT][FONT=LDCIH J+ Palatino] /[/FONT][FONT=LDCKB F+ Book Master]usr/tivoli/tsm/client/api/bin64/dsm.sys[/FONT][FONT=LDCIH J+ Palatino][/FONT][/FONT]
[FONT=LDCIH J+ Palatino] [/FONT]

  • Change to the [FONT=LDCKB F+ Book Master]/usr/[FONT=LDCKB F+ Book Master]tivoli[/FONT][FONT=LDCKB F+ Book Master]/tsm/client/oracle/bin64 [/FONT]directory and run the [/FONT]
[FONT=LDCIG I+ Palatino]tdpoconf password[FONT=LDCIG I+ Palatino] [/FONT]command to generate the password file[/FONT]

  • Run the [FONT=LDCIG I+ Palatino]tdpoconf showenvironment[FONT=LDCIG I+ Palatino] [/FONT]command to confirm proper configuration.[/FONT]
  • Make sure the proper permissions on tsm dir .
 
Back
Top