<div>
You do realize the limitations of using exp/imp as a 'backup'?<br />
<br />
The main one is there is no point-in-time recovery. &nbsp;You can only recover back to the time of the export.<br />
<br />
I would just create a .BAT or .CMD file with the Oracle environment setup like PATH and ORACLE_SID. &nbsp;Then just add that exp command. &nbsp;You can easily add a DATE piece to the exp command.<br />
<br />
check out the BAT date into variable example here:<br />
<a href="http://www.tech-recipes.com/rx/956/windows-batch-file-bat-to-get-current-date-in-mmddyyyy-format/" rel="ugc">http://www.tech-recipes.com/rx/956/windows-batch-file-bat-to-get-current-date-in-mmddyyyy-format/</a>
</div>


<div>
- i would like to add further on creating a .BAT file. you can create a .BAT file contain your script as follows:<br />
<br />
@echo off<br />
exp XX/XXXX file=D:\MANUALTASKS\Manual<wbr />Tasks.dmp log=D:\MANUALTASKS\MANUALT<wbr />ASKS.log tables=MANUAL_TASKS rows=yes indexes=no<br />
<br />
- assuming you save it as backupManualTasks.bat. next schedule it to run in Windows Task Scheduler (start menu&gt;accessories&gt;system tools&gt;task scheduler), set it to run daily and the time to run it. then specify the command to run the batch file as follows:<br />
<br />
%windir%\system32\cmd.exe C:\backupManualTasks.bat<br />
<br />

</div>


<div>
Hi thanks,<br />
<br />
And if I wanted to specify different names each day for the dmp file based on time... how woud i do that? As in the below (I know that the below won't work because the command is not a string, but is there some way to alter the command like that using variables to achieve the result i'm looking for?)<br />
<br />
for example<br />
<br />
variable nowDate = NOW.DATE<br />
<br />
@echo off<br />
exp XX/XXXX file=D:\MANUALTASKS\Manual<wbr />Tasks &amp;&nbsp;nowDate &nbsp;&amp; .dmp log=D:\MANUALTASKS\MANUALT<wbr />ASKS.log tables=MANUAL_TASKS rows=yes indexes=no
</div>


<div>
&gt;&gt;... how woud i do that?<br />
<br />
Add a date piece to the filename. &nbsp;Did you not look at the sample in the link I provided?
</div>


<div>
yeah i looked at it, even put it in a .bat file and ran it, with a pause at the end so i could see what happened. but actually it paused when i just put the last line in, but wouldn't when i put everything in. so i couldn't see the output<br />
<br />
but lets say that it worked and we have SET date=%mm%%dd%%yyyy%<br />
<br />
how do i put the variable 'date' into the command line exactly?<br />
<br />

</div>


<div>
You don't. &nbsp;Just build the variables and try something like:<br />
<br />
exp XX/XXXX file=D:\MANUALTASKS\Manual<wbr />Tasks_%mm%<wbr />%dd%%yyyy%<wbr />.dmp log=D:\MANUALTASKS\MANUALT<wbr />ASKS_%mm%%<wbr />dd%%yyyy%.<wbr />log tables=MANUAL_TASKS rows=yes indexes=no <br />
<br />

</div>


<div>
I don't know, if I try the code below, nothing seems to happen. I think there must be some error which is why it doesn't pause at the end. I can just catch a glimpse of it becuase the console exits and it says '1* was unexpected at this time'<br />
<br />
If I remove the top part of the code below then it seems to run as if _%mm%%dd%%yyyy% part below didn't exist. Table exports with no errors into log file. <br />
<br />
What is wrong with the below code can you tell me?<br />

<pre><code class="code-1 nolinks" id="code-8225033"><span>FOR /F “TOKENS=1* DELIMS= ” %%A IN (‘DATE/T’) DO SET CDATE=%%B</span>
<span>FOR /F “TOKENS=1,2 eol=/ DELIMS=/ ” %%A IN (‘DATE/T’) DO SET mm=%%B</span>
<span>FOR /F “TOKENS=1,2 DELIMS=/ eol=/” %%A IN (‘echo %CDATE%’) DO SET dd=%%B</span>
<span>FOR /F “TOKENS=2,3 DELIMS=/ ” %%A IN (‘echo %CDATE%’) DO SET yyyy=%%B</span>
<span>SET date=%mm%%dd%%yyyy%</span>
<span></span>
<span>exp XX/XXXX file=D:\MANUALTASKS\ManualTasks_%mm%%dd%%yyyy%.dmp log=D:\MANUALTASKS\MANUALTASKS.log tables=MANUAL_TASKS rows=yes indexes=no</span>
</code></pre>
</div>


<div>
Excellent thanks a lot, worked perfectly. <br />
<br />
Thanks for your help once again slightwv!<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi I want to auto back up my oracle database. I ran the command below in the command prompt <br />
<br />
exp XX/XXXX file=D:\MANUALTASKS\Manual<wbr />Tasks.dmp log=D:\MANUALTASKS\MANUALT<wbr />ASKS.log tables=MANUAL_TASKS rows=yes indexes=no<br />
<br />
imp XX/XXXX file=D:\MANUALTASKS\Manual<wbr />Tasks.dmp full=yes<br />
<br />
and it all seemed to work fine. So the next step then is to set this up so that I don't have to do it each day, and also each day to save into a new file so that I can go back to a certain point in time to backup if necessary.<br />
<br />
how is it best to do this? I was thinking of perhaps creating some console application and running daily in the task sheduler... but I've never tried to run command line code from visual studio so not even sure if it can be done. How should I go about this?
</div>
</div>


Hi I want to auto back up my oracle database. I ran the command below in the command prompt 

exp XX/XXXX file=D:\MANUALTASKS\ManualTasks.dmp log=D:\MANUALTASKS\MANUALTASKS.log tables=MANUAL_TASKS rows=yes indexes=no

imp XX/XXXX file=D:\MANUALTASKS\ManualTasks.dmp full=yes

and it all seemed to work fine. So the next step then is to set this up so that I don't have to do it each day, and also each day to save into a new file so that I can go back to a certain point in time to backup if necessary.

how is it best to do this? I was thinking of perhaps creating some console application and running daily in the task sheduler... but I've never tried to run command line code from visual studio so not even sure if it can be done. How should I go about this?

automatically backup oracle database: use task sheduler?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.