Re: On-Archive Setup...

Yuri- Thanks a lot..!! Have you ever restore from the OnArchive tape.. I tried taking the Archive backup in tape (two dbspaces only). It went properly. Again I tried to restore it. This is also fine. I got the message like "Physical Restore of pstable_test75, psindex_test75 started. Checkpoint Completed: duration was 0 seconds. Checkpoint Completed: duration was 0 seconds. Checkpoint Completed: duration was 1 seconds. Physical Restore of pstable_test75, psindex_test75 Completed." I have one database in one dbspace(pstable_test75). The indexes are in a different dbspace (psindex_test75). The database name is test75. While I tried to use this Database Test75 I got an error message like this. " 311: Cannot open system catalog (systables). 155: ISAM error: Primary and Mirror chunks are bad " What could be the reason.. Any idea.. Thank you Santanu From: "Yuri Dovgart" <y_dovgart@tci.ukrtel.net> Reply-To: "Yuri Dovgart" <y_dovgart@tci.ukrtel.net> To: informix-list@iiug.org Subject: Re: On-Archive Setup... Date: Fri, 15 Oct 1999 09:33:35 +0300 Santanu Das <sanformix@hotmail.com> wrote in message news:7u54s1$k81$1@news.xmission.com... > > Hi all, > > Could somebody help me in setting up the On-Archive tool. If you have a > installation/setup guide for using On-Archive then this will help me. > > I have IDS 7.3 running on HP Box. 1.First of all, you need to define your device types in $INFORMIXDIR/etc/config.arc. If you want to use tape define this as TAPE = /dev/rmt0h 2.Then you must go to On-Archive (I'm using menu interface, it seems to me much easy then command ). 3.First of all, you create vset with your device type. Vset is logical grouping of volumes. 4.Then specify volumes for this vset. Remember, each volume means that you must enter another tape in tape drive. When you define volume on particular tape, unique header will be written on this tape with params, defined for this volume (size,etc.). 5.After desired number of volumes was installed, you can create OnArchive archive request. In request you must specify vset, defined in previous steps. During request you can specify whether this request will be executed immediately, or you will execute this request manually later. For detailed overview see 'Archive and Backup Guide' - you can find it on www.informix.com. Hope this helps. ---------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 > > Thanks in advance. > > Regards, > > > Santanu > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

Santanu Das <sanformix@hotmail.com> wrote in message news:7u7ugm$pd5$1@news.xmission.com... > > Yuri- Thanks a lot..!! > > Have you ever restore from the OnArchive tape.. Yes, of course. I've used OnArchive for about 2 years. > I tried taking the Archive backup in tape (two dbspaces only). It went > properly. Again I tried to restore it. This is also fine. I got the message > like > "Physical Restore of pstable_test75, psindex_test75 started. > Checkpoint Completed: duration was 0 seconds. > Checkpoint Completed: duration was 0 seconds. > Checkpoint Completed: duration was 1 seconds. > Physical Restore of pstable_test75, psindex_test75 Completed." > > I have one database in one dbspace(pstable_test75). > The indexes are in a different dbspace (psindex_test75). The database name > is test75. While I tried to use this Database Test75 I got an error message > like this. > > " 311: Cannot open system catalog (systables). > 155: ISAM error: Primary and Mirror chunks are bad "> > What could be the reason.. Any idea.. First of all - when you restore your dbspaces you need associated logical log records to perform logical recovery for this dbspaces. Second - examine Database Tablespace, it's page address is 0x100002. Check there if systable's address for this database is correct. For more detailed analysis post full fragment of your online.log file. ---------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285 > > Thank you > > Santanu > > > From: "Yuri Dovgart" <y_dovgart@tci.ukrtel.net> > Reply-To: "Yuri Dovgart" <y_dovgart@tci.ukrtel.net> > To: informix-list@iiug.org > Subject: Re: On-Archive Setup... > Date: Fri, 15 Oct 1999 09:33:35 +0300 > > Santanu Das <sanformix@hotmail.com> wrote in message > news:7u54s1$k81$1@news.xmission.com... > > > > Hi all, > > > > Could somebody help me in setting up the On-Archive tool. If you have a > > installation/setup guide for using On-Archive then this will help me. > > > > I have IDS 7.3 running on HP Box. > > 1.First of all, you need to define your device types in > $INFORMIXDIR/etc/config.arc. If you want to use tape define this as TAPE = > /dev/rmt0h > > 2.Then you must go to On-Archive (I'm using menu interface, it seems to > me much easy then command ). > 3.First of all, you create vset with your device type. Vset is logical > grouping of volumes. > 4.Then specify volumes for this vset. Remember, each volume means that > you must enter another tape in tape drive. When you define volume on > particular tape, unique header will be written on this tape with params, > defined for this volume (size,etc.). > 5.After desired number of volumes was installed, you can create > OnArchive archive request. In request you must specify vset, defined in > previous steps. During request you can specify whether this request will be > executed immediately, or you will execute this request manually later. > > For detailed overview see 'Archive and Backup Guide' - you can find it on > www.informix.com. > > Hope this helps. > > ---------------------------------------------------- > With best regards, Yuri Dovgart > SAP R/3, Informix technical consultant, > Senior System Consultant > System Architecture and High Availability Systems, > 'Telecominvest' company > Email y_dovgart@tci.ukrtel.net > ICQ 39284285 > > > > Thanks in advance. > > > > Regards, > > > > > > Santanu > > > > ______________________________________________________ > > Get Your Private, Free Email at http://www.hotmail.com > > > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com