replace Primary dbspace with its mirror.

Hello dears, I initiated a mirror for one of my important dbspaces. The Original one produces an error in page from week to another. So, I created a mirror from it and I want to replace the Primary dbspace with its Mirror to get rid from the original one. Can I? , or I have to put the primary down and then delete its file , retouch it , recover it from its mirror, and then stop mirroring. Please reply. Regards, Marwan. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This e-mail (including attachments) is classified as Mediterranean Smart Cards Company confidential and proprietary information The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, and information) and not to disclose to any third party without the prior written consent of Mediterranean Smart Cards Company. Recipient will be held liable for any unauthorized disclosure. It is intended solely for the addressee. Unless you are the addressee, you may not read, copy, use or store this e-mail in any way, or permit others to. If you have received it in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Actually what you want to do is shutdown, switch the symbolic links betweent the primary and back up chunks so that the engine thinks the old primary is now the secondary. Then restart and drop the mirror using the mirror link which is now pointing to the old primary. Art S. Kagel ----- Original Message ----- From: Mohamed Marwan <ids@iiug.org> At: 3/01 9:05:12 Hello dears, I initiated a mirror for one of my important dbspaces. The Original one produces an error in page from week to another. So, I created a mirror from it and I want to replace the Primary dbspace with its Mirror to get rid from the original one. Can I? , or I have to put the primary down and then delete its file , retouch it , recover it from its mirror, and then stop mirroring. Please reply. Regards, Marwan. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This e-mail (including attachments) is classified as Mediterranean Smart Cards Company confidential and proprietary information The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, and information) and not to disclose to any third party without the prior written consent of Mediterranean Smart Cards Company. Recipient will be held liable for any unauthorized disclosure. It is intended solely for the addressee. Unless you are the addressee, you may not read, copy, use or store this e-mail in any way, or permit others to. If you have received it in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Note, if the error was a soft error, ie damaged data rather than a hardware problem with the drive, the bad data will have been replicated exactly on the mirror. Art S. Kagel ----- Original Message ----- From: Mohamed Marwan <ids@iiug.org> At: 3/01 9:05:12 Hello dears, I initiated a mirror for one of my important dbspaces. The Original one produces an error in page from week to another. So, I created a mirror from it and I want to replace the Primary dbspace with its Mirror to get rid from the original one. Can I? , or I have to put the primary down and then delete its file , retouch it , recover it from its mirror, and then stop mirroring. Please reply. Regards, Marwan. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This e-mail (including attachments) is classified as Mediterranean Smart Cards Company confidential and proprietary information The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, and information) and not to disclose to any third party without the prior written consent of Mediterranean Smart Cards Company. Recipient will be held liable for any unauthorized disclosure. It is intended solely for the addressee. Unless you are the addressee, you may not read, copy, use or store this e-mail in any way, or permit others to. If you have received it in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Once a month I get next error. ---------------- 07:18:54 Assert Failed: Page Check Error in phposition:isposition:bad page 07:18:54 IBM Informix Dynamic Server Version 9.40.UC3 07:18:54 Who: Session(17727, online@nodea, 7433, 0x87147360) Thread(20563, sqlexec, 87135da8, 1) File: rsdebug.c Line: 1044 07:18:54 Results: Possible inconsistencies in 'online:"online".groups' 07:18:54 Action: Run 'oncheck -cDI online:"online".groups' 07:18:54 stack trace for pid 1874 written to /tmp/af.543b385e 07:18:54 See Also: /tmp/af.543b385e, shmem.543b385e.0 07:19:55 Page Check Error in phposition:isposition:bad page ---------------- Oncheck couldn't be applied, asking me to drop and rebuild the indexes of this table. But I can't drop the index, so I make a full backup and restore to overcome this problem. It works for two or three weeks and error come again. I exported the table and imported it with no progress. I applied mirroring on the mentioned dbspace and trying to replace the original one with its mirror. That's exactly what I'm trying to do. Please advise. Regards, Mohammad Marwan. Databases and Unix section head Mediterranean Smart Cards Company 92 Eltahrir st., Dokki, Cairo, Egypt. Tel: +20(2) 3331457 Mobile: +2 0122449825 Mail: mmarwan@mscc.com.eg www.mscc.com.eg -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ART KAGEL, BLOOMBERG/ 731 LEXIN Sent: Thursday, March 01, 2007 4:14 PM To: ids@iiug.org Subject: Re: replace Primary dbspace with its mirror. [8548] Note, if the error was a soft error, ie damaged data rather than a hardware problem with the drive, the bad data will have been replicated exactly on the mirror. Art S. Kagel ----- Original Message ----- From: Mohamed Marwan <ids@iiug.org> At: 3/01 9:05:12 Hello dears, I initiated a mirror for one of my important dbspaces. The Original one produces an error in page from week to another. So, I created a mirror from it and I want to replace the Primary dbspace with its Mirror to get rid from the original one. Can I? , or I have to put the primary down and then delete its file , retouch it , recover it from its mirror, and then stop mirroring. Please reply. Regards, Marwan. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This e-mail (including attachments) is classified as Mediterranean Smart Cards Company confidential and proprietary information The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, and information) and not to disclose to any third party without the prior written consent of Mediterranean Smart Cards Company. Recipient will be held liable for any unauthorized disclosure. It is intended solely for the addressee. Unless you are the addressee, you may not read, copy, use or store this e-mail in any way, or permit others to. If you have received it in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

Yes, looks like the current primary drive is going south quickly. Do the chunk swap with the mirror and get rid of that spindle. Then I recommend onchecking the indexes again and if they are bad, you'll just have to rebuild them. Why do you say you cannot drop the indexes? Dropping and recreating the index that's damaged is probably faster then performing the restore. Art S. Kagel ----- Original Message ----- From: Mohamed Marwan <ids@iiug.org> At: 3/01 9:29:05 Once a month I get next error. ---------------- 07:18:54 Assert Failed: Page Check Error in phposition:isposition:bad page 07:18:54 IBM Informix Dynamic Server Version 9.40.UC3 07:18:54 Who: Session(17727, online@nodea, 7433, 0x87147360) Thread(20563, sqlexec, 87135da8, 1) File: rsdebug.c Line: 1044 07:18:54 Results: Possible inconsistencies in 'online:"online".groups' 07:18:54 Action: Run 'oncheck -cDI online:"online".groups' 07:18:54 stack trace for pid 1874 written to /tmp/af.543b385e 07:18:54 See Also: /tmp/af.543b385e, shmem.543b385e.0 07:19:55 Page Check Error in phposition:isposition:bad page ---------------- Oncheck couldn't be applied, asking me to drop and rebuild the indexes of this table. But I can't drop the index, so I make a full backup and restore to overcome this problem. It works for two or three weeks and error come again. I exported the table and imported it with no progress. I applied mirroring on the mentioned dbspace and trying to replace the original one with its mirror. That's exactly what I'm trying to do. Please advise. Regards, Mohammad Marwan. Databases and Unix section head Mediterranean Smart Cards Company 92 Eltahrir st., Dokki, Cairo, Egypt. Tel: +20(2) 3331457 Mobile: +2 0122449825 Mail: mmarwan@mscc.com.eg www.mscc.com.eg -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ART KAGEL, BLOOMBERG/ 731 LEXIN Sent: Thursday, March 01, 2007 4:14 PM To: ids@iiug.org Subject: Re: replace Primary dbspace with its mirror. [8548] Note, if the error was a soft error, ie damaged data rather than a hardware problem with the drive, the bad data will have been replicated exactly on the mirror. Art S. Kagel ----- Original Message ----- From: Mohamed Marwan <ids@iiug.org> At: 3/01 9:05:12 Hello dears, I initiated a mirror for one of my important dbspaces. The Original one produces an error in page from week to another. So, I created a mirror from it and I want to replace the Primary dbspace with its Mirror to get rid from the original one. Can I? , or I have to put the primary down and then delete its file , retouch it , recover it from its mirror, and then stop mirroring. Please reply. Regards, Marwan. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This e-mail (including attachments) is classified as Mediterranean Smart Cards Company confidential and proprietary information The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, and information) and not to disclose to any third party without the prior written consent of Mediterranean Smart Cards Company. Recipient will be held liable for any unauthorized disclosure. It is intended solely for the addressee. Unless you are the addressee, you may not read, copy, use or store this e-mail in any way, or permit others to. If you have received it in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Take the server down, switch the links over and bring the server bank, that will get the engine running on the old mirror as the primary. Then you can turn off mirroring. Of course if you are not using links then you will burn in the pit of hell :-) Paul Watson Tel: +44 1414161772 +1 913-400-2620 Mob: +44 7818003457 +1 913-636-2858 Web: www.oninit.com Failure is not as frightening as regret. Attend IDUG 2007 San Jose, North America May 6-10, 2007 Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On > Behalf Of Mohamed Marwan > Sent: 01 March 2007 08:05 > To: ids@iiug.org > Subject: replace Primary dbspace with its mirror. [8546] > > Hello dears, > > I initiated a mirror for one of my important dbspaces. > > The Original one produces an error in page from week to another. > > So, I created a mirror from it and I want to replace the > Primary dbspace with its Mirror to get rid from the original one. > > Can I? , or I have to put the primary down and then delete > its file , retouch it , recover it from its mirror, and then > stop mirroring. > > Please reply. > > Regards, > > Marwan. > > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * > * * * * * * * * > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * > * * * * * * * * > * * * * * * * * * * * * * * * * * * * * * * * * * This e-mail > (including attachments) is classified as Mediterranean Smart > Cards Company confidential and proprietary information The > recipient hereby is committed to hold in strict confidence > the contents of this (e-mail, document, and information) and > not to disclose to any third party without the prior written > consent of Mediterranean Smart Cards Company. > Recipient will be held liable for any unauthorized disclosure. > It is intended solely for the addressee. Unless you are the > addressee, you may not read, copy, use or store this e-mail > in any way, or permit others to. > If you have received it in error, please notify the sender by > return e-mail and delete the message in its entirety, > including any attachments > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * > * * * * * * * * > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * > * * * * * * * * > * * * * * * * * * * * * * * * * * * * * * * * * * > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the > discussion forum.

Many thanks, I successfully did it. I hope this will cure my database. Regards, Mohammad Marwan. Databases and Unix section head Mediterranean Smart Cards Company 92 Eltahrir st., Dokki, Cairo, Egypt. Tel: +20(2) 3331457 Mobile: +2 0122449825 Mail: mmarwan@mscc.com.eg www.mscc.com.eg -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ART KAGEL, BLOOMBERG/ 731 LEXIN Sent: Thursday, March 01, 2007 4:45 PM To: ids@iiug.org Subject: RE: replace Primary dbspace with its mirror. [8550] Yes, looks like the current primary drive is going south quickly. Do the chunk swap with the mirror and get rid of that spindle. Then I recommend onchecking the indexes again and if they are bad, you'll just have to rebuild them. Why do you say you cannot drop the indexes? Dropping and recreating the index that's damaged is probably faster then performing the restore. Art S. Kagel ----- Original Message ----- From: Mohamed Marwan <ids@iiug.org> At: 3/01 9:29:05 Once a month I get next error. ---------------- 07:18:54 Assert Failed: Page Check Error in phposition:isposition:bad page 07:18:54 IBM Informix Dynamic Server Version 9.40.UC3 07:18:54 Who: Session(17727, online@nodea, 7433, 0x87147360) Thread(20563, sqlexec, 87135da8, 1) File: rsdebug.c Line: 1044 07:18:54 Results: Possible inconsistencies in 'online:"online".groups' 07:18:54 Action: Run 'oncheck -cDI online:"online".groups' 07:18:54 stack trace for pid 1874 written to /tmp/af.543b385e 07:18:54 See Also: /tmp/af.543b385e, shmem.543b385e.0 07:19:55 Page Check Error in phposition:isposition:bad page ---------------- Oncheck couldn't be applied, asking me to drop and rebuild the indexes of this table. But I can't drop the index, so I make a full backup and restore to overcome this problem. It works for two or three weeks and error come again. I exported the table and imported it with no progress. I applied mirroring on the mentioned dbspace and trying to replace the original one with its mirror. That's exactly what I'm trying to do. Please advise. Regards, Mohammad Marwan. Databases and Unix section head Mediterranean Smart Cards Company 92 Eltahrir st., Dokki, Cairo, Egypt. Tel: +20(2) 3331457 Mobile: +2 0122449825 Mail: mmarwan@mscc.com.eg www.mscc.com.eg -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of ART KAGEL, BLOOMBERG/ 731 LEXIN Sent: Thursday, March 01, 2007 4:14 PM To: ids@iiug.org Subject: Re: replace Primary dbspace with its mirror. [8548] Note, if the error was a soft error, ie damaged data rather than a hardware problem with the drive, the bad data will have been replicated exactly on the mirror. Art S. Kagel ----- Original Message ----- From: Mohamed Marwan <ids@iiug.org> At: 3/01 9:05:12 Hello dears, I initiated a mirror for one of my important dbspaces. The Original one produces an error in page from week to another. So, I created a mirror from it and I want to replace the Primary dbspace with its Mirror to get rid from the original one. Can I? , or I have to put the primary down and then delete its file , retouch it , recover it from its mirror, and then stop mirroring. Please reply. Regards, Marwan. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This e-mail (including attachments) is classified as Mediterranean Smart Cards Company confidential and proprietary information The recipient hereby is committed to hold in strict confidence the contents of this (e-mail, document, and information) and not to disclose to any third party without the prior written consent of Mediterranean Smart Cards Company. Recipient will be held liable for any unauthorized disclosure. It is intended solely for the addressee. Unless you are the addressee, you may not read, copy, use or store this e-mail in any way, or permit others to. If you have received it in error, please notify the sender by return e-mail and delete the message in its entirety, including any attachments * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.

That's exactly what I have successfully done. Thank you all for your care. Regards, Mohammad Marwan. Databases and Unix section head Mediterranean Smart Cards Company 92 Eltahrir st., Dokki, Cairo, Egypt. Tel: +20(2) 3331457 Mobile: +2 0122449825 Mail: mmarwan@mscc.com.eg www.mscc.com.eg -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Paul Watson Sent: Thursday, March 01, 2007 5:26 PM To: ids@iiug.org Subject: RE: replace Primary dbspace with its mirror. [8551] Take the server down, switch the links over and bring the server bank, that will get the engine running on the old mirror as the primary. Then you can turn off mirroring. Of course if you are not using links then you will burn in the pit of hell :-) Paul Watson Tel: +44 1414161772 +1 913-400-2620 Mob: +44 7818003457 +1 913-636-2858 Web: www.oninit.com Failure is not as frightening as regret. Attend IDUG 2007 San Jose, North America May 6-10, 2007 Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On > Behalf Of Mohamed Marwan > Sent: 01 March 2007 08:05 > To: ids@iiug.org > Subject: replace Primary dbspace with its mirror. [8546] > > Hello dears, > > I initiated a mirror for one of my important dbspaces. > > The Original one produces an error in page from week to another. > > So, I created a mirror from it and I want to replace the > Primary dbspace with its Mirror to get rid from the original one. > > Can I? , or I have to put the primary down and then delete > its file , retouch it , recover it from its mirror, and then > stop mirroring. > > Please reply. > > Regards, > > Marwan. > > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * > * * * * * * * * > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * > * * * * * * * * > * * * * * * * * * * * * * * * * * * * * * * * * * This e-mail > (including attachments) is classified as Mediterranean Smart > Cards Company confidential and proprietary information The > recipient hereby is committed to hold in strict confidence > the contents of this (e-mail, document, and information) and > not to disclose to any third party without the prior written > consent of Mediterranean Smart Cards Company. > Recipient will be held liable for any unauthorized disclosure. > It is intended solely for the addressee. Unless you are the > addressee, you may not read, copy, use or store this e-mail > in any way, or permit others to. > If you have received it in error, please notify the sender by > return e-mail and delete the message in its entirety, > including any attachments > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * > * * * * * * * * > * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * > * * * * * * * * > * * * * * * * * * * * * * * * * * * * * * * * * * > > > ************************************************************** > ***************** > Forum Note: Use "Reply" to post a response in the > discussion forum. ************************************************************************ ******* Forum Note: Use "Reply" to post a response in the discussion forum.