Auto Backup of Oracle Database on Windows

Auto Backup of Oracle Database:

We are using batch file system for scheduling database. First write your export string in a notepad and save that notepad  file as  .bat  file.

EXAMPLE:

For example this  is our export string: 

EXPDP system/system@orcl schemas=smarthcm_allied directory=dump_dir logfile=smarthcm_allied.log dumpfile="smarthcm_allied_%date:/=_%_%time::=_%.DMP"  


="smarthcm_allied_%date:/=_%_%time::=_%.DMP"   is used  to have different name at every backup. By this timestamp method you can even schedule  multiple
backup at same day.