sharikaganju
New Member
Hello All,
We have a script for our QAD production database backup called prod.bkup. And this is what it does -
#!/bin/sh
DLC=/progress/oe101c;export DLC
PATH=$PATH:$DLC;export PATH
PROMSGS=$DLC/promsgs;export PROMSGS
PROTERMCAP=$DLC/protermcap;export PROTERMCAP
# PASS IN $1 as blank or "online" to do an online backup
type=$1
$DLC/bin/probkup $type /qad/qaddb/mfgprod /qad/qaddb/mfgprod.bkp
$DLC/bin/probkup $type /qad/qaddb/admprod /qad/qaddb/admprod.bkp
$DLC/bin/probkup $type /qad/qaddb/hlpprod /qad/qaddb/hlpprod.bkp
So we run it using prod.bkup online.
I need to create another script which would run this script automatically and also copy the QAD backup files from the /qad/qaddb folder to the SAN. I have the IP address of the SAN.
How do I do this ? I might have to use sftp but I dont know how to automate all this process in a script. Also what files should I move from /qad/qaddb to SAN, would it be mfgprod.bkp, admprod.bkp and hlpprod.bkp ? Do I also need to transfer any bi files ? How do I identify them ? The backup is being done for restore purpose in case there is a database crash, so I need to know what all files do I copy to SAN so that we could restore from them.
Thanks in advance.
We have a script for our QAD production database backup called prod.bkup. And this is what it does -
#!/bin/sh
DLC=/progress/oe101c;export DLC
PATH=$PATH:$DLC;export PATH
PROMSGS=$DLC/promsgs;export PROMSGS
PROTERMCAP=$DLC/protermcap;export PROTERMCAP
# PASS IN $1 as blank or "online" to do an online backup
type=$1
$DLC/bin/probkup $type /qad/qaddb/mfgprod /qad/qaddb/mfgprod.bkp
$DLC/bin/probkup $type /qad/qaddb/admprod /qad/qaddb/admprod.bkp
$DLC/bin/probkup $type /qad/qaddb/hlpprod /qad/qaddb/hlpprod.bkp
So we run it using prod.bkup online.
I need to create another script which would run this script automatically and also copy the QAD backup files from the /qad/qaddb folder to the SAN. I have the IP address of the SAN.
How do I do this ? I might have to use sftp but I dont know how to automate all this process in a script. Also what files should I move from /qad/qaddb to SAN, would it be mfgprod.bkp, admprod.bkp and hlpprod.bkp ? Do I also need to transfer any bi files ? How do I identify them ? The backup is being done for restore purpose in case there is a database crash, so I need to know what all files do I copy to SAN so that we could restore from them.
Thanks in advance.