欧美一区二区三区老妇人-欧美做爰猛烈大尺度电-99久久夜色精品国产亚洲a-亚洲福利视频一区二区

BackingupOracleDatabasesonUNIXwiththeTSMTDP

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.

創(chuàng)新互聯(lián)建站主要從事網(wǎng)站建設、成都做網(wǎng)站、網(wǎng)頁設計、企業(yè)做網(wǎng)站、公司建網(wǎng)站等業(yè)務。立足成都服務民樂,十余年網(wǎng)站建設經(jīng)驗,價格優(yōu)惠、服務專業(yè),歡迎來電咨詢建站服務:18980820575

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_rman
DSMI_DIR        /usr/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG /usr/tivoli/tsm/client/api/bin64/dsm.opt
It???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_ORA
Other parameters that you might see include
TDPO_FS         PBW   
Ths 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_ORA   
The TSM node name that will be used to backup this database
TDPO_PSWDPATH   /u01/app/oracle/admin/tsm_rman/password
See below
TDPO_OWNER      oracle
The 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_ORA
commmethod              tcpip
tcpserveraddress        19.66.123.123
tcpport                 1604
webports                1504,0
nodename                U20614P545_ORA
errorlogname            /usr/local/logs/U20614P545_ORA.dsmerror.log
errorlogretention       30 d
passwordaccess          prompt
enablelanfree           yes
LANFREECOMMMETHOD       TCPIP
LANFREETCPPORT          1510
Older Oracle backups needed a separate stanza from scheduling, like this
** Oracle Backup Scheduler
servername              P2XT1_ORA_SCHED
commmethod              tcpip
tcpserveraddress        19.66.123.123
tcpport                 1604
webports                1505,0
nodename                U20614P545_ORA
errorlogname            /usr/local/logs/U20614P545_ORA.dsmerror.log
errorlogretention       30 d
schedlogname            /usr/local/logs/U20614P545_ORA.dsmsched.log
schedlogretention       30 d
passwordaccess          generate
passworddir             /etc/security/tsm/P2XT1_ORA
managedservice          schedule
schedmode               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 command
tdpoconf password -tdpo-optfile=/u01/app/oracle/admin/tsm_rman/PBW_tdpo.opt
If 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 password
chown oracle:oracle
chmod 770 password
Make 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

當前題目:BackingupOracleDatabasesonUNIXwiththeTSMTDP
文章起源:http://chinadenli.net/article4/jpcioe.html

成都網(wǎng)站建設公司_創(chuàng)新互聯(lián),為您提供網(wǎng)站制作微信小程序ChatGPT網(wǎng)站收錄域名注冊品牌網(wǎng)站設計

廣告

聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)

h5響應式網(wǎng)站建設