Online Backup

[sunil]

Dear All,

Pls. if enyone can give me what are the step of Online progress database backup it is grate help for me.
we are using Symix Syteline Erp so we need to take a backup with out shout down the database.

 

[doreynie]

in dynatext viewer

book : Progress Database Administration Guide and Reference

chapter : 7 you'll find every info you need (more in specific : chapter 7.3)

To be short : this is the syntax (but you should read the manual first to make sure everythings alright for your particular situation)

probkup online db-name device-name [ parameters ]

 

[Musgrave]

Here's a section of the script that we use to backup our database, it creates a single file called bkuppackage

# We now check to see if the database is running
# if it's up we do an "online" backup 
# if it's down we do an "offline" backup.
cd /pack
proutil /pack/package -C holder 1>/dev/null
case "$?" in
  16)
    # The database is up on $?=16 so lets backup online.
    BMODE="online"
  ;;
  *)
    # The database is not up so lets backup offline.
    BMODE=""
  ;;
esac
 
# Run the Progress backup (online or offline)
# to create $BDIR/bkuppackage which is the uncompressed backup
# of the database
 
probkup $BMODE /pack/package $BDIR/bkuppackage

Hope this helps.