rem ***************************************************************************
rem **
rem ** Orabackon.bat file 
rem ** 
rem ** input parameter instance     - ORACLE_SID
rem **       parameter date         - aaaajjj
rem **
rem ***************************************************************************
DATE /T
TIME /T
set ORACLE_SID=%1
set PATHBACKUP=E:\ORACLE\BACKUP\%1
set PATHSCRIPT=E:\ORACLE\BACKUP\SCRIPTS
set PATHINSTANCE=E:\ORACLE\ADMIN\%1
set PATHDATABASE=C:\ORACLE\ORA81\DATABASE
set CURRDATE=%TEMP%\CURRDATE.TMP
DATE /T > %CURRDATE%
set PARSEARG="eol=; tokens=1,2,3,4* delims=/, "
For /F %PARSEARG% %%i in (%CURRDATE%) Do SET YYYYMMDD=%%l%%j%%k
sqlplus -s system/preb%1 @%PATHSCRIPT%\orabackon.sql %1 %YYYYMMDD% %PATHSCRIPT% %PATHBACKUP%
svrmgrl @%PATHSCRIPT%\Back%1.sql
pkzip25 -add %PATHBACKUP%\bac%YYYYMMDD% %PATHINSTANCE%\arch\* %PATHINSTANCE%\bdump\%1* %PATHINSTANCE%\udump\Ora* %PATHINSTANCE%\pfile\init%1.ora %PATHDATABASE%\pwd%1.ora rem %PATHINSTANCE%\exp\exp%YYYYMMDD%.*
del %PATHINSTANCE%\bdump\%1*
del %PATHINSTANCE%\arch\%1*
rem del %PATHINSTANCE%\exp\exp%YYYYMMDD%.*
del %PATHINSTANCE%\udump\Ora*
copy %PATHINSTANCE%\bdump\orabackon.log %PATHBACKUP%\bac%YYYYMMDD%.lst
TIME /T