ORACLE遠(yuǎn)程備份 本地還原

1、ORACLE遠(yuǎn)程備份+本地還原一 創(chuàng)建連接：打開(kāi)創(chuàng)建遠(yuǎn)程連接：圖1-1步驟1. 選擇“服務(wù)命名”：圖1-2填寫(xiě)“網(wǎng)絡(luò)服務(wù)名”，（即圖1-3登錄時(shí)用的“數(shù)據(jù)庫(kù)”），然后點(diǎn)擊下一步；圖1-3步驟2. 選擇TCP/IP（Internet協(xié)議），點(diǎn)擊下一步；圖1-4步驟3. 填寫(xiě)主機(jī)名（連接的計(jì)算機(jī)的IP地址）、端口號(hào)，點(diǎn)擊下一步；圖1-5步驟4. 填寫(xiě)服務(wù)名：要連接的遠(yuǎn)程數(shù)據(jù)庫(kù)的實(shí)例名圖1-6步驟5. 點(diǎn)擊完成；圖1-7二 連接遠(yuǎn)程數(shù)據(jù)庫(kù)并進(jìn)行備份設(shè)置備份腳本：先備份，然后保留最近10天的數(shù)據(jù)；然后運(yùn)行腳本REMset CURDATE=%date:0,4%date:5,2%date:8,2%set

2、CURTIME=%time:0,2%REMif "%CURTIME%"=" 0" set CURTIME=00if "%CURTIME%"=" 1" set CURTIME=01if "%CURTIME%"=" 2" set CURTIME=02if "%CURTIME%"=" 3" set CURTIME=03if "%CURTIME%"=" 4" set CURTIME=04if "

3、%CURTIME%"=" 5" set CURTIME=05if "%CURTIME%"=" 6" set CURTIME=06if "%CURTIME%"=" 7" set CURTIME=07if "%CURTIME%"=" 8" set CURTIME=08if "%CURTIME%"=" 9" set CURTIME=09REMif not exist "backup" mkdi

4、r backupif not exist "backup%CURDATE%"mkdir backup%CURDATE%if not exist "backup%CURDATE%CURTIME%" mkdir backup%CURDATE%CURTIME%set CURDIR=backup%CURDATE%CURTIME%set FILENAME=%CURDIR%BAKREMexp cs/csCS file=%FILENAME%.dmp log=%FILENAME%.log /*exp 用戶名/密碼網(wǎng)絡(luò)服務(wù)名 */ECHO OFFset DELAY_DAY

5、=-10echo wscript.echo dateadd("d",%DELAY_DAY%,date) >%tmp%tmp.vbsfor /f "tokens=1,2,3* delims=-" %i in ('cscript /nologo %tmp%tmp.vbs') do set y=%ifor /f "tokens=1,2,3* delims=-" %i in ('cscript /nologo %tmp%tmp.vbs') do set m=%jfor /f "tokens=1,

6、2,3* delims=-" %i in ('cscript /nologo %tmp%tmp.vbs') do set d=%kREM if %m% LSS 9 set m=0%m%REM if %d% LSS 9 set d=0%d%if "%m%"="0" set m=00if "%m%"="1" set m=01if "%m%"="2" set m=02if "%m%"="3" set m=03if &

7、quot;%m%"="4" set m=04if "%m%"="5" set m=05if "%m%"="6" set m=06if "%m%"="7" set m=07if "%m%"="8" set m=08if "%m%"="9" set m=09if "%d%"="0" set d=00if "%d%"

8、;="1" set d=01if "%d%"="2" set d=02if "%d%"="3" set d=03if "%d%"="4" set d=04if "%d%"="5" set d=05if "%d%"="6" set d=06if "%d%"="7" set d=07if "%d%"="8" set d=08if "%d%"="9" set d=09set LASTDATE=%y%m%d%set OLDDIR=backup%LASTDATE%echo start de