Oracle9i,oracle10g备份出来的DMP第一次还原到oracle11g上是可以的（imp命令） Oracle11g 备份还原不能用exp，imp 1.在开始菜单运行,输入cmd进入命令行 ----输入Oralce命令行命令： sqlplus /nolog 2. ----sysdba身份登录Oracle数据库 conn sys/sys@orcl as sysdba 3.----更改oracle配置参数
alter system set \
4. ----创建备份输出目录(如果此目录在服务器上不存在，则需要手动创建) create directory dmp as 'D:\\oracle'; 目录不支持中文
定义参数dmp，可以根据自己喜好随便取名；
Grant read,write on directory dmp (随便起的路径变量名) to DD(用户名); GRANT EXP_FULL_DATABASE TO 用户; 5. 备份数据库
Expdp system/sys@htsm2008r2 dumpfile=sde.dmp directory=dmp schemas=sde （第4步dmp定义；schemas后面接的是表空间） 6. 还原数据库
Impdp system/sys@htsm2008r2 dumpfile=sde.dmp directory=dmp schemas=sde
还原数据库
Imp userid=wfbdcggk/wfbdcggk@192.168.0.200/wfbdc file=E:\\ycbdcggk052\\ycbdcggk0520.dmp ignore=y full=y log=E:\\ycbdcggk0520\\ycbdcggk0520.log
下面的命令也可以；
expdp sde/sde@htsm2008r2 dumpfile=sde.dmp directory=dmp impdp sde/sde@htsm2008r2 dumpfile=sde.dmp directory=dmp
expdp 用户名/密码@实例dumpfile=备份文件名(sde.dmp) directory=目录名(dmp) impdp 用户名/密码@实例dumpfile=备份文件名(sde.dmp) directory=目录名(dmp)
服务器backup：
echo 开始备份数据
expdp sde/sde@gissvr directory=bak dumpfile=sde-úTE:~0,10%.dump logfile=sde-úTE:~0,10%.log \files\\7-Zip\\7z.exe\-tzip a í%\\sde-úTE:~0,10%.zip í%\\sde-úTE:~0,10%.dump í%\\sde-úTE:~0,10%.log
del sde-úTE:~0,10%.dump del sde-úTE:~0,10%.log
expdp zxkjk/zxkjk@gissvr directory=bak dumpfile=zxkjk-úTE:~0,10%.dump logfile=zxkjk-úTE:~0,10%.log \files\\7-Zip\\7z.exe\-tzip a í%\\zxkjk-úTE:~0,10%.zip í%\\zxkjk-úTE:~0,10%.dump í%\\zxkjk-úTE:~0,10%.log
del zxkjk-úTE:~0,10%.dump del zxkjk-úTE:~0,10%.log
expdp kjsjk/kjsjk@gissvr directory=bak dumpfile=kjsjk-úTE:~0,10%.dump logfile=kjsjk-úTE:~0,10%.log \files\\7-Zip\\7z.exe\-tzip a í%\\kjsjk-úTE:~0,10%.zip í%\\kjsjk-úTE:~0,10%.dump í%\\kjsjk-úTE:~0,10%.log del kjsjk-úTE:~0,10%.dump del kjsjk-úTE:~0,10%.log
echo 拷贝备份到201备份服务器
xcopy í%\\sde-úTE:~0,10%.zip \\\\172.18.0.201\\全要素数据备份\\ /s/d xcopy í%\\zxkjk-úTE:~0,10%.zip \\\\172.18.0.201\\全要素数据备份\\ /s/d xcopy í%\\kjsjk-úTE:~0,10%.zip \\\\172.18.0.201\\全要素数据备份\\ /s/d
echo 删除本地备份文件
del í%\\sde-úTE:~0,10%.zip del í%\\zxkjk-úTE:~0,10%.zip del í%\\kjsjk-úTE:~0,10%.zip