- Create first text file called backup and change the format to “bat”, inside the file add the following lines :-
C:
cd E:\app\ADM-BSS01\product\11.2.0\dbhome_1\BIN
rman @E:\RMAN\Scripts\backup.rman
- Create 3 folders in E for example :-
- backup
- Archivelog
- Controlfile
- Create second file name it Backup.rman and add the Rman Script like below
connect target /
run
{
ALLOCATE CHANNEL c1 DEVICE TYPE disk;
ALLOCATE CHANNEL c2 DEVICE TYPE disk;
ALLOCATE CHANNEL c3 DEVICE TYPE disk;
ALLOCATE CHANNEL c4 DEVICE TYPE disk;
backup AS COMPRESSED BACKUPSET tag Full_database_open format ‘E:\RMAN\backup\db_%t_%s_p%p.bkp’ database;
backup AS COMPRESSED BACKUPSET archivelog all format ‘E:\RMAN\backup\archivelog\al_%t_%s_p%p.arch’ delete all input;
backup AS COMPRESSED BACKUPSET current controlfile tag =cf1 format ‘E:\RMAN\backup\cf_%t_%s_p%p.bkp’;
backup tag ORCL_CONTROL current controlfile format ‘E:\RMAN\Controlfile\%d_%T_%s_%p_CONTROL’;
delete noprompt expired backup;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
Follow the screen now :-
- Add Task Name and Description :-
- Add The Time for this Task in this tab
- Another Screen :-
- In This Screen Add Bat File in our case backup.bat
Beautifully explained.
LikeLike