C#来做oracle还原，调用oracle自带函数imp.exe时，需要注意的是：
1、imp.exe 中fromuser 和touser两个关键字； fromuser与exp.exe中的owner对应，为表的所有者，都可以是多个参数，如：fromuser=(A,B,C)
2、imp.exe 进行恢复数据库时，要确定一下恢复用户（方案）的表空间，一般默认为users空间
3、在获取到表空间权限后，要对用户进行恢复权限设置，主要是对表空间的限制，一般处理：grant unlimited tablespace to user(自己的用户)
4、程序中设置了oracle服务端的exp和imp的路径
注意：在C#做备份和还原的时候，都是调用的oracle服务器的自带函数
在用进程来调用备份和还原时，备份完成和结束后，要进行进程释放。
//开始恢复数据库
private void button1_Click(object sender, EventArgs e)
{
string tables = "";
//创建要还原的方案
//从备份的方案中读取
FileStream fs=new FileStream (textBox6.Text,FileMode.Open);
StreamReader smread=new StreamReader(fs);
smread.BaseStream.Seek(0,SeekOrigin.Begin);
string strLine = "";
string backusers = "";
while ((strLine=smread.ReadLine()) != null)
{
backusers += strLine + ",";
}
if (backusers.Length > 0)
{
backusers = backusers.Substring(0, backusers.Length - 1);
tables = backusers;
}
String[]userArr=backusers.Split(',');
string sqluser="";
String[] marks;
string newtables = "";
using (OracleConnection oracon = orclConnection())
{
try
{
oracon.Open();
}
catch (Exception ex)
{
MessageBox.Show("链接数据库错误，错误原因："+ex.Message.ToString());
}
using (OracleTransaction tran = oracon.BeginTransaction())
{
using (OracleCommand com = new OracleCommand())
{
com.Transaction = tran;
string newuser = "";
com.Connection = oracon;
//com.Connection.Open();
foreach (string s in userArr)
{
newuser = s;
//判断是否按照默认的标识进行还原
if (!checkBox1.Checked)//不默认
{
newuser = "";
//tables = "";
//修改还原的方案名称后缀（标识）
marks = s.Split('_');
//修改标识
marks[marks.Count() - 1] = textBox2.Text.ToUpper();
foreach (string mark in marks)
{
newuser += mark + "_";
}
newuser = newuser.Substring(0, newuser.Length - 1);
newtables += newuser + ",";
}
com.CommandText = "Select count(*) from all_users where username='" + newuser + "'";
int i = Convert.ToInt32(com.ExecuteScalar());
//如果存在，删除后还原
if (i > 0)
{
sqluser = "drop user "+newuser+" cascade";
com.CommandText = sqluser;
try
{
com.ExecuteNonQuery();
com.CommandText = "create user " + newuser + " identified by " + newuser + " default tablespace users";
com.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
tran.Rollback();
}
}
if (i == 0)
{
sqluser = "create user " + newuser + " identified by " + newuser+" default tablespace users";
com.CommandText = sqluser;
try
{
com.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
tran.Rollback();
}
}
sqluser = "grant connect,resource,dba to " + newuser;
com.CommandText = sqluser;
com.ExecuteNonQuery();
sqluser = "alter user system quota unlimited on users" ;
com.CommandText = sqluser;
com.ExecuteNonQuery();
//指定还原的方案为还原默认的表空间
sqluser = "grant unlimited tablespace to "+newuser ;
com.CommandText = sqluser;
com.ExecuteNonQuery();
}
if (!checkBox1.Checked)
{
tables = newtables.Substring(0, newtables.Length - 1);
}
tran.Commit();
}
}
}
//}
string filename = textBox5.Text;//恢复文件路径
//导入程序路径
Process p = new Process();
//p.StartInfo.FileName= "D:\\app\\oracle\\product\\11.2.0\\dbhome_1\\BIN\\imp.exe";
p.StartInfo.FileName = System.Configuration.ConfigurationSettings.AppSettings["pathrestroe"].ToString();
p.StartInfo.UseShellExecute = true;
p.StartInfo.CreateNoWindow = false;
p.StartInfo.Arguments = "system/system@orcl file=" + filename + " fromuser=("+backusers+") touser=(" +tables+ ") ignore=y" ;
//p.StartInfo.Arguments = "system/system@orcl file=" + filename + " fromuser=HYGISTK_CONTROLLINE_ZL2 touser=HYGISTK_CONTROLLINE_ZL ignore=y";
p.Start();
p.WaitForExit();
p.Dispose();
}