Backup of Oracle database from .net through code

Question

I want to take backup or restore of my oracle database through .Net code. I searched a lot but not found any correct solution. Like we do backup in SQL server by executing query.

backup database :DatabaseName to disk = ':DestinationPath

same I want to do in Oracle.

I'm pretty sure the Oracle manuals will be able to tell you what's the correct command for this. — Filburt
– Filburt, Commented May 24, 2012 at 12:58
You can use Oracle Data Pump: oracle-base.com/articles/10g/oracle-data-pump-10g.php. You may have to do it from a console script, as opposed to a database script in Oracle. — mservidio
– mservidio, Commented May 24, 2012 at 13:02
@mservidio: dataPump can be started through SQL as well. That's the big advantage over the (obsolete) exp/imp tools — user330315
– user330315, Commented May 24, 2012 at 13:31

mservidio · Accepted Answer · 2012-05-24 13:38:58Z

5

You can use an Oracle utility like exp/imp or the newer Oracle Data Pump to create database exports (backups), though you have to execute these outside of the database, in a command line/terminal window. See this for more information: http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php

Update: I stand corrected. A Data Pump job can be started through PL/SQL. Thanks @a-horse-with-no-NAME.

This article shows how to start a Data Pump job from sql: http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_api.htm#i1006925

edited May 24, 2012 at 13:38

answered May 24, 2012 at 13:28

mservidio

13.1k9 gold badges61 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user330315 Over a year ago

You can start a data pump export through SQL using the dbms_datapump package: docs.oracle.com/cd/B28359_01/appdev.111/b28419/…

Justin Cave Over a year ago

@a_horse_with_no_name - Just to be pedantic, you can start a DataPump export job through PL/SQL, not SQL, right (well, barring a function that uses autonomous transactions and is called from SQL).

user330315 Over a year ago

@JustinCave: yes, good point. But usually an interface/driver that lets you run SQL will also let you run PL/SQL.

Alphatross · Accepted Answer · 2012-07-25 09:40:07Z

Careful: a DataPump or Exp Export is not a real Oracle Backup, and you should test to make sure you can restore from the Dump files you're creating. The closest thing Oracle has to SQL Server's BACKUP DATABASE command is RMAN, and even then it's quite different. But it is very useful to call from a Batch File. I'm both a DBA for SQL Server and Oracle, and the way each Engine performs Backups is one of the biggest differences. Exp and Imp are more similar to SQL's bcp commands (but more powerful). Exp won't backup your Controlfile or AchiveLogs, and you may need these in case of a disaster. With Exp, make sure you use CONSISTENT=Y option (FLASHBACK_TIME for newer DataPump Export). SQL Server backups are much more straight forward, and easier to recover.

SMK · Accepted Answer · 2012-06-16 11:23:06Z

0

I found an easy way to take backup of oracle database though code. I take credentials from user through code and make dynamically batch file of exp/imp commands. and run this batch command with process class.

Thank you all for your responses.

answered Jun 16, 2012 at 11:23

SMK

2,1682 gold badges13 silver badges23 bronze badges

Comments

akjoshi · Accepted Answer · 2012-06-13 07:32:59Z

-3

OledbCommand cmd=new OledbCommand ("backup database databasename to disk ='C:\databasename.bak'",con);

con.open();

cmd.ExecutenonQuery();

con.close();

edited Jun 13, 2012 at 7:32

akjoshi

15.8k13 gold badges108 silver badges122 bronze badges

answered May 24, 2012 at 13:29

Tony

1595 silver badges22 bronze badges

3 Comments

user330315 Over a year ago

That's not the question. The backup database command is invalid for Oracle.

Tony Over a year ago

Thanks buddy.. I came to know... :)

Arsman Ahmad Over a year ago

The guy is asking help for Oracle.

Collectives™ on Stack Overflow

Backup of Oracle database from .net through code

4 Answers 4

3 Comments

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related