• Script permettant de faire un EXPDP sur windows

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%