Restore a databse in Progress 10

R

robmar

New Member
Hello all. I am a noob when it comes to progress. Also, I am not a programmer. I have been tasked to get our Progress databases, which run on a Linux platform, away from the off-line backups and try to get them ported over to an on-line back, thereby reducing our down time at night.

I got the off-line backups working OK, at least I think I do. I will include the script that I use, and will take any criticism on that part, and then you can get a feel for what I am trying to accomplish.

I am currently doing a backup on our test server and am trying to restore to the same server. I want to get a feel for the restore utility, prorest. The backups succeed fine and i have the results going into a log that I hope to get emailed to me everyday.

When I try to run the prorest utility it just doesn't seem to do anything. I do a cd to the directory to where prorest resides, /app/psc100Bq/bin, then I run "prorest ffw /dbs/onlinebkup/ffw/webstate" I am trying just to do the ffw database first, as a test. The file created by the backup is located in /dbs/onlinebkup/ffw. This is where I am stuck. I have looked in the Progress DB Admin guide and am trying to follow that.

Below is the backup script I wrote and use to backup.

Sorry for being so long winded, but I wanted to give as full a desciption as I could. Thx in advance for any help.
Rob


[FONT=r_ansi][FONT=r_ansi]## Progress Location[/FONT]
[FONT=r_ansi]DLC=/app/psc91Dq[/FONT]
[FONT=r_ansi]## Database Location[/FONT]
[FONT=r_ansi]CMDB=/dbs/cm[/FONT]
[FONT=r_ansi]IMDB=/dbs/im[/FONT]
[FONT=r_ansi]AMDB=/dbs/am[/FONT]
[FONT=r_ansi]FFWDB=/dbs/ffw[/FONT]
[FONT=r_ansi]PBSDB=/pbs/dbs[/FONT]
[FONT=r_ansi]## Backup File Location[/FONT]
[FONT=r_ansi]BKUP=/dbs/onlinebkup[/FONT]
[FONT=r_ansi]## Log location[/FONT]
[FONT=r_ansi]LOG=/dbs/onlinebkup/logs[/FONT]
[FONT=r_ansi]## Log start time[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/cm.l[/FONT]
[FONT=r_ansi]og[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/cmad[/FONT]
[FONT=r_ansi]dress.log[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/cmgl[/FONT]
[FONT=r_ansi].log[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/cmar[/FONT]
[FONT=r_ansi].log[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/cmtm[/FONT]
[FONT=r_ansi]c.log[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/cmse[/FONT]
[FONT=r_ansi]rvices.log[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/cmco[/FONT]
[FONT=r_ansi]ntext.log[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/am.l[/FONT]
[FONT=r_ansi]og[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/amad[/FONT]
[FONT=r_ansi]dress.log[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/amco[/FONT]
[FONT=r_ansi]ntext.log[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/amhi[/FONT]
[FONT=r_ansi]story.log[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/amse[/FONT]
[FONT=r_ansi]rvices.log[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/im.l[/FONT]
[FONT=r_ansi]og[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/ffww[/FONT]
[FONT=r_ansi]ebstate.log[/FONT]
[FONT=r_ansi]echo "============================ begin full online backup `date`" >> $LOG/pbs.[/FONT]
[FONT=r_ansi]log[/FONT]
[FONT=r_ansi]# Start online full backup of all databases[/FONT]
[FONT=r_ansi]## CM DATABASES[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $CMDB/ar $BKUP/cm/ar >> $LOG/cmar.log &[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $CMDB/cm $BKUP/cm/cm -vs 1000000 < /root/onlinebkup/cm.a[/FONT]
[FONT=r_ansi]nswers >> $LOG/cm.log &[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $CMDB/gl $BKUP/cm/gl -vs 1000000 < /root/onlinebkup/gl.a[/FONT]
[FONT=r_ansi]nswers >> $LOG/cmgl.log &[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $CMDB/cmaddress $BKUP/cm/cmaddress >> $LOG/cmaddress.log[/FONT]
[FONT=r_ansi]&[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $CMDB/context $BKUP/cm/context >> $LOG/cmcontext.log &[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $CMDB/services $BKUP/cm/services >> $LOG/cmservices.log [/FONT]
[FONT=r_ansi]&[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $CMDB/tmc $BKUP/cm/tmc >> $LOG/cmtmc.log &[/FONT]
[FONT=r_ansi]#[/FONT]
[FONT=r_ansi]## IM DATABASE[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $IMDB/im $BKUP/im/im -vs 1000000 < /root/onlinebkup/im.a[/FONT]
[FONT=r_ansi]nswers >> $LOG/im.log &[/FONT]
[FONT=r_ansi]#[/FONT]
[FONT=r_ansi]## AM DATABASES[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $AMDB/am $BKUP/am/am >> $LOG/am.log &[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $AMDB/address $BKUP/am/address >> $LOG/amaddress.log &[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $AMDB/context $BKUP/am/context >> $LOG/amcontext.log &[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $AMDB/history $BKUP/am/history >> $LOG/amhistory.log &[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $AMDB/services $BKUP/am/services >> $LOG/amservices.log [/FONT]
[FONT=r_ansi]&[/FONT]
[FONT=r_ansi]#[/FONT]
[FONT=r_ansi]## iSerivces DATABASE[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $FFWDB/webstate $BKUP/ffw/webstate >>$LOG/ffwwebstate.lo[/FONT]
[FONT=r_ansi]g &[/FONT]
[FONT=r_ansi]#[/FONT]
[FONT=r_ansi]## pbs DATABASE[/FONT]
[FONT=r_ansi]## prorest /pbs/dbs/pbs /dbs/onlinebkup/pbs/pbs is what must be used to do /pbs [/FONT]
[FONT=r_ansi]database.[/FONT]
[FONT=r_ansi]## or $PBSDB/pbs[/FONT]
[FONT=r_ansi]$DLC/bin/probkup online $PBSDB/pbs $BKUP/pbs/pbs >> $LOG/pbs.log &[/FONT]
[FONT=r_ansi]wait[/FONT]
[FONT=r_ansi]## do verify[/FONT]
[FONT=r_ansi]echo "Done with backup, begin -vp verifies, `date`"[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/cm.log[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/cmaddress.lo[/FONT]
[FONT=r_ansi]g[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/cmgl.log[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/cmar.log[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/cmtmc.log[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/cmservices.l[/FONT]
[FONT=r_ansi]og[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/cmcontext.lo[/FONT]
[FONT=r_ansi]g[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/am.log[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/amaddress.lo[/FONT]
[FONT=r_ansi]g[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/amcontext.lo[/FONT]
[FONT=r_ansi]g[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/amhistory.lo[/FONT]
[FONT=r_ansi]g[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/amservices.l[/FONT]
[FONT=r_ansi]og[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/im.log[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/ffwwebstate.[/FONT]
[FONT=r_ansi]log[/FONT]
[FONT=r_ansi]echo "============================ begin -vp verify `date`" >> $LOG/pbs.log[/FONT]
[FONT=r_ansi]# cm DATABASE[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $CMDB/ar $BKUP/cm/ar -vp >> $LOG/cmar.log &[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $CMDB/cm $BKUP/cm/cm -vp < /root/onlinebkup/cm.answers >> $LOG/[/FONT]
[FONT=r_ansi]cm.log &[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $CMDB/gl $BKUP/cm/gl -vp < /root/onlinebkup/gl.answers >> $LOG/[/FONT]
[FONT=r_ansi]cmgl.log &[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $CMDB/cmaddress $BKUP/cm/cmaddress -vp >> $LOG/cmaddress.log &[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $CMDB/context $BKUP/cm/context -vp >> $LOG/cmcontext.log &[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $CMDB/services $BKUP/cm/services -vp >> $LOG/cmservices.log &[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $CMDB/tmc $BKUP/cm/tmc -vp >> $LOG/cmtmc.log &[/FONT]
[FONT=r_ansi]# im DATABASE[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $IMDB/im $BKUP/im/im -vp < /root/onlinebkup/im.answers >> $LOG/[/FONT]
[FONT=r_ansi]im.log &[/FONT]
[FONT=r_ansi]# am DATABASE[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $AMDB/am $BKUP/am/am -vp >> $LOG/am.log &[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $AMDB/address $BKUP/am/address -vp >> $LOG/amaddress.log &[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $AMDB/context $BKUP/am/context -vp >> $LOG/amcontext.log &[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $AMDB/history $BKUP/am/history -vp >> $LOG/amhistory.log &[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $AMDB/services $BKUP/am/services -vp >> $LOG/amservices.log &[/FONT]
[FONT=r_ansi]# iSerivces DATABASE[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $FFWDB/webstate $BKUP/ffw/webstate -vp >>$LOG/ffwwebstate.log &[/FONT]
[FONT=r_ansi]# pbs DATABASE[/FONT]
[FONT=r_ansi]$DLC/bin/prorest $PBSDB/pbs $BKUP/pbs/pbs -vp >> $LOG/pbs.log &[/FONT]
[FONT=r_ansi]wait[/FONT]
[FONT=r_ansi]echo "DONE running onlinebkup.sh `date`"[/FONT]
[/FONT]
 
robmar said:
Hello all. I am a noob when it comes to progress. Also, I am not a programmer. I have been tasked to get our Progress databases, which run on a Linux platform, away from the off-line backups and try to get them ported over to an on-line back, thereby reducing our down time at night.
Click to expand...

That all seems reasonable.

I got the off-line backups working OK, at least I think I do. I will include the script that I use, and will take any criticism on that part, and then you can get a feel for what I am trying to accomplish.
Click to expand...

The scripts seem to be online backup scripts not offline -- you're mixing those terms up a lot which gets confusing.

I am currently doing a backup on our test server and am trying to restore to the same server. I want to get a feel for the restore utility, prorest. The backups succeed fine and i have the results going into a log that I hope to get emailed to me everyday.
Click to expand...

Without seeing the log I don't know if they're working or not. But a backup that you cannot restore isn't exactly "working" ;)

When I try to run the prorest utility it just doesn't seem to do anything. I do a cd to the directory to where prorest resides, /app/psc100Bq/bin, then I run "prorest ffw /dbs/onlinebkup/ffw/webstate" I am trying just to do the ffw database first, as a test. The file created by the backup is located in /dbs/onlinebkup/ffw. This is where I am stuck. I have looked in the Progress DB Admin guide and am trying to follow that.

Below is the backup script I wrote and use to backup.

Sorry for being so long winded, but I wanted to give as full a desciption as I could. Thx in advance for any help.
Rob
Click to expand...

Use CODE tages!!! Like so:
Code: 
## Progress Location
DLC=/app/psc91Dq

This smells like Progress 9.1D. Which is ancient, obsolete and unsupported. Yet the thread title refers to Progress 10. What's going on?

Code: 
## Database Location
CMDB=/dbs/cm
IMDB=/dbs/im
AMDB=/dbs/am
FFWDB=/dbs/ffw
PBSDB=/pbs/dbs

If I were writing this script I would have a general purpose script that accepts the name of the db as an argument rather than repeating the same line with minor differences 5x over and over again... It's easier to read, easier to debug, more robust when something bad happens and far less error-prone.

Code: 
## Backup File Location
BKUP=/dbs/onlinebkup
## Log location
LOG=/dbs/onlinebkup/logs
## Log start time
echo "============================ begin full online backup `date`" >> $LOG/cm.log
...
# Start online full backup of all databases
## CM DATABASES
$DLC/bin/probkup online $CMDB/ar $BKUP/cm/ar >> $LOG/cmar.log &
$DLC/bin/probkup online $CMDB/cm $BKUP/cm/cm -vs 1000000 < /root/onlinebkup/cm.answers >> $LOG/cm.log &

One thing that we probably need to know is what are the contents of "cm.answers" and friends?

An observation -- usually some sort of file extension convention is used to show that a file is a Progress Backup. For instance, I often use .pbk plus the extent number padded with zeros if needed. i.e cm.pbk00 That makes it easy to to identify them unmistakably.

<snip!>
Code: 
...
echo "============================ begin -vp verify `date`" >> $LOG/pbs.log
# cm DATABASE
$DLC/bin/prorest $CMDB/ar $BKUP/cm/ar -vp >> $LOG/cmar.log &

So what does the log say at this point? This looks like it should work.

Code: 
$DLC/bin/prorest $CMDB/cm $BKUP/cm/cm -vp < /root/onlinebkup/cm.answers >> $LOG/cm.log &

This may depend on what is inside the cm.answers file. The restore version seems to be in a different location than the backup version...
 
Hi Tom, thx for the speedy reply. Sorry for mixing up the on-line/off-line, but you're correct. We are doing an off-line currently and I wrote this script to try an on-line. Like I said, I am no programmer. So sorry for the bad coding protocols. I was probably lucky to get as far as I did. I was told we are on Progress 10.0B? And I am referencing the psc100Bq folder which I guess means that's what we have? Not sure if that means anything or not.

I had to use the answer files since the DBs were larger than 2gig, from my reading this was what I had to do.

Here are the answer files for the DBs > 2G.

cm.answers file
[FONT=r_ansi][FONT=r_ansi]/dbs/onlinebkup/cm/cm.bk1[/FONT]
[FONT=r_ansi]/dbs/onlinebkup/cm/cm.bk2[/FONT]
[FONT=r_ansi]/dbs/onlinebkup/cm/cm.bk3[/FONT]
[FONT=r_ansi]/dbs/onlinebkup/cm/cm.bk4[/FONT]
[FONT=r_ansi]/dbs/onlinebkup/cm/cm.bk5[/FONT]
[FONT=r_ansi]/dbs/onlinebkup/cm/cm.bk6[/FONT]
[FONT=r_ansi]/dbs/onlinebkup/cm/cm.bk7[/FONT]
[FONT=r_ansi]/dbs/onlinebkup/cm/cm.bk8[/FONT]

[FONT=r_ansi]gl.answers[/FONT]
[FONT=r_ansi][FONT=r_ansi][FONT=r_ansi]/dbs/onlinebkup/cm/gl.bk2 [/FONT]
[FONT=r_ansi]/dbs/onlinebkup/cm/gl.bk3[/FONT]
[FONT=r_ansi]/dbs/onlinebkup/cm/gl.bk4 [/FONT]
[FONT=r_ansi]/dbs/onlinebkup/cm/gl.bk5[/FONT]

[FONT=r_ansi]im.answers[/FONT]
[FONT=r_ansi][FONT=r_ansi][FONT=r_ansi]/dbs/onlinebkup/im/im.bk2[/FONT]
[FONT=r_ansi]/dbs/onlinebkup/im/im.bk3[/FONT]
[FONT=r_ansi]/dbs/onlinebkup/im/im.bk4[/FONT]
[FONT=r_ansi]/dbs/onlinebkup/im/im.bk5[/FONT]

[FONT=r_ansi]The log that was recorded this morning when it ran (I currently have a cron job set for daily) is below:[/FONT]

[FONT=r_ansi][FONT=r_ansi][FONT=r_ansi]sh-3.00# cat export.log[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]1001421 active blocks out of 1001555 blocks in /dbs/cm/cm will be dumped. (6686)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 7.7 GBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 1002734 db blocks using 7.6 GBytes of media[/FONT]
[FONT=r_ansi]. (9286)[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Backed up 1001677 db blocks in 00:08:15[/FONT]
[FONT=r_ansi]Wrote a total of 29492 backup blocks using 7.7 GBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]============================ begin -vp verify Mon Sep 21 04:10:23 EDT 2009[/FONT]
[FONT=r_ansi]This is a full backup of /dbs/cm/cm.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Started verifying volume 2. (10828)[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Started verifying volume 3. (10828)[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Started verifying volume 4. (10828)[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Started verifying volume 5. (10828)[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Started verifying volume 6. (10828)[/FONT]
[FONT=r_ansi]Verified 1001677 db blocks in 00:03:30[/FONT]
[FONT=r_ansi]Backup for /dbs/cm/cm.db verified ok. (6758)[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]175297 active blocks out of 313107 blocks in /dbs/cm/cmaddress will be dumped. ([/FONT]
[FONT=r_ansi]6686)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 1.3 GBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 175747 db blocks using 1.3 GBytes of media.[/FONT]
[FONT=r_ansi](9286)[/FONT]
[FONT=r_ansi]Backed up 175553 db blocks in 00:03:41[/FONT]
[FONT=r_ansi]Wrote a total of 5144 backup blocks using 1.3 GBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]============================ begin -vp verify Mon Sep 21 04:10:23 EDT 2009[/FONT]
[FONT=r_ansi]This is a full backup of /dbs/cm/cmaddress.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Verified 175553 db blocks in 00:01:33[/FONT]
[FONT=r_ansi]Backup for /dbs/cm/cmaddress.db verified ok. (6758)[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]493709 active blocks out of 493817 blocks in /dbs/cm/gl will be dumped. (6686)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 3.8 GBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 494499 db blocks using 3.8 GBytes of media.[/FONT]
[FONT=r_ansi](9286)[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Backed up 493965 db blocks in 00:06:17[/FONT]
[FONT=r_ansi]Wrote a total of 14544 backup blocks using 3.8 GBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]============================ begin -vp verify Mon Sep 21 04:10:23 EDT 2009[/FONT]
[FONT=r_ansi]This is a full backup of /dbs/cm/gl.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Started verifying volume 2. (10828)[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Started verifying volume 3. (10828)[/FONT]
[FONT=r_ansi]Verified 493965 db blocks in 00:02:41[/FONT]
[FONT=r_ansi]Backup for /dbs/cm/gl.db verified ok. (6758)[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]30220 active blocks out of 128931 blocks in /dbs/cm/ar will be dumped. (6686)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 238.5 MBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 30533 db blocks using 238.1 MBytes of media. [/FONT]
[FONT=r_ansi](9286)[/FONT]
[FONT=r_ansi]Backed up 30476 db blocks in 00:00:41[/FONT]
[FONT=r_ansi]Wrote a total of 898 backup blocks using 238.5 MBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]============================ begin -vp verify Mon Sep 21 04:10:23 EDT 2009[/FONT]
[FONT=r_ansi]This is a full backup of /dbs/cm/ar.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Verified 30476 db blocks in 00:00:19[/FONT]
[FONT=r_ansi]Backup for /dbs/cm/ar.db verified ok. (6758)[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]1295 active blocks out of 128227 blocks in /dbs/cm/tmc will be dumped. (6686)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 12.2 MBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 1565 db blocks using 12.1 MBytes of media. ([/FONT]
[FONT=r_ansi]9286)[/FONT]
[FONT=r_ansi]Backed up 1551 db blocks in 00:00:03[/FONT]
[FONT=r_ansi]Wrote a total of 45 backup blocks using 12.0 MBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]============================ begin -vp verify Mon Sep 21 04:10:23 EDT 2009[/FONT]
[FONT=r_ansi]This is a full backup of /dbs/cm/tmc.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Verified 1551 db blocks in 00:00:02[/FONT]
[FONT=r_ansi]Backup for /dbs/cm/tmc.db verified ok. (6758)[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]52613 active blocks out of 128547 blocks in /dbs/cm/services will be dumped. (66[/FONT]
[FONT=r_ansi]86)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 413.6 MBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 52939 db blocks using 413.0 MBytes of media. [/FONT]
[FONT=r_ansi](9286)[/FONT]
[FONT=r_ansi]Backed up 52869 db blocks in 00:01:21[/FONT]
[FONT=r_ansi]Wrote a total of 1557 backup blocks using 413.6 MBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]============================ begin -vp verify Mon Sep 21 04:10:23 EDT 2009[/FONT]
[FONT=r_ansi]This is a full backup of /dbs/cm/services.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Verified 52869 db blocks in 00:00:34[/FONT]
[FONT=r_ansi]Backup for /dbs/cm/services.db verified ok. (6758)[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]199905 active blocks out of 247535 blocks in /dbs/cm/context will be dumped. (66[/FONT]
[FONT=r_ansi]86)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 1.5 GBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 200397 db blocks using 1.5 GBytes of media.[/FONT]
[FONT=r_ansi](9286)[/FONT]
[FONT=r_ansi]Backed up 200161 db blocks in 00:03:57[/FONT]
[FONT=r_ansi]Wrote a total of 5893 backup blocks using 1.5 GBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]============================ begin -vp verify Mon Sep 21 04:10:23 EDT 2009[/FONT]
[FONT=r_ansi]This is a full backup of /dbs/cm/context.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Verified 200161 db blocks in 00:01:40[/FONT]
[FONT=r_ansi]Backup for /dbs/cm/context.db verified ok. (6758)[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]2949 active blocks out of 2975 blocks in /dbs/am/am will be dumped. (6686)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 25.2 MBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 3231 db blocks using 25.0 MBytes of media. ([/FONT]
[FONT=r_ansi]9286)[/FONT]
[FONT=r_ansi]Backed up 3205 db blocks in 00:00:04[/FONT]
[FONT=r_ansi]Wrote a total of 95 backup blocks using 25.2 MBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]============================ begin -vp verify Mon Sep 21 04:10:23 EDT 2009[/FONT]
[FONT=r_ansi]This is a full backup of /dbs/am/am.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Verified 3205 db blocks in 00:00:03[/FONT]
[FONT=r_ansi]Backup for /dbs/am/am.db verified ok. (6758)[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]1095 active blocks out of 1119 blocks in /dbs/am/address will be dumped. (6686)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 10.6 MBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 1361 db blocks using 10.6 MBytes of media. ([/FONT]
[FONT=r_ansi]9286)[/FONT]
[FONT=r_ansi]Backed up 1351 db blocks in 00:00:02[/FONT]
[FONT=r_ansi]Wrote a total of 40 backup blocks using 10.6 MBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]============================ begin -vp verify Mon Sep 21 04:10:23 EDT 2009[/FONT]
[FONT=r_ansi]This is a full backup of /dbs/am/address.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Verified 1351 db blocks in 00:00:02[/FONT]
[FONT=r_ansi]Backup for /dbs/am/address.db verified ok. (6758)[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]204 active blocks out of 207 blocks in /dbs/am/context will be dumped. (6686)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 3.7 MBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 477 db blocks using 3.6 MBytes of media. (9[/FONT]
[FONT=r_ansi]286)[/FONT]
[FONT=r_ansi]Backed up 460 db blocks in 00:00:02[/FONT]
[FONT=r_ansi]Wrote a total of 14 backup blocks using 3.7 MBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]============================ begin -vp verify Mon Sep 21 04:10:23 EDT 2009[/FONT]
[FONT=r_ansi]This is a full backup of /dbs/am/context.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Verified 460 db blocks in 00:00:01[/FONT]
[FONT=r_ansi]Backup for /dbs/am/context.db verified ok. (6758)[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]211 active blocks out of 223 blocks in /dbs/am/history will be dumped. (6686)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 3.7 MBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 477 db blocks using 3.6 MBytes of media. (9[/FONT]
[FONT=r_ansi]286)[/FONT]
[FONT=r_ansi]Backed up 467 db blocks in 00:00:02[/FONT]
[FONT=r_ansi]Wrote a total of 13 backup blocks using 3.5 MBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]============================ begin -vp verify Mon Sep 21 04:10:23 EDT 2009[/FONT]
[FONT=r_ansi]This is a full backup of /dbs/am/history.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Verified 467 db blocks in 00:00:01[/FONT]
[FONT=r_ansi]Backup for /dbs/am/history.db verified ok. (6758)[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]370 active blocks out of 415 blocks in /dbs/am/services will be dumped. (6686)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 5.1 MBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 647 db blocks using 4.9 MBytes of media. (9[/FONT]
[FONT=r_ansi]286)[/FONT]
[FONT=r_ansi]Backed up 626 db blocks in 00:00:02[/FONT]
[FONT=r_ansi]Wrote a total of 19 backup blocks using 5.0 MBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]============================ begin -vp verify Mon Sep 21 04:10:23 EDT 2009[/FONT]
[FONT=r_ansi]This is a full backup of /dbs/am/services.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Verified 626 db blocks in 00:00:01[/FONT]
[FONT=r_ansi]Backup for /dbs/am/services.db verified ok. (6758)[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]341286 active blocks out of 341326 blocks in /dbs/im/im will be dumped. (6686)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 2.6 GBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 341906 db blocks using 2.6 GBytes of media.[/FONT]
[FONT=r_ansi](9286)[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Backed up 341542 db blocks in 00:05:23[/FONT]
[FONT=r_ansi]Wrote a total of 10056 backup blocks using 2.6 GBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]============================ begin -vp verify Mon Sep 21 04:10:23 EDT 2009[/FONT]
[FONT=r_ansi]This is a full backup of /dbs/im/im.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Please enter next device/file name or type "quit" to exit:[/FONT]
[FONT=r_ansi]Started verifying volume 2. (10828)[/FONT]
[FONT=r_ansi]Verified 341542 db blocks in 00:02:18[/FONT]
[FONT=r_ansi]Backup for /dbs/im/im.db verified ok. (6758)[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]187957 active blocks out of 187967 blocks in /dbs/ffw/webstate will be dumped. ([/FONT]
[FONT=r_ansi]6686)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 1.4 GBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 188429 db blocks using 1.4 GBytes of media.[/FONT]
[FONT=r_ansi](9286)[/FONT]
[FONT=r_ansi]Backed up 188213 db blocks in 00:03:55[/FONT]
[FONT=r_ansi]Wrote a total of 5542 backup blocks using 1.4 GBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]============================ begin -vp verify Mon Sep 21 04:10:23 EDT 2009[/FONT]
[FONT=r_ansi]This is a full backup of /dbs/ffw/webstate.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Verified 188213 db blocks in 00:01:39[/FONT]
[FONT=r_ansi]Backup for /dbs/ffw/webstate.db verified ok. (6758)[/FONT]
[FONT=r_ansi]============================ begin full online backup Mon Sep 21 04:02:07 EDT 20[/FONT]
[FONT=r_ansi]09[/FONT]
[FONT=r_ansi]203 active blocks out of 207 blocks in /pbs/dbs/pbs will be dumped. (6686)[/FONT]
[FONT=r_ansi]256 bi blocks will be dumped. (6688)[/FONT]
[FONT=r_ansi]Backup requires an estimated 3.7 MBytes of media. (9285)[/FONT]
[FONT=r_ansi]Restore would require an estimated 477 db blocks using 3.6 MBytes of media. (9[/FONT]
[FONT=r_ansi]286)[/FONT]
[FONT=r_ansi]Backed up 459 db blocks in 00:00:02[/FONT]
[FONT=r_ansi]Wrote a total of 13 backup blocks using 3.5 MBytes of media. (9284)[/FONT]
[FONT=r_ansi]Backup complete. (3740)[/FONT]
[FONT=r_ansi]This is a full backup of /pbs/dbs/pbs.db. (6759)[/FONT]
[FONT=r_ansi]This backup was taken Mon Sep 21 04:02:07 2009. (6760)[/FONT]
[FONT=r_ansi]The blocksize is 8192. (6994)[/FONT]
[FONT=r_ansi]Partial verification successfully read backup volume. (6765)[/FONT]
[FONT=r_ansi]Verify pass started. (3751)[/FONT]
[FONT=r_ansi]Verified 459 db blocks in 00:00:01[/FONT]
[FONT=r_ansi]Backup for /pbs/dbs/pbs.db verified ok. (6758)[/FONT]


[FONT=r_ansi]Again, apologies for poor coding, but it is something that I almost never do. As I get more involved with this I can hopefully pick up on the coding and such. Thanks for taking your time to answer.[/FONT]

Rob
[/FONT][/FONT][/FONT][/FONT][/FONT][/FONT][/FONT]
 
Those log files look like everything is working.

So I'm not sure what the problem is. Is there a problem? Or is it just that it sits there for a long time without any feedback while it's doing this? If the later then it is just a side-effect of redirecting all of your output in the scripts.
 
Thx again for replies Tom. I am OK with the backup part now. I am running a script to do the restore. Here is what I am running and what I am getting. It is telling me the database is in multiuser mode. I dont recall seeing anything in the documentation about what mode the DB had to be in to do an online restore. FYI, I pared down the restore script to try and just get one database restored, instead of doing all of them. I can add the coded for the others back in when I get the mechanics of this script working. That is why this is significantly shorter than my original backup script.

Script that I run to try and do an online restore:

#!/bin/sh
echo "begin running restore.sh (restore) `date`"
. /pbs/config/cm
## Progress Location
DLC=/app/psc100Bq
## Database Location
CMDB=/dbs/cm
## Backup File Location
BKUP=/dbs/onlinebkup
## Log location
LOG=/dbs/onlinebkup/logs/restorelogs
## Log start time
echo "============================ begin restore `date`" > $LOG/cmarrestore.log

# cm DATABASE
$DLC/bin/prorest $CMDB/ar $BKUP/cm/ar.pbk -vp >> $LOG/cmarrestore.log &
wait
$DLC/bin/prorest $CMDB/ar $BKUP/cm/ar.pbk >> $LOG/cmarrestore.log &
wait

The log that is created after running the script:

============================ begin restore Mon Sep 28 11:54:07 EDT 2009
This is a full backup of /dbs/cm/ar.db. (6759)
This backup was taken Mon Sep 28 10:53:35 2009. (6760)
The blocksize is 8192. (6994)
Partial verification successfully read backup volume. (6765)
Verify pass started. (3751)
Verified 30476 db blocks in 00:00:01
Backup for /dbs/cm/ar.db verified ok. (6758)
** The database /dbs/cm/ar is in use in multi-user mode. (276)
!!! ERROR - Database restore utility FAILED !!! (8564)
 
There are online backups, but no on-line restore ... makes my head hurt just to think about the implications. Stop the server and try the restore. Of course, were it I, I would try the restore into a new location first, just in case something went wrong.
 
Bah, I got so wrapped up in trying to get this to work I never gave that a thought. :o Forest for the trees thing I guess. Thx
 
You must log in or register to reply here.
Back
Top