Slowness during backup

G

gmalaspina

New Member
Hi friends,

I have got an issue in Progress 9.1D - Solaris 64bit platform:

we perform 5 different backup during the day with probkp utility, but when a incremental backup start, for some minute the db seems frozen.

I found out in the database log these messages:

...
10:00:22 BACKUP 21: Switched to ai extent /ai/res518/ttgres.a5. (3777)
10:00:22 BACKUP 21: This is after-image file number 80 since the last AIMAGE BEGIN (3778)
10:00:23 BACKUP 21: Begin backup of Before Image file(s). (5459)
...
10:03:35 BACKUP 21: End backup of Before Image file(s). (5460)
10:03:35 BACKUP 21: Begin backup of Data file(s). (5461)
...

The database seems frozen exactly beeween 10:00 and 10:03...
Is it a "normal" this situation?

TIA,
G.

 
Hi,

message 5459:
The online backup utility has started backing up the Before Image files. During this time no updates can be made to the database. Once the Before Image files have been backed up, database update activity will resume automatically.

also KBP40524:
Status: Verified
SYMPTOM(s):
Database freezes for a period of time during online backup?
Probkup pauses during online backup and users can't work.
CAUSE:
This is expected behavior. Write operations are suspended against the
database while the probkup process performs the backup of the before
image file(s). After the successful backup of the bi file(s), the
users are then allowed to continue working while the backup proceeds
to backup the database data files.
FIX:
The probkup process pauses the database while it backs up the database
Before Image (bi) file.
Click to expand...

Although I must admit that 3 minutes is a pretty long time. Do you have a biw started?

Regards,

Casper


 
You must log in or register to reply here.
Back
Top