Ceci est une ancienne révision du document !

---

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%