BATCH PARA RODAR RMAN NO WINDOWS

1- Abrir o Notepad do Windows e criar dois arquivos (uma extensão .bat e .rcv) 

Backup_Online.bat

SET NLS_DATE_FORMAT=DD-MON-YYYY HH24:MI:SS
SET ORACLE_HOME=D:\app\oracle\product\11.2.0.3\dbhome_1
SET ORACLE_SID=NOMEDO BANCO
SET SCRIPT_ORACLE=D:\Dba\Scripts
SET LOG_ORACLE=D:\Dba\Scripts\Backup\Log

%ORACLE_HOME%\bin\rman target / nocatalog cmdfile=%SCRIPT_ORACLE%\Backup_Online.rcv msglog=%LOG_ORACLE%\Backup_Online_%DATE:~4,2%.%DATE:~7,2%.%DATE:~10,4%_%T


Vamos criar o script do backup online, segue:

Backup_Online.rcv

RUN{crosscheck archivelog all;
crosscheck backupset;
delete noprompt expired backupset ;
delete noprompt expired backup ;
delete noprompt obsolete ;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'E:\BACKUP\RMAN\Nome_BD\bk_full_df_ Nome_BD %U';
SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'e:\BACKUP\RMAN\ Nome_BD \c_%F.ctl';
sql 'alter system switch logfile';
allocate channel ch01 device type disk FORMAT 'E:\BACKUP\RMAN\MSAF\bk_full_ Nome_BD _%U';
sql 'alter system archive log current';
backup as compressed backupset incremental level 0 section size 50g database;
BACKUP SECTION SIZE 50G ARCHIVELOG ALL not backed up 1 times FORMAT 'e:\BACKUP\RMAN\ Nome_BD \bk_archivelog_ Nome_BD _%U';
delete noprompt archivelog until time 'SYSDATE-2';
}

2 - Ir ate o agendador de tarefas do Windows