Chinaunix首页 | 论坛 | 博客
  • 博客访问: 1226984
  • 博文数量: 727
  • 博客积分: 10011
  • 博客等级: 上将
  • 技术积分: 8320
  • 用 户 组: 普通用户
  • 注册时间: 2008-07-13 15:42
文章分类

全部博文(727)

文章存档

2011年(1)

2008年(726)

我的朋友

分类: 服务器与存储

2008-07-14 15:05:00

connect 'internal/manager@scdb1';
           sql 'alter system archive log current';
          backup
            format 'arch_t%t_s%s_p%p'
            (archivelog
            like '/jfbackup/arch_log/arch_1_%.arc'
            delete input);
        release channel d1;
        }
       
run {
           allocate channel d2 type 'sbt_tape' parms
ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'
    connect 'internal/manager@scdb2';
           sql 'alter system archive log current';
          backup
            format 'arch_t%t_s%s_p%p'
            (archivelog
            like '/jfbackup/arch_log/arch_2_%.arc'
            delete input);
        release channel d2;
        }
        同时还可以对指定的tablespace datafile进行备份,具体请参见RMAN相关手册。
        手工执行ORACLE的备份:
        rman target internal/oracle@targetSID rcvcat rman/rman@recoverycatalogSID cmdfile=/xxx/xxx msglog=xxx.log
八、        ORACLE数据库的恢复
run {
        allocate channel d3 type 'sbt_tape' connect 'internal/manager@scdb1' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
        allocate channel d4 type 'sbt_tape' connect 'internal/manager@scdb2' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
        restore controlfile;
        alter database mount;
        restore database;
        recover database;
        release channel d1;
        release channel d2;
        sql "alter database open resetlogs";
        }
九、
 
Twelve Steps to Configuring Your Tsm Environment
 
1、        Install the TSM code on the machine that will be your TSM server (referred to as server).This process may involve a few steps that are dependent on your platform type.Please read the Quick Start Guide and REAMES for yout platform.
2、        At the install time you had created default DB and LOG volumes.Now you want to supportment or replace that initial configuration.
A、        Add additional DB volumes.i.e. def dbv filename f=volsize Note:make sure they are on separate physical disks form other DB vols,LOG vols or mirrors of their LOGs or DBs.
B、        Extend the data base to use the newly added space.i.e ext db 100
C、        Add additional LOG volumes,i.e.def logv filename f=volsize Notice:Same rules apply for LOG volumes as DB volumes.
D、        Extend the log to use the newly added space.i.e ext log 100
E、        You may have to delete the default volumes that were created during install,i.e del dbv filename or del log filename Notice:You may have to reduce the DB or LOG in order to delete the volume i.e.reduce db 16
3、        Now configure you dsmserv.opt file.Read though the default file.There are serval values you may wish to set or adjust.
A、        Set yout COMMMethods and there related attributes
B、        Set VOLHISTORY and DEVCONFIG,remember make 2 copies
C、        Set EXPInterval 0,this will disable expiration.You will have a admin schedule take care of this
D、        Set various performance releated attributes,i.e. TCPNODELAY,TCPWindowsize,MAXSessions,BUFPoolsize,LOGPoolsize,TXNGroupmax.etc
E、        To use the Web Admin Client set COMMM tcpip,HTTPPort 1580,1580 is the default port number
4、        Now you must defined the Libraries,Drivers and Device Classes your system will use
A、        You must define libraries frist.Both manual and automated libraries can be defined,i.e.manual –def lib manlib libtype=manual or automated –def lib autolib libtype=scsi device=dec_spec
B、        Now define drives in your libraries,i.e manual –def dr manlib mandr device=dec_spec or def dr autolib autodriv1 device=dec_spec element=element#
C、        Now we can create device classes.You can have more than 1 device class use the same library if yoy like.Note lease refer to the documentation for def dev command.There are many options available.
5、        Once we have Device Classes we can create Storage Pools that will use them,also,we must establish or SP hierarchy.
A、        Determine the number of top level pools you will need.They will typically be Disk based SPs
B、        Next decide on the hierarchy from the top levels to the final pools.Make sure you consider things like:Backup vs Archive data,Collocation,Offsite (copy pools) vs Local.etc.
阅读(501) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~