1、Oracle9i,oracle10g 备份出来的 DMP 第一次还原到 oracle11g 上是可以的（imp 命令）Oracle11g 备份还原不能用 exp，imp1.在开始菜单运行,输入 cmd 进入命令行-输入 Oralce 命令行命令：sqlplus /nolog2. -sysdba 身份登录 Oracle 数据库conn sys/sysorcl as sysdba3.-更改 oracle 配置参数alter system set “_allow_level_without_connect_by“=true;4. -创建备份输出目录(如果此目录在服务器上不存在，则需要手动创建)cre
2、ate directory dmp as D:oracle;目录不支持中文定义参数 dmp，可以根据自己喜好随便取名；Grant read,write on directory dmp (随便起的路径变量名) to DD(用户名);GRANT EXP_FULL_DATABASE TO 用户;5. 备份数据库Expdp system/syshtsm2008r2 dumpfile=sde.dmp directory=dmp schemas=sde（第 4 步 dmp 定义；schemas 后面接的是表空间）6. 还原数据库Impdp system/syshtsm2008r2 dumpfile=sd
3、e.dmp directory=dmp schemas=sde还原数据库Imp userid=wfbdcggk/wfbdcggk192.168.0.200/wfbdc file=E:ycbdcggk052ycbdcggk0520.dmp ignore=y full=y log=E:ycbdcggk0520ycbdcggk0520.log下面的命令也可以；expdp sde/sdehtsm2008r2 dumpfile=sde.dmp directory=dmpimpdp sde/sdehtsm2008r2 dumpfile=sde.dmp directory=dmpexpdp 用户名/密码实例
4、 dumpfile=备份文件名(sde.dmp) directory=目录名(dmp)impdp 用户名/密码实例 dumpfile=备份文件名(sde.dmp) directory=目录名(dmp)服务器 backup：echo 开始备份数据expdp sde/sdegissvr directory=bak dumpfile=sde-%DATE:0,10%.dump logfile=sde-%DATE:0,10%.log“C:Program files7-Zip7z.exe“ -tzip a %cd%sde-%DATE:0,10%.zip %cd%sde-%DATE:0,10%.dump %
5、cd%sde-%DATE:0,10%.logdel sde-%DATE:0,10%.dumpdel sde-%DATE:0,10%.logexpdp zxkjk/zxkjkgissvr directory=bak dumpfile=zxkjk-%DATE:0,10%.dump logfile=zxkjk-%DATE:0,10%.log“C:Program files7-Zip7z.exe“ -tzip a %cd%zxkjk-%DATE:0,10%.zip %cd%zxkjk-%DATE:0,10%.dump %cd%zxkjk-%DATE:0,10%.logdel zxkjk-%DATE:0
6、,10%.dumpdel zxkjk-%DATE:0,10%.logexpdp kjsjk/kjsjkgissvr directory=bak dumpfile=kjsjk-%DATE:0,10%.dump logfile=kjsjk-%DATE:0,10%.log“C:Program files7-Zip7z.exe“ -tzip a %cd%kjsjk-%DATE:0,10%.zip %cd%kjsjk-%DATE:0,10%.dump %cd%kjsjk-%DATE:0,10%.logdel kjsjk-%DATE:0,10%.dumpdel kjsjk-%DATE:0,10%.logecho 拷贝备份到 201 备份服务器xcopy %cd%sde-%DATE:0,10%.zip 172.18.0.201全要素数据备份 /s/dxcopy %cd%zxkjk-%DATE:0,10%.zip 172.18.0.201全要素数据备份 /s/dxcopy %cd%kjsjk-%DATE:0,10%.zip 172.18.0.201全要素数据备份 /s/decho 删除本地备份文件del %cd%sde-%DATE:0,10%.zipdel %cd%zxkjk-%DATE:0,10%.zipdel %cd%kjsjk-%DATE:0,10%.zip
