各类数据库备份命令汇总

//说明：编写一个含以下内容的bat批处理文件，在系统执行任务中定时执行，则形成定时数据库备份策略

@echo off
echo 正在备份TX_SJ_JYGL Oracle 数据库，请稍等......
exp userid='system/RKZX@192.168.10.199/ORCL' owner=TXSJJYGL compress=n file=D:\DatabaseBackup\ORACLE\TXSJJYGL%date:~0,4%%date:~5,2%%date:~8,2%.dmp

echo 正在备份YZWLW Oracle 数据库，请稍等......
exp userid='system/RKZX@192.168.10.199/ORCL' owner=YZWLW compress=n file=D:\DatabaseBackup\ORACLE\YZWLW%date:~0,4%%date:~5,2%%date:~8,2%.dmp

echo 正在备份TX_JYGL Oracle 数据库，请稍等......
exp userid='system/RKZX@192.168.10.199/ORCL' owner=TXJYGL compress=n file=D:\DatabaseBackup\ORACLE\TXJYGL%date:~0,4%%date:~5,2%%date:~8,2%.dmp

echo 正在备份JYDB Oracle 数据库，请稍等......
exp userid='system/RKZX@192.168.10.199/ORCL' owner=JYDB compress=n file=D:\DatabaseBackup\ORACLE\JYDB%date:~0,4%%date:~5,2%%date:~8,2%.dmp

echo 正在备份TX_WLWGKPT Oracle 数据库，请稍等......
exp userid='system/RKZX@192.168.10.199/ORCL' owner=TX_WLWGKPT compress=n file=D:\DatabaseBackup\ORACLE\TX_WLWGKPT%date:~0,4%%date:~5,2%%date:~8,2%.dmp

echo 正在备份TX_ZDZFJGXT Oracle 数据库，请稍等......
exp userid='system/RKZX@192.168.10.199/ORCL' owner=TX_ZDZFJGXT compress=n file=D:\DatabaseBackup\ORACLE\TX_ZDZFJGXT%date:~0,4%%date:~5,2%%date:~8,2%.dmp

echo 正在删除过期备份，请稍等......
forfiles /p "D:\DatabaseBackup\ORACLE" /s /m *.* /d -15 /c "cmd /c del @path"

CD D:\dmdbms\bin
echo 正在备份TX_SJ_JYGL DM数据库，请稍等......
dexp USERID=TX_SJ_JYGL/RKZXRKZX FILE=D:\DatabaseBackup\DM\TX_SJ_JYGL%date:~0,4%%date:~5,2%%date:~8,2%.dmp FULL=y

echo 正在备份TX_JYGL DM数据库，请稍等......
dexp USERID=TX_JYGL/RKZXRKZX FILE=D:\DatabaseBackup\DM\TX_JYGL%date:~0,4%%date:~5,2%%date:~8,2%.dmp FULL=y

echo 正在删除过期备份，请稍等......
forfiles /p "D:\DatabaseBackup\DM" /s /m *.* /d -15 /c "cmd /c del @path"

cd D:\GBase\Server\bin
echo 正在备份TX_JYGL Gbase 数据库，请稍等......
dump.exe -uTX_JYGL -pRKZXRKZX --opt -R tx_jygl>D:\DatabaseBackup\GBASE\tx_jygl_%date:~0,4%%date:~5,2%%date:~8,2%.SQL

echo 正在备份TX_SJ_JYGL Gbase 数据库，请稍等......
dump.exe -uTX_SJ_JYGL -pRKZXRKZX --opt -R tx_sj_jygl>D:\DatabaseBackup\GBASE\tx_sj_jygl_%date:~0,4%%date:~5,2%%date:~8,2%.SQL

echo 正在删除过期备份，请稍等......
forfiles /p "D:\DatabaseBackup\GBASE" /s /m *.* /d -15 /c "cmd /c del @path"

echo 任务完成！