hi, We are planning to do a reor 1

[nAtHaNs]

hi,

We are planning to do a reorganization of our data in informix, but as a precautionary measure, we would like to have a reliable backup. So we thought about mirroring our data from hdisk1 to hdisk2. We want to make sure that our data can be read from either disk at any time before we proceed with the db reorganization.

These are the procedures i have done so far:
1. mirrorvg datavg hdisk2
2. chvg -Q n datavg
3. varyoffvg datavg
4. rmdev -l hdisk1 (isolating hdisk1 to test the integrity of the mirrored copy in hdisk2)
5. varyonvg datavg - it says it "0516-056 varyonvg: The volume group is not varied on because a physical volume is marked missing..."

I wonder why can't it varyon the vg when i already have turned quorom off?

How can I isolate (put offline) either of the two disk to test and try if our data can be read from any of them?

Any ideas?

 

[sbix]

Try "varyonvg -f datavg".
Keep in mind you will have 2 copies not synchronized any more.
Probably you should use a splitcopy command

 

[nAtHaNs]

Thanks sbix...that is what i was missing the force option. That is exactly the point, to have a mirrored backup while doing the reorg on the original one...so the lv's should not be synchronized.

 

[sbix]

Yes but how do you think to use the old copy in case of matter?

 

[nAtHaNs]

If something happens to hdisk1 while reorganizing then, I will revert from hdisk2 to hdisk1 to have the last known good copy. happy holidays!

 

[sbix]

I am not sure it will work, the partion copies on hdisk2 will be marked as not sync. (stale)
You should not be able to sync the vg by using the stale partition as "good" ones.
splitcopy does exist for this ....

 

[bi]

Why don't you just create some temporary LVs/filesystems, shut down the database, copy the data to the temp filesystems, bring the database back up, do the reorg, and if you have to revert back to the old version of the database, mount the temp LVs to the mount points of the database?