meta données pour cette page
  •  

Différences

Ci-dessous, les différences entre deux révisions de la page.

Lien vers cette vue comparative

Les deux révisions précédentesRévision précédente
Prochaine révision		Révision précédente
oracle:scripts:expdp_on_windows [17/12/2025 13:30] – mdloracle:scripts:expdp_on_windows [18/12/2025 15:50] (Version actuelle) – mdl
Ligne 1: Ligne 1:
-  * Script permettant de faire un Export Oracle sur windows +  * Script permettant de faire un EXPDP sur windows
 <code BATCH> <code BATCH>
- 
 REM ######################################################################################## REM ########################################################################################
 REM # Script name: TOTSA-FullExpDPBck.bat REM # Script name: TOTSA-FullExpDPBck.bat
 REM # Usage : execute directly, no option needed REM # Usage : execute directly, no option needed
-REM ######+REM ################################################
 REM # Change control REM # Change control
 REM # 1.00 14/12/2025 script creation REM # 1.00 14/12/2025 script creation
-REM # 1.00 17/12/2025 added content=metadata_only+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 ########################################################################################
 +
 +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 REM # Database to Backup
 set ORACLE_SID=PCERP set ORACLE_SID=PCERP
  
 REM # preparation of log name variable 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 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%+set LOG_DATE_TIME=%DATE_TIME: =0%
  
 +
 +echo "######### DATAPORT EXPORT START FOR %ORACLE_SID% #########" >> %SCRIPT_LOGFILE%
 +echo:  >> %SCRIPT_LOGFILE%
  
 REM # DATAPUMP Metadata REM # DATAPUMP Metadata
-set logfile_name=PCERP-metadata_%log_date_time%.log +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+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 REM # DATAPUMP FULL
-set logfile_name=PCERP-full_%log_date_time%.log +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+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%
  
-</code>+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%
 +
 +</code>