Difference between revisions of "Auto Backup of Oracle Database on Windows"

From SmartHCM Wiki
Jump to navigation Jump to search
 
Line 22: Line 22:
  
  
<pre>
+
 
Write this export string in notepad file and save it as .bat file.
+
'''Write this export string in notepad file and save it as .bat file.'''
</pre>
 
  
  
Line 32: Line 31:
  
  
<pre>
+
 
NOW, Schedule  this  batch file by TASK SCHEDULER of WINDOWS.
+
'''NOW, Schedule  this  batch file by TASK SCHEDULER of WINDOWS.'''
</pre>
+
 
  
  
Line 40: Line 39:
 
[[File:database_backup_windows_3.png]]
 
[[File:database_backup_windows_3.png]]
  
<pre>
+
 
Click create basic task.
+
'''Click create basic task.'''
</pre>
+
 
  
  
Line 50: Line 49:
  
  
<pre>
+
 
Write Name and Description of task whatever you want.
+
'''Write Name and Description of task whatever you want.'''
</pre>
+
 
  
  
Line 60: Line 59:
  
  
<pre>
+
 
Pick up Task Trigger i.e select duration or event when you want task to be performed. In our case we are selecting  Daily.
+
'''Pick up Task Trigger i.e select duration or event when you want task to be performed. In our case we are selecting  Daily.'''
</pre>
 
  
  
Line 70: Line 68:
  
  
<pre>
+
 
Set timing of task.
+
'''Set timing of task.'''
</pre>
+
 
  
  
Line 80: Line 78:
  
  
<pre>
+
'''In our case action is Start a pro</pre>gram.'''
In our case action is Start a program.
 
</pre>
 
  
  
Line 90: Line 86:
  
  
<pre>
+
 
Browse to the batch file you have prepared earlier.
+
'''Browse to the batch file you have prepared earlier.'''
</pre>
+
 
  
  
Line 105: Line 101:
  
  
<pre>
+
 
Finish  the setup.
+
'''Finish  the setup.'''
</pre>
 

Latest revision as of 11:06, 2 February 2017


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.

Database backup windows 1.png



Write this export string in notepad file and save it as .bat file.


Database backup windows 2.png



NOW, Schedule this batch file by TASK SCHEDULER of WINDOWS.



Database backup windows 3.png


Click create basic task.



Database backup windows 4.png



Write Name and Description of task whatever you want.



Database backup windows 5.png



Pick up Task Trigger i.e select duration or event when you want task to be performed. In our case we are selecting Daily.


Database backup windows 6.png



Set timing of task.



Database backup windows 7.png


In our case action is Start a program.


Database backup windows 8.png



Browse to the batch file you have prepared earlier.



Database backup windows 9.png



Database backup windows 10.png



Finish the setup.