How to schedule daily hotbackup using DBMS_SCHEDULER
884225Oct 11 2011 — edited Mar 19 2012Hii..
I want to schedule my daily hot backup using dbms_scheduler package.
Im using Microsoft windows server 2003 R2 service pack 2.
Im using the hotbkup_windows2.bat batch file to take the backup.
the contents of the batch file is the follwowing
set oracle_sid=PROD
set Path=C:\Perl\bin\;D:\APPSORA\proddb\10.2.0\bin;D:\APPSORA\proddb\10.2.0\jdk\bin;D:\APPSORA\proddb\10.2.0\jdk\bin;C:\orant\bin;D:\APPSORA\prodora\8.0.6\bin;C:\Perl\site\bin;C:\Perl\bin;B:\PROGRA~1\MKSTOO~1\bin;B:\PROGRA~1\MKSTOO~1\bin\x11;B:\PROGRA~1\MKSTOO~1\mksnt;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\system32\wbem;c:\program files\hp\hp bto software\bin;c:\program files\hp\hp bto software\bin\opc
set oracle_home=D:\APPSORA\proddb\10.2.0
sqlplus/nolog @D:\BACKUP\hotbkp.sql >> D:\BACKUP\backup.log
Now i want to use this batch file to be scheduled using dbms_scheduler to have the backup daily at 23.59.00.
Can anyone provide me script on how to schedule this using dbms_scheduler and not using OS scheduling..
Thanks in advance.