rman_backup.bat:
set ORACLE_SID=mysid
rman target sys/syspwd@ nocatalog cmdfile=rman_backup.commands > rman_backup.log

rman_backup.commands:
run {
allocate channel c1 device type disk FORMAT ‘d:\backups\%U’;
backup as compressed backupset database include current controlfile;
backup as compressed backupset archivelog all delete input;
release channel c1;
}
allocate channel for maintenance device type disk FORMAT ‘d:\backups\%U’;
run {
CROSSCHECK BACKUPSET;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
DELETE NOPROMPT OBSOLETE;
}

Sapphire X1550 Драйвера […]

Posted in Oracle Comments Off