Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to schedule daily hotbackup using DBMS_SCHEDULER

884225Oct 11 2011 — edited Mar 19 2012
Hii..

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2012
Added on Oct 11 2011
2 comments
236 views