oracle 账号到期时间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

oracle账号

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';

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;