1、shell脚本
1）vi rman_backup.cmd
#rman_backup.cmd
connect target /
run
{
allocate channel d1 device type disk;
backup database format='/u01/backup/%T_%d_%s.bak' plus archivelog;
sql 'alter system archive log current';
backup current controlfile format='/u01/backup/%T_%d_%s.ctl';
release channel d1;
}
2）vi rman_backup.sh
#!/bin/bash
rman @'/u01/rman_backup.cmd'
3）sh rman_backup.sh
[oracle@serv11 u01]$ sh rman_backup.sh
2、rman脚本
1）vi backup.rman
#backup.rman
run
{
allocate channel d1 device type disk;
backup database format='/u01/backup/%T_%d_%s.bak' plus archivelog;
sql 'alter system archive log current';
backup current controlfile format='/u01/backup/%T_%d_%s.ctl';
release channel d1;
sql 'alter system archive log current';
}
2）在rman中手动调用脚本
RMAN> @/u01/backup.rman
注意：语句后面不能加分号
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/27633655/viewspace-1080634/ ，如需转载，请注明出处，否则将追究法律责任。
