oracle 备份还原

 

echo    /**************DYFHYS正式服务器数据库自动备份******************/

set filename=dyfhys%date:~0,4%%date:~5,2%%date:~8,2%_version10g
echo %filename%

E:\app\Administrator\product\11.2.0\dbhome_1\BIN\expdp dyfls/dyfls@dyfhys DIRECTORY=dyfhys_dump DUMPFILE=%filename%.dmp SCHEMAS=dyfls version=10.2.0

copy E:\dump_backup\%filename%.dmp \\10.0.3.XXX\f$\好药师90.58正式库备份

 还原

新建库表，然后

impdp system/dyfls@dyfhys DUMPFILE=DYFHYS20120221_VERSION10G.DMP  SCHEMAS=dyfls