oracle rman 备份归档日志常用脚本

$ vi bk_db_arch.sh

ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
ORACLE_SID=orcl
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
PATH=$PATH:/ORACLE_HOME/bin
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$ORACLE_HOME/opatch
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib

export ORA_NLS33
export ORACLE_BASE ORACLE_HOME ORACLE_SID 
export DB_NAME NLS_LANG PATH LD_LIBRARY_PATH CLASSPATH DB_NAME



rman target=/ cmdfile=/u03/rman/rman_script/bk_db_arch.rman log=/u03/rman/rman_log/bk_db_arch_`date +%Y%m%d%H%M%S`.log

$vi bk_db_arch.rman

run
{       
        ALLOCATE CHANNEL CH1 DEVICE TYPE DISK MAXPIECESIZE=8000M ; 
        sql 'ALTER SYSTEM CHECKPOINT';
        sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
        sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
        backup as compressed backupset archivelog all delete input 
        format '/mnt/backup/arch_%d_%U_%T.BKP';
        RELEASE CHANNEL CH1;
}

run
{
        ALLOCATE CHANNEL CH1 DEVICE TYPE DISK MAXPIECESIZE=8000M;
        backup current controlfile format '/mnt/backup/ctl_%d_%U_%T.BKP';
        RELEASE CHANNEL CH1;
}

crosscheck backup;
crosscheck archivelog all;

list backup;
exit;

转载于:https://www.cnblogs.com/ctypyb2002/p/9793118.html