Re: restore using ontape

In article <8ildh0$1ms$1@news.xmission.com>, Don Ignacio <dignacio@openratings.com> writes > >Hi, > >When you run ontape -r ... Did you choose the option to >restore logical logs. If not this might be the cause of having >inconsistent chunks. I would recommend that you restore the >logical logs when restoring selected dbspaces. > > Also try onmode -m. You need to bring the server to online mode after a restore. >Don > >Srinivas Sreekumar wrote: >> >> Hi All, >> >> Now the chunk status is as below >> >> c61f7458 3 3 1 750000 536821 PI- /dev/vg05/databaseB >> c61f7538 4 3 2 766000 726581 PI- /dev/vg04/databaseC >> >> How can I make the chunk online or change the status to "PO". >> Pls help me out..... >> we have informix 7.30 on HP UX. >> >> thanks, >> Srini >> >> -----Original Message----- >> From: Srinivas Sreekumar >> Sent: Monday, June 19, 2000 2:25 PM >> To: informix-list@iiug.org >> Subject: restore using ontape >> Importance: High >> >> Hi All, >> >> I am new to informix....So pls help me. >> >> I had a problem with one of my the chunk of a DBSpace. I had to restore it >> from the tape using "ontape -r -D dbaseb" >> the restoration was compleated successfully.Now the status of dbspaces are >> as below... >> ---------------------------------------------------------------------------- >> -------------------- >> informix@haddock:/usr/informix> onstat -d >> >> Informix Dynamic Server Version 7.30.UC8 -- Quiescent -- Up 02:21:27 -- >> 13544 >> Kbytes >> >> Dbspaces >> address number flags fchunk nchunks flags owner name >> c61f7158 1 1 1 1 N informix rootdbs7 >> c61f76f8 2 1 2 1 N informix dbasea >> c61f77b8 3 401 3 2 NP informix dbaseb >> c61f7878 4 1 5 1 N informix dbased >> 4 active, 2047 maximum >> >> Chunks >> address chk/dbs offset size free bpages flags pathname >> c61f7218 1 1 1 250000 55958 PO- >> /dev/vg01/rootdb7vol >> c61f7378 2 2 1 750000 147766 PO- >> /dev/vg05/databaseA >> c61f7458 3 3 1 750000 536821 PI- >> /dev/vg05/databaseB >> c61f7538 4 3 2 766000 726581 PI- >> /dev/vg04/databaseC >> c61f7618 5 4 0 50000 49085 PO- >> /dev/vg05/databaseD >> 5 active, 2047 maximum >> >> ---------------------------------------------------------------------------- >> --------------------- >> >> The flags for Dbspace "dbaseb" is showing "NP" and for chunks are showing >> "PI". >> Now what am I supposed to do after this to make the database consistent and >> up and running. >> >> thanks, >> Srini -- David Williams

Hi, When you run ontape -r ... Did you choose the option to restore logical logs. If not this might be the cause of having inconsistent chunks. I would recommend that you restore the logical logs when restoring selected dbspaces. Don Srinivas Sreekumar wrote: > > Hi All, > > Now the chunk status is as below > > c61f7458 3 3 1 750000 536821 PI- /dev/vg05/databaseB > c61f7538 4 3 2 766000 726581 PI- /dev/vg04/databaseC > > How can I make the chunk online or change the status to "PO". > Pls help me out..... > we have informix 7.30 on HP UX. > > thanks, > Srini > > -----Original Message----- > From: Srinivas Sreekumar > Sent: Monday, June 19, 2000 2:25 PM > To: informix-list@iiug.org > Subject: restore using ontape > Importance: High > > Hi All, > > I am new to informix....So pls help me. > > I had a problem with one of my the chunk of a DBSpace. I had to restore it > from the tape using "ontape -r -D dbaseb" > the restoration was compleated successfully.Now the status of dbspaces are > as below... > ---------------------------------------------------------------------------- > -------------------- > informix@haddock:/usr/informix> onstat -d > > Informix Dynamic Server Version 7.30.UC8 -- Quiescent -- Up 02:21:27 -- > 13544 > Kbytes > > Dbspaces > address number flags fchunk nchunks flags owner name > c61f7158 1 1 1 1 N informix rootdbs7 > c61f76f8 2 1 2 1 N informix dbasea > c61f77b8 3 401 3 2 NP informix dbaseb > c61f7878 4 1 5 1 N informix dbased > 4 active, 2047 maximum > > Chunks > address chk/dbs offset size free bpages flags pathname > c61f7218 1 1 1 250000 55958 PO- > /dev/vg01/rootdb7vol > c61f7378 2 2 1 750000 147766 PO- > /dev/vg05/databaseA > c61f7458 3 3 1 750000 536821 PI- > /dev/vg05/databaseB > c61f7538 4 3 2 766000 726581 PI- > /dev/vg04/databaseC > c61f7618 5 4 0 50000 49085 PO- > /dev/vg05/databaseD > 5 active, 2047 maximum > > ---------------------------------------------------------------------------- > --------------------- > > The flags for Dbspace "dbaseb" is showing "NP" and for chunks are showing > "PI". > Now what am I supposed to do after this to make the database consistent and > up and running. > > thanks, > Srini