rman备份实例

来源:互联网 发布:期货程序化模型源码 编辑:程序博客网 时间:2024/06/14 15:44

shell脚本:

#backup_full.sh
rman target / cmdfile=/oracle/backup_full.rman

rman脚本全库及数据库归档日至进行全备份:

run{
allocate channel d1 device type disk;
backup database format '/oradata/backup/FULL_%T_%d_%U';
backup archivelog all delete input
format '/oradata/backup/full_%u_%p_%c.ac' filesperset = 3;
release channel d1;
}
exit;

#cron文件

0 12,18 * * * /bin/backup_full.sh