1、体系：采用LINUX CRONTAB定时计划调用SHELL，执行RMAN

[oracle@DB]$ crontab -l
0 1 * * 0 /u01/bak/rman/script/inc0.sh
0 1 * * 1 /u01/bak/rman/script/inc2.sh
0 1 * * 2 /u01/bak/rman/script/inc2.sh
0 1 * * 3 /u01/bak/rman/script/inc2.sh
0 1 * * 4 /u01/bak/rman/script/inc1.sh
0 1 * * 5 /u01/bak/rman/script/inc2.sh
0 1 * * 6 /u01/bak/rman/script/inc2.sh

2、相关脚本

drwxrwxrwx 2 oracle oinstall 4096 03-10 08:19 log
-rw------- 1 oracle oinstall 4458 03-09 17:37 nohup.out
-rwxrwxrwx 1 oracle oinstall   69 03-09 09:37 connect.rcv
-rwxrwxrwx 1 oracle oinstall   84 03-08 16:17 inc0.rcv
-rwxrwxrwx 1 oracle oinstall  165 03-08 16:17 inc0.sh
-rwxrwxrwx 1 oracle oinstall   84 03-08 16:17 inc1.rcv
-rwxrwxrwx 1 oracle oinstall  163 03-08 16:17 inc1.sh
-rwxrwxrwx 1 oracle oinstall   84 03-08 16:17 inc2.rcv
-rwxrwxrwx 1 oracle oinstall  164 03-08 16:17 inc2.sh

3、inc0.sh内容

export ORACLE_HOME=/home/oracle/product/10.2.0/db_1
nohup $ORACLE_HOME/bin/rman  cmdfile=/u01/bak/rman/script/inc0.rcv log=/u01/bak/rman/script/log/inc0.log append

 4、inc0.rcv 内容

@@/u01/bak/rman/script/connect.rcv
run{
execute global script global_inc0;
}
exit;

5、看看global_inc0是什么
-----是在RMAN中注册的脚本

replace global script global_inc0
comment ' A script for backup database using incremental level 0'
{
 execute global script global_del_obso;
 allocate channel ch1 device type disk;
 set limit channel ch1 readrate=10240;
 set limit channel ch1 kbytes=2048000;
 backup as compressed backupset incremental level 0 database
 format='/u01/bak/rman/inc0_%d_%U'
 tag='Inc0';
 release channel ch1;
 execute global script global_arch;
 execute global script global_bkctl;
}

 global_del_obso又是什么

--创建全局删除废弃备份的脚本
create global script global_del_obso  
comment 'A script for obsolete backup and delete it' {
allocate channel ch1 device type disk;
delete obsolete recovery window of 7 days;  
release channel ch1;
}

======================

再来看看其他注册的脚本

 

create global script global_arch
comment ' A script for archivelog and delete it '
{
   allocate channel ch1 device type disk;
   sql " alter system archive log current";
   set limit channel ch1 readrate=10240;
   set limit channel ch1 kbytes=2048000;
   backup as compressed backupset archivelog all delete input
   format='/u01/bak/rman/arch_%d_%U'
   tag='Archbk';
   release channel ch1;
  }
 

replace global script global_inc1 
comment ' A script for backup database using incremental level 1'
{
 execute global script global_del_obso;
 allocate channel ch1 device type disk;
 set limit channel ch1 readrate=10240;
 set limit channel ch1 kbytes=2048000;
 backup as compressed backupset incremental level 1 database
 format='/u01/bak/rman/inc1_%d_%U'
 tag='Inc1';
 release channel ch1;
 execute global script global_arch;
 execute global script global_bkctl;
}

replace global script global_inc2 
comment ' A script for backup database using incremental level 2'
{
 execute global script global_del_obso;
 allocate channel ch1 device type disk;
 set limit channel ch1 readrate=10240;
 set limit channel ch1 kbytes=2048000;
 backup as compressed backupset incremental level 2 database
 format='/u01/bak/rman/inc2_%d_%U'
 tag='Inc2';
 release channel ch1;
 execute global script global_arch;
 execute global script global_bkctl;
}

replace global script global_bkctl 
comment ' A script for backup crontl file'
{
 allocate channel ch1 device type disk;
 set limit channel ch1 readrate=10240;
 set limit channel ch1 kbytes=2048000;
 backup as compressed backupset
 format='/u01/bak/rman/backupctl_%d_%U.ctl'
 tag='bkctl'
 current controlfile reuse;
 release channel ch1;
}
 

我们可以看看有哪些脚本

RMAN> list global script names;
 

再来关注下其他相关的脚本：

 

    --启用控制文件的自动备份功能

        RMAN> configure controlfile autobackup on;

        RMAN> configure controlfile autobackup format for device type disk to '/u01/bk/rmbk/auto_ctl_%d_%f';

   

    --删除以前的备份

        RMAN> delete noprompt backupset;

   

    --备份前验证归档日志是否存在

        RMAN> crosscheck archivelog all;

       

    --删除无效的归档日志信息

        RMAN> delete noprompt expired archivelog all;

       

    --使用0级增量备份数据库

        RMAN> run { execute global script global_inc0;}

 

    --查看刚刚完成的备份情况

        RMAN> list backupset summary;

        RMAN> list backupset ;

        RMAN> list backup of controlfile ;

        RMAN> list backup of archivelog all;

        RMAN> list backup of database;

        RMAN> list backup of datafile n ;
 

List of Stored Scripts in Recovery Catalog
 
 
    Global Scripts
 
 
       Script Name
       Description
       -----------------------------------------------------------------------
       global_arch
        A script for archivelog and delete it 
 
       global_bkctl
        A script for backup crontl file
 
       global_del_obso
       A script for obsolete backup and delete it
 
       global_inc0
        A script for backup database using incremental level 0
 
       global_inc1
        A script for backup database using incremental level 1
 
       global_inc2
        A script for backup database using incremental level 2
 
RMAN>

本文转自zylhsy 51CTO博客，原文链接：http://blog.51cto.com/yunlongzheng/511453，如需转载请自行联系原作者