os_bak_arch.bat

Oracle RMAN scripts, windows下Oracle RMAN实现的自动备份脚本.

call I:\example\backup\rman_backup_script_win\set_env.bat

@echo.
@echo ************************************* OS_bak_arch.bat file run begin *******************************
@echo.


@echo  display and write the err tag, if the previous scp to the backup server operation was failed

@%DBS_BIN_FILE_DIC%\cat.exe %DBS_TAG_DIC%\rman_db_bak.flag | %DBS_BIN_FILE_DIC%\grep.exe rman_db_bak_begin
@IF %ERRORLEVEL% EQU 0 (
	echo Warnning : " %DBS_TAG_DIC%\rman_db_bak.flag " is rman db bak begin
  	echo.
  	echo !!!!!!!!!! The action of scp backup Oracle archived redo log Files to backup server Failed !!!!!!!!!!!
  	echo !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!  because the rman backup is working !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
  	echo.
  	
  	exit 1;
)

@%DBS_BIN_FILE_DIC%\cat.exe %DBS_TAG_DIC%\arch_scp_bak.flag | %DBS_BIN_FILE_DIC%\grep.exe yes
@IF %ERRORLEVEL% EQU 1 (
	echo xxxxxxxxxxxxxxx ERROR: " %DBS_TAG_DIC%\db_scp_bak.flag " is no xxxxxxxxxxxxxxx 
  	echo.
  	echo "xxxxxxxxxxxxxxx  The operation of scping RMAN backup Files to backup server Failed xxxxxxxxxxxxxxx 
  	echo.
  	echo yes > %DBS_TAG_DIC%\arch_scp_bak_err.flag
)

@IF NOT EXIST %DBS_TAG_DIC%\db_backup.tag (
	%DBS_BIN_FILE_DIC%\touch.exe %DBS_TAG_DIC%\backup_arch.flag
)

@echo     Mannual switch online redo log
@sqlplus -s %USERPASS% @%DBS_CONF_FILE_DIC%\archive_arch.sql

@IF %ERRORLEVEL% EQU 1 (
	echo.
	echo xxxxxxxxxxxxxxx ERROR:  Mannual switch online redo log failed xxxxxxxxxxxxxxx 
  	echo.
)


@echo  generate backup arch files for the first archived directory
@cd %ARCH_DEST1%
@%DBS_BIN_FILE_DIC%\find.exe %ARCH_DEST1% -newer %DBS_TAG_DIC%\backup_arch.flag -a -type f -print > %DBS_BAK_ARCH_DIC1%\bk_arch_t.list

@%DBS_BIN_FILE_DIC%\awk.exe '{ full_name = $0; gsub("/","\\",full_name); print full_name;}' %DBS_BAK_ARCH_DIC1%\bk_arch_t.list >%DBS_BAK_ARCH_DIC1%\bk_arch.list

@%DBS_BIN_FILE_DIC%\awk.exe 'BEGIN {arch_target=ENVIRON["DBS_BAK_ARCH_DIC1"]; arch_test=ENVIRON["ARCH_DEST1"]} { full_name = $0; if($0!="") {n = length(arch_test); log_name = substr(full_name,n + 2); print "copy " full_name " " arch_target "\\" log_name}}' %DBS_BAK_ARCH_DIC1%\bk_arch.list >%DBS_GEN_SQL_DIC%\arch.%ORACLE_SID%.bat

@%DBS_BIN_FILE_DIC%\touch.exe %DBS_TAG_DIC%\backup_arch.flag


@echo     Copying first archived directory ...
@%DBS_GEN_SQL_DIC%\arch.%ORACLE_SID%.bat



@echo.
@echo  ************************************* OS_bak_arch.bat file run end *******************************
@echo.