Oracle用脚本执行备份
1 编写脚本/home/oracle/backup.rman
RUN {
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/backup/%F';
ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT '/u01/app/oracle/backup/bak_%T_%U';
BACKUP DATABASE SKIP INACCESSIBLE
PLUS ARCHIVELOG FILESPERSET 20
DELETE ALL INPUT;
RELEASE CHANNEL C1;
}
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
CROSSCHECK BACKUPSET;
DELETE NOPROMPT OBSOLETE;
2 在RMAN环境中执行脚本
RMAN> @/home/oracle/backup.rman
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29485627/viewspace-1700547/ ，如需转载，请注明出处，否则将追究法律责任。
