scp_rman_db_files.bat

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

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

echo.
echo ************************************* scp_rman_db_files.sh file run begin *******************************
echo.

echo.
echo Warm database backup of $ORACLE_SID Using RMAN
echo Log will be written to %DBS_RMAN_LOG_DIC%\rman_db_%ORACLE_SID%.log
echo.


rem  --the standard output is redirected to the log file
rem  --the err output is redirect to the log file
rem exec >> %DBS_RMAN_LOG_DIC%\rman_db_scp_%ORACLE_SID%.log
rem exec 2>&1


rem  display the Environment Variable Value
echo DBS_BACKUP_BASE :  %DBS_BACKUP_BASE%
echo DBS_BACKUP_DATA_DIC :  %DBS_BACKUP_DATA_DIC%
echo DBS_GEN_SQL_DIC :  %DBS_GEN_SQL_DIC%
echo DBS_BAK_ARCH_DIC1 : %DBS_BAK_ARCH_DIC1%
echo DBS_TAG_DIC :  %DBS_TAG_DIC%
echo BS_BAK_ARCH_DIC2 : %DBS_BAK_ARCH_DIC2%
echo ARCH_DEST2 :  %ARCH_DEST2%

rem  *************************** generate the scp backup script start **************************

@IF "%SCP_FROM_DBS_TO_BS%" == "yes" (
	echo.														> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo rem  make the necessary dictionary 					>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @IF NOT EXIST %BS_SCRIPT_DIC% ^(						>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo 	mkdir %BS_SCRIPT_DIC% 								>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo ^) 													>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo.														>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo rem  make the necessary dictionary 					>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @IF NOT EXIST %BS_BACKUP_DIC% ^(						>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo 	mkdir %BS_BACKUP_DIC% 								>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo ^) 													>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo.														>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo rem  make the necessary dictionary 					>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @IF NOT EXIST %BS_PRE_DATA_DIC% ^(						>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo 	mkdir %BS_PRE_DATA_DIC%								>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo ^) 													>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo.														>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @echo  move the old backup files; 						>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @deltree /y %BS_PRE_DATA_DIC%\* 						>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @cd %BS_BACKUP_DIC% 									>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @move /y %BS_BACKUP_DIC%\data %BS_PRE_DATA_DIC%\ 		>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @move /y %BS_BACKUP_DIC%\log %BS_PRE_DATA_DIC%\ 		>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @move /y %BS_BACKUP_DIC%\backupsql %BS_PRE_DATA_DIC%\ 	>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @move /y %BS_BACKUP_DIC%\arch %BS_PRE_DATA_DIC% 		>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @move /y %BS_BACKUP_DIC%\arch2 %BS_PRE_DATA_DIC% 		>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @move /y %BS_BACKUP_DIC%\tag %BS_PRE_DATA_DIC%\ 		>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @echo  copy rman backup files; 						>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @xcopy /s/e/y %DBS_BACKUP_BASE%\* %BS_BACKUP_DIC%\ 	>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @xcopy /s/e/y %DBS_SCRIPT_DIC%\* %BS_SCRIPT_DIC%\ 	>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @IF %ERRORLEVEL% EQU 1 ^(								>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo 	echo yes ^> %DBS_TAG_DIC%\db_scp_bak.flag			>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo ^) ELSE ^(												>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo    echo no ^> %DBS_TAG_DIC%\db_scp_bak.flag			>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo ^)														>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @echo  delete previous backup files; 					>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo @deltree /y %BS_PRE_DATA_DIC%\* 						>> %DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
	echo begin copy
	%DBS_BAK_GEN_FILE_DIC%\scp_db_data_g.bat
)



rem  *************************** generate the scp backup script end **************************

echo.
echo " ************************************* scp_rman_db_files.sh file run end *******************************"
echo.