oracle RMAN备份脚本

最新推荐文章于 2024-09-27 04:04:39 发布

Vik_Deng

最新推荐文章于 2024-09-27 04:04:39 发布

阅读量275

点赞数

文章标签：数据库 oracle

本文链接：https://blog.youkuaiyun.com/weixin_42344665/article/details/132777785

版权

文章详细描述了使用OracleRMAN(RecoveryManager)进行数据库备份的过程，包括创建目录、配置备份策略、压缩备份以及清理过期日志。还涉及到了两个相关的shell脚本kfptdb.sh和zhfwdb.sh。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

cd /home/oracle/scripts
vi rman.sh
. /home/oracle/scripts/kfptdb
BAKPATH=/backup/RMAN
DBNAME=`sqlplus -S / as sysdba <<EOF
set feedback off
set heading off
set pagesize 0
set linesize 100
set trimspool on
select value from v\\$parameter where name ='db_name';
EOF`

if [ ! -d "$BAKPATH/$DBNAME/" ]; then
mkdir -p "$BAKPATH/$DBNAME/"
fi

if [ ! -d "$BAKPATH/log" ]; then
mkdir -p "$BAKPATH/log"
fi

rman target / log=$BAKPATH/log/$DBNAME-full_`date +%Y%m%d%H%M`.log<<!
run{
allocate channel d1 device type disk;
allocate channel d2 device type disk;
allocate channel d3 device type disk;
allocate channel d4 device type disk;
allocate channel d5 device type disk;
allocate channel d6 device type disk;
backup as compressed backupset database format '$BAKPATH/$DBNAME/%d_Full_%s_%t';
sql 'alter system archive log current';
backup as compressed backupset archivelog all format '$BAKPATH/$DBNAME/%d_Arch_%s_%t' not backed up 1 times;
backup spfile format '$BAKPATH/$DBNAME/%d_SP_%s_%t';
backup current controlfile format '$BAKPATH/$DBNAME/%d_C_%s_%t';
RELEASE CHANNEL d1;
RELEASE CHANNEL d2;
RELEASE CHANNEL d3;
RELEASE CHANNEL d4;
RELEASE CHANNEL d5;
RELEASE CHANNEL d6;
}
crosscheck archivelog all;
crosscheck backupset;
delete noprompt expired backup;
delete noprompt expired archivelog all;
delete noprompt backup completed before 'sysdate-7';
delete noprompt force archivelog all completed before 'sysdate-7';
list backup summary;
exit
!