開發、測試和演示的資料庫可以使用邏輯備份。
首先，得到所有非系統使用者,然後進行邏輯備份，最後刪除過期的資料。
配合Windows任務排程，可以實現定期備份。

backup.bat

rem 設定備份路徑

set backupdir=c:\tmp\

rem 獲取所有使用者的列表

@echo off

@echo set echo off         >getUsers.sql

@echo set feedback off    >>getUsers.sql

@echo set newpage none    >>getUsers.sql

@echo set pagesize 5000   >>getUsers.sql

@echo set linesize 500    >>getUsers.sql

@echo set verify off      >>getUsers.sql

@echo set pagesize 0      >>getUsers.sql

@echo set term off        >>getUsers.sql

@echo set trims on        >>getUsers.sql

@echo set linesize 600    >>getUsers.sql

@echo set heading off >>getUsers.sql

@echo set timing off   >>getUsers.sql

@echo set verify off   >>getUsers.sql

@echo set numwidth 38   >>getUsers.sql

@echo spool users.txt   >>getUsers.sql

@echo select username from dba_users where account_status='OPEN' and username not in('SYSMAN','DBSNMP','SYSTEM','SYS','MGMT_VIEW'); >>getUsers.sql

@echo spool off           >>getUsers.sql

@echo exit                >>getUsers.sql

sqlplus / as sysdba @getUsers.sql

rem 備份

for /f %%i in (users.txt) do (

    exp userid='/ as sysdba' owner=%%i file=%backupdir%%%i_%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=%backupdir%%%i_%date:~0,4%%date:~5,2%%date:~8,2%.log

)

rem 刪除7天之前的備份

forfiles /P %backupdir% /D -7 /S /M * /C "cmd /c if @isdir==FALSE echo deleting @file>>%backupdir%log.txt && del /q @file"

rem 清理

del getUsers.sql

del users.txt

@echo on

使用Windows指令碼進行邏輯備份

相關文章