Oracle 11g 数据库备份还原

配置环境变量：

(例如Oracle安装在H:\Oracle目录下)
<wbr><wbr><wbr>path="H:\Oracle\product\11.2.0\dbhome_1\BIN"</wbr></wbr></wbr>

<wbr><wbr><wbr>开始---&gt;运行----&gt;cmd 输入命令</wbr></wbr></wbr>

数据的导出命令：

expsystem/password@oracle<wbr>file='d:\data.dmp ' log=d:\logimp.log<wbr><wbr><wbr><wbr><br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>|<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>|<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>|<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>|<br><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>|<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>|<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>|<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>|<br><wbr><wbr>用户登录身份<wbr><wbr>数据库sid<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>数据备份目录<wbr><wbr><wbr><wbr><wbr><wbr><wbr>日志文件<br><wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

1、导出user1、scott用户下所有的表（注意必须是dba身份登录）
<wbr><wbr>exp<a href="mailto:system/admin@oracle" style="text-decoration:none; color:rgb(72,111,145)">system/admin@oracle</a>file=d:\data.dmp log=d:\logimp.log owner=(user1,scott)<br> 2、导出user1用户下的test表和scott下的emp表（注意必须是dba身份登录）<br><wbr><wbr>exp<a href="mailto:system/admin@oracle" style="text-decoration:none; color:rgb(72,111,145)">system/admin@oracle</a>file=d:\data.dmp log=d:\logimp.log tables=(user1.test,scott.emp)<br> 3、导出登录用户下的所有表<br><wbr><wbr>exp<a href="mailto:soctt/tiger@oracle" style="text-decoration:none; color:rgb(72,111,145)">soctt/tiger@oracle</a>file=d:\data.dmp log=d:\logimp.log<br> 4、导出登录用户下的某个表<br><wbr><wbr>exp<a href="mailto:soctt/tiger@oracle" style="text-decoration:none; color:rgb(72,111,145)">soctt/tiger@oracle</a>file=d:\data.dmp log=d:\logimp.log tables=(emp)<br><wbr><wbr>需要打包在命令后直接加compress=y即可</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

数据的导入命令：

<wbr>imp<a href="mailto:userid=username1/pwd1@orcl" style="text-decoration:none; color:rgb(72,111,145)">userid=username1/pwd1@orcl</a>fromuser=username2<wbr>touser=username3 file=(c:\data.dmp)log=c:\logimp.log</wbr></wbr>

<wbr><wbr>username1:用户名<wbr><br><wbr><wbr><wbr>pwd1:密码<br><wbr><wbr>orcl: 如果数据库在本机，用 实例名，在远程用 网络服务名（oracle 网络配置工具配置的别名）<br><wbr><wbr>username2：data.dmp中的用户名<br><wbr><wbr>username3：需要导入的用户名<br><wbr><wbr>file ：输入你要导入文件名和路径。<br><wbr><wbr>Log：日志文件名和路径</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

<wbr>1 将D:\daochu.dmp 中的数据导入数据库中。<wbr><wbr><wbr></wbr></wbr></wbr></wbr>

<wbr><wbr><wbr>imp<a href="mailto:system/manager@oracle" style="text-decoration:none; color:rgb(72,111,145)">system/manager@oracle</a><wbr>file=d:\daochu.dmp<wbr><wbr><wbr><br><wbr><wbr><wbr>上面可能有点问题，因为有的表已经存在，然后它就报错。在后面加上 ignore=y 就可以了。<wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

<wbr>2 将d:\daochu.dmp中的表table1 导入<wbr></wbr></wbr>

<wbr><wbr><wbr>imp<a href="mailto:user/password@oracle" style="text-decoration:none; color:rgb(72,111,145)">user/password@oracle</a><wbr>file=d:\daochu.dmp<wbr>tables=(table1)<br><wbr><wbr><wbr>下面这句是执行将c盘的oracle的备份的用户user1导入到用户user1的数据库</wbr></wbr></wbr></wbr></wbr></wbr></wbr></wbr>

<wbr><wbr><wbr>imp<a href="mailto:user1/password@oracle" style="text-decoration:none; color:rgb(72,111,145)">user1/password@oracle</a><wbr>file='c\:qhmis20060224.dmp'<wbr>ignore=n<wbr>grants=y<wbr>full=y</wbr></wbr></wbr></wbr></wbr></wbr></wbr>