数据库备份计划带删除

数据库备份计划带删除

echo 开始备份数据库
if not exist d:\db_bak\files md d:\db_bak\files
if not exist d:\db_bak\logs md d:\db_bak\logs

set var=%date:~0,4%%date:~5,2%%date:~8,2%
exp mtss/mtss@192.168.0.183/orcl file=d:\db_bak\files\%var%.dmp log=d:\db_bak\logs\ms_%var%.log owner=(mtss)

echo 删除过久的备份记录

forfiles /p "d:\db_bak" /s /m *.dmp /d -60 /c "cmd /c del @path"
forfiles /p "d:\db_bak" /s /m *.log /d -60 /c "cmd /c del @path"
exit

echo 开始备份数据库
if not exist d:\db_bak\files md d:\db_bak\files
if not exist d:\db_bak\logs md d:\db_bak\logs

set var=%date:~0,4%%date:~5,2%%date:~8,2%
exp mtss/mtss@192.168.0.182/orcl file=d:\db_bak\files\182bak%var%.dmp log=d:\db_bak\logs\ms_182bak%var%.log

echo 删除过久的备份记录

forfiles /p "d:\db_bak" /s /m *.dmp /d -30 /c "cmd /c del @path"
forfiles /p "d:\db_bak" /s /m *.log /d -30 /c "cmd /c del @path"
exit

drop user mtss cascade;

create user mtss identified by mtss
temporary tablespace mtss_temp;

grant connect,resource,dba to mtss;

exit;

sqlplus system/sa@orcl as sysdba  @huifu.sql   

set var=%date:~0,4%%date:~5,2%%date:~8,2%
imp mtss/mtss@192.168.0.183/orcl file=d:\db_bak\files\182bak%var%.dmp log=d:\db_bak\logs\ms_182imp%var%.log full=y statistics=none

echo 开始备份数据库
if not exist d:\db_bak\files md d:\db_bak\files
if not exist d:\db_bak\logs md d:\db_bak\logs

set var=%date:~0,4%%date:~5,2%%date:~8,2%
exp mtss/mtss@192.168.0.183/orcl file=d:\db_bak\files\%var%.dmp log=d:\db_bak\logs\ms_%var%.log owner=(mtss)

echo 删除过久的备份记录

forfiles /p "d:\db_bak" /s /m *.dmp /d -60 /c "cmd /c del @path"
forfiles /p "d:\db_bak" /s /m *.log /d -60 /c "cmd /c del @path"
exit

echo 开始备份数据库
if not exist d:\db_bak\files md d:\db_bak\files
if not exist d:\db_bak\logs md d:\db_bak\logs

set var=%date:~0,4%%date:~5,2%%date:~8,2%
exp mtss/mtss@192.168.0.182/orcl file=d:\db_bak\files\182bak%var%.dmp log=d:\db_bak\logs\ms_182bak%var%.log

echo 删除过久的备份记录

forfiles /p "d:\db_bak" /s /m *.dmp /d -30 /c "cmd /c del @path"
forfiles /p "d:\db_bak" /s /m *.log /d -30 /c "cmd /c del @path"
exit

drop user mtss cascade;

create user mtss identified by mtss
temporary tablespace mtss_temp;

grant connect,resource,dba to mtss;

exit;

sqlplus system/sa@orcl as sysdba  @huifu.sql   

set var=%date:~0,4%%date:~5,2%%date:~8,2%
imp mtss/mtss@192.168.0.183/orcl file=d:\db_bak\files\182bak%var%.dmp log=d:\db_bak\logs\ms_182imp%var%.log full=y statistics=none