REM ######################################################################################## REM # Script name: TOTSA-FullExpDPBck.bat REM # Usage : execute directly, no option needed REM ################################################ REM # Change control REM # 1.00 14/12/2025 script creation REM # 2.00 17/12/2025 added content=metadata_only REM # 3.00 18/12/2025 added log file cleanup, main script log REM ######################################################################################## REM @echo off REM # preparation of log name variable set DATE_TIME=%date:~4,2%-%date:~7,2%-%date:~10,4%_%time:~0,2%-%time:~3,2%-%time:~6,2% set LOG_DATE_TIME=%DATE_TIME: =0% REM # SCRIPT LOG set SCRIPT_LOGFOLDER=I:\Scripts\LOGS set SCRIPT_LOGFILE=%SCRIPT_LOGFOLDER%\TOTSA-FullExpDPBck_%LOG_DATE_TIME%.log set DATAPUMP_PCSBACKUPDIR=I:\OraBackup\Dumps set MAX_LOG_AGE=-7 REM # Database to Backup set ORACLE_SID=PCERP REM # preparation of log name variable set DATE_TIME=%date:~4,2%-%date:~7,2%-%date:~10,4%_%time:~0,2%-%time:~3,2%-%time:~6,2% set LOG_DATE_TIME=%DATE_TIME: =0% echo "######### DATAPORT EXPORT START FOR %ORACLE_SID% #########" >> %SCRIPT_LOGFILE% echo: >> %SCRIPT_LOGFILE% REM # DATAPUMP Metadata set LOGFILE_NAME=PCERP-metadata_%LOG_DATE_TIME%.log H:\app\oracle\19c\db\bin\expdp.exe \"/ as sysdba\" directory=PCSBACKUPDIR dumpfile=PCERP-metadata.dmp logfile=%LOGFILE_NAME% full=y reuse_dumpfiles=y content=metadata_only LOGTIME=all parallel=12 >> %SCRIPT_LOGFILE% echo: >> %SCRIPT_LOGFILE% REM # DATAPUMP FULL set LOGFILE_NAME=PCERP-full_%log_date_time%.log H:\app\oracle\19c\db\bin\expdp.exe \"/ as sysdba\" directory=PCSBACKUPDIR dumpfile=PCERP-full.dmp logfile=%LOGFILE_NAME% full=y reuse_dumpfiles=y EXCLUDE=STATISTICS FLASHBACK_TIME=SYSTIMESTAMP LOGTIME=all parallel=12 >> %SCRIPT_LOGFILE% echo: >> %SCRIPT_LOGFILE% REM # CLEAN UP LOGS OLDER THAN X DAYS echo "==> DATAPUMP LOG CLEANUP OLDER THAN %MAX_LOG_AGE% DAYS" >> %SCRIPT_LOGFILE% forfiles /p %DATAPUMP_PCSBACKUPDIR% /m *.log /d %MAX_LOG_AGE% /c "cmd /c echo deletion of @FILE in %DATAPUMP_PCSBACKUPDIR%" >> %SCRIPT_LOGFILE% forfiles /p %DATAPUMP_PCSBACKUPDIR% /m *.log /d %MAX_LOG_AGE% /c "cmd /c del @FILE" >> %SCRIPT_LOGFILE% echo: >> %SCRIPT_LOGFILE% echo "==> SCRIPT LOG CLEANUP OLDER THAN %MAX_LOG_AGE% DAYS" >> %SCRIPT_LOGFILE% forfiles /p %SCRIPT_LOGFOLDER% /m *.log /d %MAX_LOG_AGE% /c "cmd /c echo deletion of @FILE" >> %SCRIPT_LOGFILE% forfiles /p %SCRIPT_LOGFOLDER% /m *.log /d %MAX_LOG_AGE% /c "cmd /c del @FILE" >> %SCRIPT_LOGFILE% echo: >> %SCRIPT_LOGFILE% echo "######### SCRIPT COMPLETED #########" >> %SCRIPT_LOGFILE%