#!/bin/bash
source /home/oracle/.bash_profile
export ORACLE_SID=eesmp1
rman target / log /backup/eesmp_bak/eesmp_rmandate +"%Y%m%d"
.log APPEND << EOF
run{
allocate CHANNEL ch00 type DISK;
backup AS COMPRESSED BACKUPSET database
format ‘/backup/eesmp_bak/eesmp_fulldata_%d_%T_%s_%c.dbf’;
RELEASE CHANNEL ch00;
}
sql ‘alter system archive log current’;
backup AS COMPRESSED BACKUPSET archivelog all FORMAT ‘/backup/eesmp_bak/eesmp_arch_%d_%T_%s_%c’;
DELETE NOPROMPT ARCHIVELOG UNTIL TIME ‘sysdate-15’;
backup format ‘/backup/eesmp_bak/eesmp_ctl_%d_%T_%s_%c.dbf’ current controlfile;
EOF
Oracle Rman 备份脚本
最新推荐文章于 2021-12-04 13:28:26 发布