rac数据库RMAN 备份与恢复
一、数据库备份
在主库上通过rman 每天对数据库进行备份，并且保留两份备份

在主库删除归档和进行rman 备份的脚本:
    [oracle@rac1 arch]$ pwd
    /opt/app/arch
    [oracle@rac1 arch]$ more del_arch.sh
    export ORACLE_SID=orcl1
    export ORACLE_BASE=/opt/app/oracle
    export ORACLE_TERM=xterm
    export ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1
    source /opt/app/arch/orcl1/del_arch.list
    source /opt/app/arch/orcl2/del_arch.list
    
    /opt/app/oracle/product/10.2.0/db_1/bin/rman target / log='/opt/app/arch/rman.log' <<EOF
    delete obsolete recovery window of 3 days;
    crosscheck archivelog all;
    delete noprompt obsolete;
    delete noprompt expired archivelog all;
    crosscheck backup;
    delete noprompt expired backup;
    backup format='/opt/app/arch/rman/orcl_full_%U_%T' tag='orcl_full' database;
    backup current controlfile tag='orcl_ctlfile' format='/opt/app/arch/rman/orcl_ctlfile_%U_%T';
    backup spfile tag='orcl_spfile' format='/opt/app/arch/rman/orcl_spfile_%U_%T';
    exit
EOF
执行时间:
    [oracle@rac1 arch]$ crontab -l
    30 02  *  *    0    /opt/app/arch/del_arch.sh
    30 02  *  *    1    /opt/app/arch/del_arch.sh
    30 02  *  *    2    /opt/app/arch/del_arch.sh
    30 02  *  *    3    /opt/app/arch/del_arch.sh
    30 02  *  *    4    /opt/app/arch/del_arch.sh
    30 02  *  *    5    /opt/app/arch/del_arch.sh
    30 02  *  *    6    /opt/app/arch/del_arch.sh

每天的备份文件放在/opt/app/arch/rman/目录下


360oracle技术服务中心[url]http://www.360oracle.com[/url]
专业的oracle技术服务