Difference between revisions of "Auto Backup of Oracle Database on Windows"
Jump to navigation
Jump to search
Mustafasajid (talk | contribs) |
Mustafasajid (talk | contribs) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | + | ||
| + | |||
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. | 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:''' | '''EXAMPLE:''' | ||
| + | |||
| + | For example this is our export string: | ||
<pre> | <pre> | ||
| − | |||
| − | |||
EXPDP system/system@orcl schemas=smarthcm_allied directory=dump_dir logfile=smarthcm_allied.log dumpfile="smarthcm_allied_%date:/=_%_%time::=_%.DMP" | EXPDP system/system@orcl schemas=smarthcm_allied directory=dump_dir logfile=smarthcm_allied.log dumpfile="smarthcm_allied_%date:/=_%_%time::=_%.DMP" | ||
| Line 20: | Line 20: | ||
[[File:database_backup_windows_1.png]] | [[File:database_backup_windows_1.png]] | ||
| − | + | ||
| − | 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.''' | ||
| Line 29: | Line 30: | ||
| − | + | ||
| − | NOW, Schedule this batch file by TASK SCHEDULER of WINDOWS. | + | |
| − | + | '''NOW, Schedule this batch file by TASK SCHEDULER of WINDOWS.''' | |
| + | |||
| + | |||
[[File:database_backup_windows_3.png]] | [[File:database_backup_windows_3.png]] | ||
| − | + | ||
| − | Click create basic | + | '''Click create basic task.''' |
| − | + | ||
| Line 45: | Line 48: | ||
| − | + | ||
| − | Write Name and Description of task whatever you want. | + | |
| − | + | '''Write Name and Description of task whatever you want.''' | |
| + | |||
| + | |||
[[File:database_backup_windows_5.png]] | [[File: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. | + | |
| − | + | ||
| + | '''Pick up Task Trigger i.e select duration or event when you want task to be performed. In our case we are selecting Daily.''' | ||
| Line 61: | Line 67: | ||
| − | + | ||
| − | Set timing of task. | + | |
| − | + | '''Set timing of task.''' | |
| + | |||
| + | |||
[[File:database_backup_windows_7.png]] | [[File:database_backup_windows_7.png]] | ||
| − | + | ||
| − | In our case action is Start a | + | |
| − | </pre> | + | '''In our case action is Start a pro</pre>gram.''' |
| + | |||
| Line 76: | Line 85: | ||
| − | + | ||
| − | Browse to the batch file you have prepared earlier. | + | |
| − | + | '''Browse to the batch file you have prepared earlier.''' | |
| + | |||
| + | |||
| Line 89: | Line 100: | ||
| − | + | ||
| − | Finish the setup. | + | |
| − | + | '''Finish the setup.''' | |
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.
Write this export string in notepad file and save it as .bat file.
NOW, Schedule this batch file by TASK SCHEDULER of WINDOWS.
Click create basic task.
Write Name and Description of task whatever you want.
Pick up Task Trigger i.e select duration or event when you want task to be performed. In our case we are selecting Daily.
Set timing of task.
In our case action is Start a program.
Browse to the batch file you have prepared earlier.
Finish the setup.
