--备份归档、删除1天前的归档、备份控制文件(每天定时备份,在数据文件备份之后执行)run {allocate channel c1 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/xxx;allocate channel c2 device type disk format '/home/oracle/orabak/...
显示全部--备份归档、删除1天前的归档、备份控制文件(每天定时备份,在数据文件备份之后执行)
run {
allocate channel c1 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/xxx;
allocate channel c2 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/xxx;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup archivelog all;
DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
backup current controlfile format '/home/oracle/orabak/databack/controlfile_%T_%U.bak';
release channel c1;
release channel c2;
}
--备份归档
run {
allocate channel c1 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/xxx;
allocate channel c2 device type disk format '/home/oracle/orabak/databack/arc_%T_%U.bak' connect sys/xxx;
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup archivelog all;
DELETE noprompt ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1';
backup current controlfile format '/home/oracle/orabak/databack/controlfile_%T_%U.bak';
release channel c1;
release channel c2;
}
收起