How to Fix DCM Allocation Error

Below is one of the  form of DCM allocation error :

Page (1:117), object ID 677577452, index ID 0 has been modified but is not marked modified in the differential backup bitmap.

This error has the same as GAM / SGAM allocation error. Lets check allocation status of that page :

Allocation Status
—————–
GAM (1:2) = ALLOCATED     SGAM (1:3) = ALLOCATED   
PFS (1:1) = 0x70 IAM_PG MIXED_EXT ALLOCATED   0_PCT_FULL
DIFF (1:6) = NOT CHANGED  ML (1:7) = NOT MIN_LOGGED

Please note that DCM bit at this page (in this sample, page 117), is not marked as changed.

If I ignore this error and continue operating the database, this page will never be backed up unless there are subsequent changes on that page.

So, to restore the consistency, I should change the DCM bit for that page as changed. After performing the operation, the error is gone.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: