Windows平台下Oracle数据库exp全备脚本，根据时间保留备份数及自

以下代码由PHP站长网 52php.cn收集自互联网

现在PHP站长网小编把它分享给大家，仅供参考

@echo off

SET ORACLE_SID=orcl
SET NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
SET Year=%date:~0,4%
SET Month=%date:~5,2%
SET Day=%date:~8,2%
SET Hour=%time:~0,2%
SET Minute=%time:~3,2%
SET Second=%time:~6,2%
SET NOWDATE=%Year%_%Month%_%Day%
SET NOWTIME=%Year%%Month%%Day%%Hour%%Minute%%Second%

SET BACKUPDIR=d:Bak
IF NOT EXIST %BACKUPDIR% (
    MD %BACKUPDIR%
)
IF NOT EXIST %BACKUPDIR%%NOWDATE% (
    MD %BACKUPDIR%%NOWDATE%
)

SET USERNAME=system
SET PASSWORD=system

exp %USERNAME%/%PASSWORD%@%ORACLE_SID% file=%BACKUPDIR%%NOWDATE%%COMPUTERNAME%-%ORACLE_SID%-fullbackup_%NOWTIME%.dmp log=%BACKUPDIR%%NOWDATE%%COMPUTERNAME%-%ORACLE_SID%-fullbackup_%NOWTIME%.log full=y direct=y consistent=y buffer=102400

SET HOST=1.1.1.1
SET FTP_USERNAME=backup
SET FTP_PASSWORD=backup

cd /d %BACKUPDIR%

echo open %HOST% >> %BACKUPDIR%ftp.cfg 
echo user %FTP_USERNAME% %FTP_PASSWORD% >> %BACKUPDIR%ftp.cfg 
echo bin >> %BACKUPDIR%ftp.cfg 
echo mkdir oradmp >> %BACKUPDIR%ftp.cfg 
echo cd oradmp >> %BACKUPDIR%ftp.cfg 
echo mkdir %COMPUTERNAME% >> %BACKUPDIR%ftp.cfg 
echo cd %COMPUTERNAME% >> %BACKUPDIR%ftp.cfg 
echo mkdir %NOWDATE% >> %BACKUPDIR%ftp.cfg 
echo cd %NOWDATE% >> %BACKUPDIR%ftp.cfg 
echo lcd %NOWDATE% >> %BACKUPDIR%ftp.cfg 
echo mput * >> %BACKUPDIR%ftp.cfg 
echo bye >> %BACKUPDIR%ftp.cfg 
ftp -i -n -v -s:%BACKUPDIR%ftp.cfg
del /f /s /q %BACKUPDIR%ftp.cfg 2>&1 >nul

forfiles /P %BACKUPDIR% /S /C "cmd /c del /f /s /q @file" /D -1 2>&1 >nul
for /f "usebackq" %%d in (`"dir /ad/b/s | sort /R"`) do rd "%%d" 2>&1 >nul
for /f "tokens=*" %%a in ('dir /b /ad /s "%BACKUPDIR%"^|sort /r') do rd "%%a" 2>&1 >nul

以上内容由PHP站长网【52php.cn】收集整理供大家参考研究

如果以上内容对您有帮助，欢迎收藏、点赞、推荐、分享。

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!