We use a combo of TSM/TDPO/RMAN and a set of home grown scripts that perform Oracle Hot backups. The scripts create a backup on local disk which is then pushed to TSM as a BA client backup of the disk area. It saves a lot of licensing costs for TDPO.
Rick From: Grigori Solonovitch <[email protected]> To: [email protected] Date: 04/12/2012 12:58 AM Subject: Re: Oricle backups Sent by: "ADSM: Dist Stor Manager" <[email protected]> We are backing up Oracle using TDPO + TSM Client for many years under AIX: - install required TSM Client (do not forget about API modules - it is important for TDPO); - install required TDP for Oracle; - define dedicated node on TSM Server for each Oracle server (for example, <node> for files, <node>_ORA for all databases on the same node); - configure TSM Client & TDPO (dsm.opt and dsm.sys); - create option file for each database; - configure data compression or/and encryption, if required; - use tdpoconf to save password for each database; - link Oracle and TDPO (under AIX "ln -fs /usr/lib/libobk64.a $ORACLE_HOME/lib/libobk.a"; - create RMAN scripts for full database backup, incremental database backup, archive redo logs backup, restore database, incomplete restore database, etc (I can share some RMAN scripts, but not for Windows); - create required TSM schedules. Usually it is not easy to do initial setup and build scripts, but it works fine for years with minimal intervention Grigori G. Solonovitch Senior Technical Architect Ahli United Bank Kuwait www.ahliunited.com.kw Please consider the environment before printing this E-mail -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Lee, Gary Sent: 11 04 2012 10:39 PM To: [email protected] Subject: [ADSM-L] Oricle backups Well, I have now been tasked with backing up our Banner system. This uses oricle as its back end db. Seeking the wisdom of the group as to the best way to deal with oricle. Is there now a tdp for oricle? Any information / experiences welcome. Servers are all RHEL 5 on intel. Gary Lee Senior System Programmer Ball State University phone: 765-285-1310 Please consider the environment before printing this Email. CONFIDENTIALITY AND WAIVER: The information contained in this electronic mail message and any attachments hereto may be legally privileged and confidential. The information is intended only for the recipient(s) named in this message. If you are not the intended recipient you are notified that any use, disclosure, copying or distribution is prohibited. If you have received this in error please contact the sender and delete this message and any attachments from your computer system. We do not guarantee that this message or any attachment to it is secure or free from errors, computer viruses or other conditions that may damage or interfere with data, hardware or software. ----------------------------------------- The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
