RMAN
Backup Scheduling in Windows 7
1. Create directory F:\backup\scripts
2. Write database backup scripts in F:\backup\scrips\orcl_backup.txt
|
orcl_backup.txt
|
|
run
{
Allocate channel
ch1 device type disk format ‘F:\backup\database\orcl\DB_FULL_%d_%D_%M_%Y_%s_%p_%U’;
}
|
3. Create batch file F:\backup\scrips\orcl_rman_backup.bat
start ---- RUN ----- notepad ----- save
start ---- RUN ----- notepad ----- save
File Name à ORCL_RMAN_BACKUP.BAT
Encoding à UTF – 8
Click on SAVE
|
Orcl_rman_backup.bat
|
|
SET
ORACLE_SID=ORCL
SET
ORACLE_HOME=F:\ORACLE\PRODUCT\10.2.0\DB_1
F:
CD
F:\ORACLE\PRODUCT\10.2.0\DB_1\BIN
rman
target=sys/aditya@orcl2 cmdfile F:\datapump\schema\rman_backup.txt msglog
F:\datapump\schema\rman_backup.txt
|
4. Start --run --- taskschd.msc
5. Left Side pane click on Task
Scheduler Library
6. Right Side Pane click on Create Taks
7. Click on General tab à write task Name
-------------ORCL_BACKUP_FULL
8. Click On Triggers Tab --- NEW---
Begin The Task à on a schedule
Setting select Daily and there is various option
please choose according to your need
Click on OK
9. Click on Action Tab --- NEW --
Action ---- Start a Program
Setting ----
Program/Scripts -- F:\backup\scrips\orcl_rman_backup.bat
( Browse the batch file )
Add Argument : -a adv
Start in optional : F:\oracle\product\10.2.0\db_1\bin
Click on OK