Mboxlist DB Snapshot Rotation And Upgrade From 8.0.1 To 8.0.2 (Doc ID 2341032.1)

Last updated on AUGUST 20, 2019

Applies to:

Goal

If there is a problem with upgrading to MS 8.0.2 and we have to go back to 8.0.1, it is understood --per Doc ID 2323981.1-- that the following steps should be followed:

• stop Messaging
• run stored -r
• remove the db log files

Then perform the downgrade. And after that, start stored and there should be no problem.

However, if there is a problem db, stored will try to use the snapshots.

The trouble is, all the snapshots are the same.

The 02:00 imdbverify updates all the snapshots to be the same.
Then the every-10-minutes imdbverify updates the copy in the 001 directory.

After 02:00 the next morning, none of the snapshots will be usable if a down grade is necessary.

As a precaution, a backup could be taken of the 002 or 003 snapshot before the upgrade.

Or the following procedure can be used which is planned for the first one:

* stop-msg
* stored -r
* backup the mboxlist
* then upgrade

It is preferred to avoid having to do that on all of them. Once the first one is patched and no problems are found, then just patch as normal.
But the patching will be performed late at night. The 02:00 imdbverify will update the snapshots. So by the next day, when problems could potentially be found, the snapshots will already be gone. If a downgrade is needed and if stored -r and removing the logs was not sufficient (or someone forgot to do it), we would start with an empty mboxlist and have to reconstruct 25,000 accounts -- around 150TB -- which would take forever.

It is not expected to have to go backwards.
It is not expected that stored -r and removing the logs would be insufficient (or someone will forget to do it).

But if a problem is found and a downgrade is needed, it would cause panic. A massive reconstruct (or autorepair storm) would be bad.

Q1:  We would like confirmation and a recommendation to either:

Yes, do the same thing with every upgrade

or

Perhaps save one of the 02:00 snapshot copies. That would be about 20 hours out of date when it is captured--more like 2 days out of day if it had to be restored, but that would be infinitely better than starting with an empty mboxlist.

Q2:  What is the possibility for it to go back to the previous behavior where snapshotdirs = 3 means you have 2 days of backups, not 2 copies of the same thing from 02:00 this morning (what is the point of that)?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.