Saturday, 18 January 2025

Script to take backup of multiple schema using shell script

 $crontab -l

00 04 * * * /ora/app/oracle/refresh/expdp_testdb_SIT.sh 1>/dev/null 2>&1


Script

cat /ora/app/oracle/refresh/expdp_testdb_SIT.sh
#!/bin/sh
export ORACLE_SID=testdb1
export ORACLE_HOME=/u01/app/oracle/product/12.2.0.1/test-db
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/lib:/usr/ccs/bin:$ORACLE_HOME/OPatch
DATEFORMAT=`date +%Y%m%d`

# Data Pump export
expdp \"/ as sysdba\" directory=OBACKUP dumpfile=expdp_SIT_`echo $DATEFORMAT`.dmp logfile=expdp_SIT_`echo $DATEFORMAT`.log schemas=ACS,AU,EPG,FP,FRAUD,MAIN,SMSGATE,SSO,SVAB,SVCG,SVCGUP,SVCM,SVIP,SVISTA,SVMP,SVMP_IG,SVRB,SVWEB,SVWFE,WEBGATE parallel=8 cluster=n flashback_time=systimestamp

No comments:

Post a Comment