oracle full database backup

最新推荐文章于 2024-09-09 07:34:43 发布

转载最新推荐文章于 2024-09-09 07:34:43 发布 · 293 阅读

文章标签：

#数据库

本文介绍了一个使用RMAN进行Oracle数据库备份的shell脚本。该脚本包括清除过期备份、检查归档日志、全备数据库、备份归档日志及控制文件等操作。通过分配多个通道提高备份效率，并采用压缩备份集减少存储占用。

#!/bin/sh
source /home/oracle/.bash_profile

DICPATH=/oafile/archlog

LOGPATH=$DICPATH/backuplog
DATPATH=$DICPATH/backup

rman target / nocatalog msglog=$LOGPATH/rman_db_`date '+%Y%m%d%H%M%S'`.log <<EOF
#rman target sys/c21nzhxg24cd@20.1.1.11/c2db1.19pay.com nocatalog msglog=$LOGPATH/rman_db_`date '+%Y%m%d%H%M%S'`.log <<EOF

run{
REPORT OBSOLETE;
crosscheck archivelog all;
DELETE force NOPROMPT OBSOLETE;
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
backup as compressed backupset full database tag 'dbfull' format '$DATPATH/dbfull_%u_%s_%p' ;
sql 'alter system archive log current';
backup as compressed backupset filesperset 3 archivelog all tag 'arch' format '$DATPATH/arch_%u_%s_%p' delete input;
backup current controlfile tag 'ctl' format '$DATPATH/ctl_%s_%p_%t';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
DELETE force NOPROMPT OBSOLETE;
}
exit;

EOF

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16976507/viewspace-2132431/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16976507/viewspace-2132431/