Table of Contents
TDP Oracle installation
TDP Oracle installation / configuration
Environnement client TDP Oracle
TDP Oracle installation
First step is to install TSM client 8.1.9
[root@srvora01 TSMCLI_LNX]# rpm -Uhv gskcrypt64-8.0.55.9.linux.x86_64.rpm gskssl64-8.0.55.9.linux.x86_64.rpm Preparing... ########################################### [100%] package gskcrypt64-8.0-55.9.x86_64 is already installed package gskssl64-8.0-55.9.x86_64 is already installed [root@srvora01 TSMCLI_LNX]# rpm -Uhv TIVsm-API64.x86_64.rpm TIVsm-BA.x86_64.rpm warning: TIVsm-API64.x86_64.rpm: Header V4 RSA/SHA1 Signature, key ID be1d0ddb: NOKEY Preparing... ########################################### [100%] 1:TIVsm-API64 ########################################### [ 50%] 2:TIVsm-BA ########################################### [100%] [root@srvora01 TSMCLI_LNX]# rpm -qa | grep -i TIV TIVsm-API64-8.1.9-0.x86_64 TIVsm-BA-8.1.9-0.x86_64
Second, install TDP Oracle
[root@srvora01 TSMORA_LNX]# ll -rwxr-xr-x 1 root root 6513191 Oct 3 22:12 TDP-Oracle.x86_64.bin [root@srvora01 TSMORA_LNX]# cd /software/TSMORA_LNX/ [root@srvora01 TSMORA_LNX]# rpm -qa | grep -i ora TDP-Oracle-7.1.3-0.x86_64 TDP-Oracle.Utility-7.1.3-0.x86_64 oracle-ofed-release-guest-1.0.0-31.el6.x86_64 oracle-logos-60.0.14-1.0.5.el6.noarch oraclelinux-release-6Server-9.0.3.x86_64 [root@srvora01 TSMORA_LNX]# ./TDP-Oracle.x86_64.bin Preparing to install... Extracting the installation resources from the installer archive... Configuring the installer for this system's environment... Launching installer... Graphical installers are not supported by the VM. The console mode will be used instead... =============================================================================== Choose Locale... ---------------- 1- Deutsch ->2- English ... 6- Português (Brasil) ... =============================================================================== Installation Complete --------------------- Congratulations. IBM Spectrum Protect for Databases - Data Protection for Oracle has been successfully installed to: /opt/tivoli/tsm/client/oracle PRESS <ENTER> TO EXIT THE INSTALLER: [root@srvora01 ~]# rpm -qa | grep -i ora TDP-Oracle-8.1.9-0.x86_64 TDP-Oracle.Utility-8.1.9-0.x86_64
Server Spectrum Protect configuration for Oracle
The TDP versions higher than 8.1.2 use now SSL certificates. This is the reason why we use a connection node on TSM, and a node to store the backups. Using GRANT PROXY, we are able to access from muliples nodes the backups
On Spectrum Protect server we create the access node SRVORA01, and one target node for oracle backups ORADB01.
Protect: TSMSRV01>reg node SRVORA01 xxxx dom=oracle maxnummp=20 Protect: TSMSRV01>reg node ORADB01 xxxx dom=oracle backdelete=yes maxnummp=20 Protect: TSMSRV01> GRant PROXynode TArget=ORADB01 agent=SRVORA01 Protect: TSMSRV01>q proxy Target Node Agent Node --------------- --------------------------------------------- ORADB01 SRVORA01 SRVORA02
TDP Oracle configuration
Config file dsm.sys is located into API directory, to prevent managing multiple dsm.sys, we create a symbolic link
[root@srvora01 bin64]# ln -s /opt/tivoli/tsm/client/ba/bin/dsm.sys /opt/tivoli/tsm/client/api/bin64/dsm.sys [root@srvora01 bin64]# ls -l /opt/tivoli/tsm/client/api/bin64/dsm.sys lrwxrwxrwx 1 root root 20 May 16 2019 /opt/tivoli/tsm/client/api/bin64/dsm.sys -> ../../ba/bin/dsm.sys [root@srvora01 bin64]# cat /opt/tivoli/tsm/client/ba/bin/dsm.sys ##################################### ### ### SPECTRUM PROTECT Oracle ### ###################################### Servername ORADB01 COMMMETHOD TCPIP TCPPort 1500 TCPServeraddress tsmsrv01 TCPBUFFSIZE 32 TCPWINDOWSIZE 64 TCPNODELAY YES USELARGebuffers YES COMPRESSION NO RESOURCEUTIL 20 NODENAME srvora01 ASNODE ORADB01 PASSWORDACCESS generate passworddir /opt/spectrum/tsm/tdpo INCLUDE /.../* ORA_TDP
=⇒ ASNODE is the target node where backups are stored
Configuration file for TDP Oracle: tdpo_xxx.opt and dsm_xxx.opt
[oracle@srvora01:/home/oracle]# cat /oracle/tsm/tdpo/tdpo_TSTDB01.opt DSMI_ORC_CONFIG /oracle/tsm/opt/dsm_ORADB01.opt DSMI_LOG /oracle/tsm/log/srvora01 TDPO_FS TSTDB01_rman TDPO_PSWDPATH /oracle/tsm/password [oracle@srvora01:/home/oracle]# cat /oracle/tsm/opt/dsm_ORADB01.opt SERVERNAME ORADB01 SUBDIR YES
Password registration on client node
Run the tdpoconf password command as the root user or as the Oracle user. The password files are created in the directory that is specified by the passworddir option in the dsm.sys file for the Data Protection for Oracle node. If the tdpo_pswdpath option is specified, the files are created in that directory.
If the password files were created by the root user, make sure that they are readable and writable by the Oracle user who runs the backup operations.
Use the password from connection node –> srvora01 (dsm.sys)
[oracle@srvora01:/home/oracle]tdpoconf password -TDPO_OPT=/oracle/tsm/tdpo/tdpo_TSTDB01.opt IBM Spectrum Protect for Databases: Data Protection for Oracle Version 8, Release 1, Level 9.0 (C) Copyright IBM Corporation 1997, 2019. All rights reserved. *************************************************************** * IBM Spectrum Protect for Databases Utility * Password file initialization/update program *************************************************************** Please enter current password:
Check of config
[oracle@srvora01:/home/oracle]tdpoconf SHOWENVironment -TDPO_OPT=/oracle/tsm/tdpo/tdpo_TSTDB01.opt IBM Spectrum Protect for Databases: Data Protection for Oracle Version 8, Release 1, Level 9.0 (C) Copyright IBM Corporation 1997, 2019. All rights reserved. Data Protection for Oracle Information Version: 8 Release: 1 Level: 9 Sublevel: 0 Platform: 64bit TDPO Linux86-64 IBM Spectrum Protect Server Information Server Name: ORADB01 Server Address: tsmsrv01 Server Type: Linux/x86_64 Server Port: 1500 Communication Method: TCP/IP Session Information Owner Name: Node Name: srvora01 Node Type: TDPO Linux86-64 DSMI_DIR: /opt/tivoli/tsm/client/api/bin64 DSMI_ORC_CONFIG: /oracle/tsm/opt/dsm_ORADB01.opt TDPO_OPTFILE: /oracle/tsm/tdpo/tdpo_TSTDB01.opt Compression: FALSE License Information: License file exists and contains valid license data.
Check connection on TSM server
Check of backup sessions on Spectrum Protect server during a backup
Protect: TSMSRV01>q se Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name Number Method State Time Sent Recvd Type ------- ------ ------ ------ ------- ------- ------- -------- ----------------- 117,702 SSL SSLiW 0 S 463 454 Node TDPO SRVORA01 Linux8- 6-64 Protect: TSMSRV01>q se Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name Number Method State Time Sent Recvd Type ------- ------ ------ ------ ------- ------- ------- -------- ----------------- 117,702 SSL RecvW 0 S 10.0 K 6.3 G Node ORADB01 (SRVORA01)
Backups are stored on the node ORADB01, with the filespace_name: /TSTDB01_rman ⇒ parameter: TDPO_FS TSTDB01_rman (file tdpo_xx.opt)
Protect: TSMSRV01>q occ ORADB01 Node Name Type Filespace FSID Storage Number of Physical Logical Name Pool Name Files Space Space Occupied Occupied (MB) (MB) ---------- ---- ---------- ---- ---------- ----------- ----------- ----------- ORADB01 Bkup /TSTDB02_rman 1 CONTAINER01 962 - 1,739,704.88 ORADB01 Bkup /TSTDB01_rman 3 CONTAINER01 20 - 122,405.01
Errors
ANS1331E (RC927) password error
ANS1331E (RC927) Only a IBM Spectrum Protect authorized user can perform this Action.
You have to set into dsm.sys (/opt/tivoli/tsm/client/api/bin64/dsm.sys) the filed:
passworddir /opt/spectrum/tsm/tdpo
And into tdpo.conf file the filed:
TDPO_PSWDPATH /opt/spectrum/tsm/tdpo
Then Test:
tdpoconf SHOWENVironment -TDPO_OPT=/oracle/tsm/tdpo/tdpo_DB1.opt
