####################################################################full database
vi /backup/ebsbackup_db_level0.sh
backup_path="/backup"
#backup
mkdir -p $backup_path
chown -R oracle:oinstall $backup_path
su - oracle -c 'rman target / nocatalog msglog=/backup/rman_L0.`date +%Y%m%d%H%M%S`.log' <<EOF
run
{
#CONFIGURE DEVICE TYPE DISK PARALLELISM 16 BACKUP TYPE TO COMPRESSED BACKUPSET;
backup as compressed backupset incremental level 0 format '$backup_path/BZPROD_DATA_level0_%Y%M%D$(date +%H%M%S)_%U' database;
#sql "alter system archive log current";
#sql "alter system archive log current";
#sql "alter system archive log current";
backup as compressed backupset archivelog all format '$backup_path/BZPROD_ARCH_%Y%M%D$(date +%H%M%S)_%U';
backup current controlfile format '$backup_path/BZPROD_CONTROLFILE_level0_%Y%M%D$(date +%H%M%S)_%U';
}
EOF
####################################################################archivelog
vi /backup/ebsbackup_db_arch.sh
backup_path="/backup"
#backup
mkdir -p $backup_path
chown -R oracle:oinstall $backup_path
su - oracle -c 'rman target / nocatalog msglog=/backup/rman_arch.`date +%Y%m%d%H%M%S`.log' <<EOF
run
{
#CONFIGURE DEVICE TYPE DISK PARALLELISM 16 BACKUP TYPE TO COMPRESSED BACKUPSET;
#sql "alter system archive log current";
#sql "alter system archive log current";
#sql "alter system archive log current";
backup as compressed backupset archivelog all format '$backup_path/BZPROD_ARCH_%Y%M%D$(date +%H%M%S)_%U';
backup current controlfile format '$backup_path/BZPROD_CONTROLFILE_arch_%Y%M%D$(date +%H%M%S)_%U';
}
EOF
####################################################################
chmod +x /backup/ebsbackup_db_level0.sh /backup/ebsbackup_db_arch.sh
nohup sh /backup/ebsbackup_db_level0.sh &
nohup sh /backup/ebsbackup_db_arch.sh &
oracle rman backup scripts
未经允许不得转载:徐万新之路 » oracle rman backup scripts
相关推荐
Oracle 26ai: How to install Oracle 26ai GI (HAS) using Native ASM
Oracle 26ai RAC 图形界面安装指南(VirtualBox + OL 8.10)
Vmware Workstation 2026下Oracle Linux 8.10 虚拟机网卡命名对齐方案(ebsdb1 / ebsdb2)
sysaux中HEATMAP 对象较大
生产库AWR手工清理及 SYSAUX 表空间收缩
Oracle Data Guard 11g到19c切换避坑指南
查询v$asm_disk视图hang住
Oracle数据泵(expdp/impdp)完整使用指南

徐万新之路

