Paul's OE DBA Blog

I have seen a lot of strange and interesting things over the past 20 years as a Progress OpenEdge DBA. Some of it is funny and some is just...bizarre. I'll try and share some of what I learn right here on my blog.

OUCH! Backup Time Stamp on Windows

OUCH! Backup Time Stamp on Windows

I was called in to consult at a site where the backups were exhibiting strange behaviour. The backup file was the normal 15Gb in size and the time stamp was from last night, but when they restored it in test there was no new data.  In fact, the most recent data they could find was from a couple of weeks ago.

Looking at the DB log file, it didn't take long to ascertain that the backups were actually failing.  On Windows, if the backup file already exists, probkup just writes on top of it without resetting the size to zero. Furthermore, even if no backup ever occurred, probkup still "touched" the file, changing the time stamp.  The result: a full sized backup file with a valid date and time stamp but still the contents from two weeks ago.

What happened?  You probably already guessed.  AI file rotation was not occurring properly so all the AI files were still "Locked". The AI files were locked because replication was active but the replication server was down. Since probkup must change to the next free AI extent it would fail before even starting. 

Never trust the file.  Always check the database log file.  

 

Paul

Download ProTop: The #1 Free OpenEdge DB Monitoring Tool

http://dbappraise.com/protop.html

 

 

 

 

Migrating OpenEdge to Linux is Easier than You Thi...
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Friday, 19 January 2018

Captcha Image