Tuesday, July 17, 2018

Dump Backup Script

#!/bin/bash
vdate=nblt24ac_`date '+%d%m%Y%H%M'`
v1=01
v2=02
v3=03
v4=04
v5=05
v6=06
v7=07
v8=08
v9=09
v10=10
v11=11
v12=12
v13=13
v14=14
v15=15
v16=16
expdp t24backup/t24backup DIRECTORY=dir_n1 dumpfile=$vdate%U.dmp logfile=$vdate.log schemas=nblt24 parallel=16 compression=all EXCLUDE=STATISTICS CLUSTER=N metrics=y
gzip /db_dump/soft/$vdate$v1.dmp
gzip /db_dump/soft/$vdate$v2.dmp
gzip /db_dump/soft/$vdate$v3.dmp
gzip /db_dump/soft/$vdate$v4.dmp
gzip /db_dump/soft/$vdate$v5.dmp
gzip /db_dump/soft/$vdate$v6.dmp
gzip /db_dump/soft/$vdate$v7.dmp
gzip /db_dump/soft/$vdate$v8.dmp
gzip /db_dump/soft/$vdate$v9.dmp
gzip /db_dump/soft/$vdate$v10.dmp
gzip /db_dump/soft/$vdate$v11.dmp
gzip /db_dump/soft/$vdate$v12.dmp
gzip /db_dump/soft/$vdate$v13.dmp
gzip /db_dump/soft/$vdate$v14.dmp
gzip /db_dump/soft/$vdate$v15.dmp
gzip /db_dump/soft/$vdate$v16.dmp
#scp /db_dump/soft/$vdate* oracle@172.31.10.6:/dump_backup/

No comments:

Post a Comment