Oracle Dtabase Backup Using VB.NET

[Naveed_786]

Dear all,

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

[debasisdas]

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.

[Naveed_786]

I want to know how to write this scrip please would you provide steps with coding example

[debasisdas]

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.

[Naveed_786]

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.

[Naveed_786]

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 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.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.

[debasisdas]

just check if the EXP command works without the batch file.

[Naveed_786]

Same error on command prompt

[Naveed_786]

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

[debasisdas]

creation of folder you need handle from your application.

[Naveed_786]

How???

[debasisdas]

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