TSM配置-2

六、        RMAN的配置
安装一套独立与生产数据库之外的ORACLE数据库作为catalog database，最好安装在不同的主机上。
1.        在catalog数据库服务器上创建RMAN所需要的表空间
$svrmgrl
　        svrmgrl>;connect system/manager
svrmgrl>;create tablespace rman_ts datafile ‘<dir>;/<name>;’
       >;size 100M autoextend on next 100M maxsize 300M；
2.        创建RMAN用户并赋予角色及权限
svrmgrl>;create user rman identified by rman
          >;default tablespace rman_ts
          >;temporary tablespace temporary
          >;quota unlimited on rman_ts;
   svrmgrl>;grant recovery_catalog_owner to rman;
   svrmgrl>;connect / as sysdba;
svrmgrl>;grant dba,connect,resource to rman;
3.        创建recovery catalog的表结构
$rman target internal/oracle@targetSID  rcvcat rman/rman@recoverycatalogSID
rman>;create catalog;
4.        在catalog数据库中对目标数据库进行注册
rman>;register database;
七、        ORACLE数据库的备份
Database备份script：
run {
        allocate channel d1 type 'sbt_tape' connect 'internal/manager@scdb2' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
        allocate channel d2 type 'sbt_tape' connect 'internal/manager@scdb1' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
        backup
                   format 'ctl_t%t_s%s_p%p'
                   tag cf
                   (current controlfile);
        backup
                  full
                   filesperset 8
                   format 'db_t%t_s%s_p%p'
           tag fulldb
                   (database);
        release channel d1;
        release channel d2;
}
Archivelog的备份script:
run {
           allocate channel d1 type 'sbt_tape' parms
ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)'
    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";
        }

文章引用自：