如何进行oracle数据库的备份? [英] How to take BACKUP of oracle database ?

问题描述

大家好，
我是印度的Subrat.
谁能告诉我如何使用VB.NET 2008备份oracle数据库.

查询的详细信息

我正在vb.net 2008中从事医院管理项目.在该项目中，我使用Oracle作为后端来存储数据.我想通过代码备份数据库.

因此，如果有人知道该问题的解决方案，请告诉我.

谢谢.............
Subrat，桌面应用程序开发人员

Hello Everybody,
I am Subrat from India.
Can anybody tell me How to take backup of oracle database Using VB.NET 2008.

Details of the Query

I am Working on a Hospital Managment Project in vb.net 2008. where I am using Oracle as back-end for storing datas. And I want to take a backup of the database through code.

So, if anybody knows the solution of this problem Please tell me.

Thanks.............
Subrat, Desktop Application Developer
Rourkela, India.

推荐答案

OledbCommand cmd = new OledbCommand(将数据库数据库名称备份到磁盘=''C:\ databasename.bak"，con);
con.open();
cmd.ExecutenonQuery();
con.close();

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

最好的方法是查看Oracle站点，此链接提供了许多有关使用.net备份数据库的结果.

Best thing to do is Look at the Oracle Site this link has many results for looking at Backing up a database with .net

Oracle Database Backup[^]

txtPwd =用户密码
txtHS =主机字符串
文件名=例如c:\ BackupFile.dmp

txtPwd =User Password
txtHS =Host String
filename =e.g. c:\BackupFile.dmp

Shell("exp " & txtUser.Text.ToString.Trim & "/" & txtPwd.Text.ToString & "@" & txtHS.Text.ToString & " buffer=4096 grants=Y file=" & filename, vbNormalFocus)

将上述代码写在按钮上执行.它从oracle数据库中备份一位用户的所有数据.
苏尼尔·库马尔
S/D

Write above code on a button to execute. It takes backup of all data of one user from oracle database.
Sunil Kumar
S/D

这篇关于如何进行oracle数据库的备份?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！