Can any one tell me how can i take bakup on Every minute and hourly and complete whole day backup using VB.NET i.e i want to know the coding example
Thanks in advance
You can write the back up script into a batch file and schedule to run the same using scheduled tasks or execute from your application.
I want to know how to write this scrip please would you provide steps with coding example
for /f "tokens=2,3,4 delims=/ " %%a in ('date /t') do set fdate=%%a%%b%%c for /f "tokens=1,2,3,4,5 delims=: " %%a in ('time /t') do set ftime=%%a%%b%%c%%d%%e exp userid=DEBASIS_USER/DEBASIS_PASSWORD@DEBASIS_DB file=E:\BACKUP\backup%fdate%%ftime%.dmp log=E:\BACKUP\backup%fdate%%ftime%.log
copy the entire thing and create a batch file.
you need to change the log in credentials.
you can schedule the batch file to be executed as desired using Scheduled Tasks in windows or use your own application.
Thanks only one thing more how to specify my server which is on My domain
and i want to exp dump for every user in different folder.
I have made batch file as the code provided by you here is the code
for /f "tokens=2,3,4 delims=/ " %%a in ('date /t') do set fdate=%%a%%b%%c for /f "tokens=1,2,3,4,5 delims=: " %%a in ('time /t') do set ftime=%%a%%b%%c%%d%%e exp userid=HR/HR@dummy file=D:\BACKUP\backup%fdate%%ftime%.dmp log=D:\BACKUP\backup%fdate%%ftime%.log
but when i run the batch file it gives me following error
Connected to: Oracle9i Enterprise Edition Release 126.96.36.199.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 188.8.131.52.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
EXP-00056: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00000: Export terminated unsuccessfully
What could be the problem.
just check if the EXP command works without the batch file.
Same error on command prompt
Its working now please now tell me i want to take backup on two basis
1. Hourly basis
2. Whole backup
For example i want to make automatically folder for every hour and then want to make backup in it with department name(There should be main folder Today then hourly folder should be inside it).
Similarly i want to make backup of whole day which should be date wise
creation of folder you need handle from your application.
if you are using .NET, you should be able to do that.
any ways the dump file will be created with data and time, so should not be a problem if you are storing in a single directory.
You can also add schema name to the file name as well