Backing up Oracle Databases on UNIX with the TSM TDP
发表于:2024-09-22 作者:千家信息网编辑
千家信息网最后更新 2024年09月22日,Many of the directory and file names mentioned below will be site specific. For the sake of illustra
千家信息网最后更新 2024年09月22日Backing up Oracle Databases on UNIX with the TSM TDP
Many of the directory and file names mentioned below will be site specific. For the sake of illustration, I'm assuming that Oracle was installed with a userid called 'oracle' and the main control files are located in /u01/app/oracle/admin/tsm_rman. We are backing up a database called PBW on an AIX server called U20614P545 to a TSM server called P2XT1, which has an IP address of 19.66.123.123
The Oracle TDP is installed in /usr/tivoli/tsm/client/ba/bin64/ and TSM itself can be found in /usr/tivoli/tsm/client/ba/bin64.
Oracle RMAN
First install the Oracle TDP software. The TSM TDP for Oracle interfaces with Oracle RMAN, the integrated Oracle backup and recovery tool. RMAN understands how the Oracle databases and recovery logs fit together, so we don???t need to. Essentially, TSM is just used as a back-end data store. The one thing you will need to understand is the RMAN options file, which is usually created by your DBA and held in the Oracle data space. Every database will have an RMAN options file which basically defines some environment variables. The location of these files will be site dependent. At a minimum they should set three DSMI variables as shown below.DSMI_LOG /u01/app/oracle/admin/tsm_rmanDSMI_DIR /usr/tivoli/tsm/client/api/bin64DSMI_ORC_CONFIG /usr/tivoli/tsm/client/api/bin64/dsm.optIt???s useful to know where the RMAN logs are kept, as specified by the DSMI_LOG parameter, as you might need to check these out if you get problems. DSM_DIR tells RMAN where you installed the TDP code, /usr/tivoli/tsm/client/api/bin64 is the default location. DSMI_ORC_CONFIG points to the Oracle dsm.opt file Some sites like to keep all their TSM option files together, so they keep the ORC_CONFIG file in the default TSM installation directory, usually /usr/tivoli/tsm/client/ba/bin64/ and call it something like dsm_ora.opt to distinguish it from the normal dsm.opt file. In this case you either need to change the DSMI_ORC_CONFIG parameter to point to the correct file and path, or you need to add a symbolic link from /usr/tivoli/tsm/client/api/bin64/dsm.opt pointing to /usr/tivoli/tsm/client/ba/bin64/dsm_ora.opt. Other sites are quite happy to have a 'normal' dsm.opt file in ba/bin64 and an 'oracle' dsm.opt in api/bin64. All the oracle dsm.opt file needs to contain is
Servername P2XT1_ORAOther parameters that you might see include
TDPO_FS PBWThs is the filespace name used at the TSM server for this database. The default is adsmorc. In this case the database is called PBW, so we are calling the filespace PBW
TDPO_NODE U20614P545_ORAThe TSM node name that will be used to backup this database
TDPO_PSWDPATH /u01/app/oracle/admin/tsm_rman/passwordSee below
TDPO_OWNER oracleThe userid that 'owns' the TDPO process
Changes to dsm.sys
You also need to add at least one extra stanza to your dsm.sys file for Oracle database backups. This will typically look like** Oracle Backups Servername P2XT1_ORAcommmethod tcpiptcpserveraddress 19.66.123.123tcpport 1604webports 1504,0nodename U20614P545_ORAerrorlogname /usr/local/logs/U20614P545_ORA.dsmerror.logerrorlogretention 30 dpasswordaccess promptenablelanfree yesLANFREECOMMMETHOD TCPIPLANFREETCPPORT 1510Older Oracle backups needed a separate stanza from scheduling, like this
** Oracle Backup Schedulerservername P2XT1_ORA_SCHEDcommmethod tcpiptcpserveraddress 19.66.123.123tcpport 1604webports 1505,0nodename U20614P545_ORAerrorlogname /usr/local/logs/U20614P545_ORA.dsmerror.logerrorlogretention 30 dschedlogname /usr/local/logs/U20614P545_ORA.dsmsched.logschedlogretention 30 dpasswordaccess generatepassworddir /etc/security/tsm/P2XT1_ORAmanagedservice scheduleschedmode prompted
Setting Passwords, checking licence, checking access rights
After you configure the option files as above, you may need to set the TDP password. To do this, you run the tdpoconf commandtdpoconf password -tdpo-optfile=/u01/app/oracle/admin/tsm_rman/PBW_tdpo.optIf you need to create the oracle password directory you should assign ownership to the 'oracle' userid (or whatever userid you use to manage oracle) as follows. This links to the RMAN option, TDPO_PSWDPATH /u01/app/oracle/admin/tsm_rman/password Navigate to the tsm_rman directory, then run
mkdir passwordchown oracle:oraclechmod 770 passwordMake sure that you have a licence file, /usr/tivoli/tsm/client/oracle/bin64/agent.lic Then check that ???oracle??? can update the TSM logs (666) and can read all the tsm option files (644)
TSM server definitions
All database backups have unique names, and backup retention is controlled by RMAN, so you must set backupdelete=yes. Your oracle management class should be set to keep just one active backup forever, with retonly and verdelete parameters both set to 0. Define the client on your TSM server as U20614P545_ORA, the only difference from your standard UNIX clients would be that you set backupdelete=yes and may invoke the oracle management class with a special client optionset that picks up a database management class. Oracle clients also usually have maxnummountpoints set to 2. Start up the oracle client with dsmc -server=P2XT1_ORA and set the client password when prompted. Finally, check the RMAN setup is working with the showenv option on the tdpoconf command;tdpoconf SHOWENV -TDPO_OPT=/u01/app/oracle/admin/tsm_rman/PBW
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
网络安全管理日志记录
网络安全 格尔软件
服务器管理器开机弹出
泰坦陨落服务器连不上
服务器单机防护
苏州app软件开发如何收费
网络安全检查工作记录表
吉利软件开发工程师
谷歌云服务器怎么获得
美国服务器打开国外网页
医学数据库怎么建立
防火墙技术涉及到计算机网络技术
备案人和网络安全责任人
建立vpn服务器加速软件
mysql远程访问数据库
深信服网络安全工程师薪酬
未来之役服务器崩了
软件开发理论工资月薪
我的世界联机对战服务器
昆仑数据库核高基
荣耀更新拦截数据库
梦幻西游能开几个服务器
软件开发培训珠海
软件开发人员常用话术
山东飞驰网络技术有限公司
民法典网络安全教学
单位如何进行网络安全管理
中国科学院网络安全招聘
联想ts540服务器
网络技术在公安工作的应用