Question Is my backup plan any good?

[vinhng]

Hello all,
I am facing problems about Progress DB issue

My customer has 2 servers: 1 for App server(linux), 1 for DB server(linux). They use 2 DBs Progress (live and test Database) on the same local server (DB server).

I use crontab to backup live DB everyday (afterwork) and restore the test DB from live DB at 3:00AM everyday.



I do probakup online the Live DB first
I do procopy test DB from live DB by Progress Tool.
I think the admin* and help* does not change that I use procopy tool to copy mfg* only.

Does I think the plan backup and restore DB is right?Pls give me any idea expert from you all.

Below is my script
Thanks,


#==================================================
#PROCOPY DB DBprod PROD to DBprod TEST
#Script automatically for DBprod Customer
#==================================================
#ENVIROMENT STATUS

DLC=/u01/qad;export DLC
. $DLC/bin/slib_env
PATH=$PATH:$DLC/bin;export PATH

#==================================================
#DEFINED DBprod DB, ADMIN DB and HELP DB

DBNAME1=mfgDBprod
DBNAME2=admDBprod
DBNAME3=hlpDBprod

#==================================================
#DEFINED DBprod-TEST DB, ADMIN DB and HELP DB

DBNAME4=mfgDBprod-test
DBNAME5=admDBprod-test
DBNAME6=hlpDBprod-test

#==================================================
#BACKUP DIR and BACKUP LOGS PROPATH

DBDIR1=/u01/mfgpro/mfgsvr/dataDBprod/DBprod
DBDIR2=/u01/mfgpro/mfgsvr/dataDBprod/DBprod-test

#==================================================
#ProCopy DB by PROGRESS TOOL
cd /u01/mfgpro/mfgsvr/dataDBprod/DBprod-test
$DLC/bin/prodel $DBDIR2/$DBNAME4 </yes.txt>
#$DLC/bin/prodel $DBDIR2/$DBNAME5 </yes.txt> (Do not need to delete)
#$DLC/bin/prodel $DBDIR2/$DBNAME6 </yes.txt> (Do not need to delete)

$DLC/bin/procopy $DBDIR1/$DBNAME1 $DBDIR2/$DBNAME4
#$DLC/bin/procopy $DBDIR1/$DBNAME2 $DBDIR2/$DBNAME5 (Do not need to copy)
#$DLC/bin/procopy $DBDIR1/$DBNAME3 $DBDIR2/$DBNAME6 (Do not need to copy)

#==================================================

 

[vinhng]

Hello, I am still waiting for any commend ? anyone can give your expert advices?

Thanks

 

[TomBascom]

Your "backup" appears to be very confused and unlikely to work reliably.

Procopy is not a suitable method to backup. And prodel should not be part of a backup process.

You should read about the "probkup" and "prorest" commands.