oracle11g自動備份

1、一、以exp命令備份     1.首先做個批處理腳本:backup.bat  腳本內(nèi)容如下        echo off       set curdate=%date:0,4%date:5,2%date:8,2%       set backuppath=D:backup       md %backuppath%       exp scot

2、t/tiger127.0.0.1/orcl file=%backuppath%curdate%.dmp owner(scott)                                    log=%backuppath%curdate%.log        forfiles /p "D:backup" /s /m *.dmp /d -

3、30 /c "cmd /c del file"    說明：在備份之前先在D盤建個backup文件夾.   2.以Windows中的計劃任務程序來觸發(fā)這個備份腳本（以Win7為例）(1)完成配置，這個自動備份腳本會在每天10:43的時候執(zhí)行，將數(shù)據(jù)備份到D:backup文件夾下 格式為:20151212.dmp2.導入dmp文件的命令spool log.txt;drop user scott cascade;drop tablespace SCOTT including contents and datafiles;create ta

4、blespace SCOTT logging  datafile 'D:orclSCOTT .dbf'size 50m  autoextend on  next 50m maxsize 20480m  extent management local; create user scott identified by tiger default tablespace SCOTT;grant connect,resource to scott;grant dba to scott;spool off;exit;在dos窗口輸入命名導入

5、數(shù)據(jù)文件  imp scott/tigerORCL file=20151212.dmp full=Y二、以expdp命名備份腳本如下create directory mydmp as 'D:backup'  -directory指定導出到本地目錄-授權給操作用戶這個mydmp目錄的權限grant read, write on directory mydmp to scott-需要超級管理員的賬號 sysdba-查看一下是否存在該目錄select * from dba_directories;執(zhí)行腳本如下ech

6、o offrem set backupfile=%date:0,4%date:5,2%date:8,2%.dmp rem set logfile=%date:0,4%date:5,2%date:8,2%.logrem delete 30days filesforfiles /p "D:backup" /d -30  /c "cmd /c echo deleting file . && del /f path"cd D:backuprem backup schemasset backupfile=%date:0,4%date:5,2%date:8,2%.dmpset logfile=%date:0,4%date:5,2%date:8,2%.logexpdp scott/tiger directory=mydmp  dumpfile=%backupfile%  logfile=%logfile% schemas=scott parallel=4用expdp導出的必須要用imp