IDS Forum

RE: How to recover

Posted By: Walter Milan
Date: Monday, 6 October 2008, at 3:40 p.m.

In Response To: Re: How to recover (Jean Sagi)

Just to be clear, once is marked down the only way to put it back on is
through a restore or a technical support call.

Walter Milan
DBA

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Jean Sagi
Sent: Monday, October 06, 2008 2:09 PM
To: ids@iiug.org
Subject: Re: How to recover [13604]

Well... doing some oncheks I actually see that my fault chunk is
offline!
I was aware of ONDBSPACEDOWN, but I think it is for dbaspaces ...
Anyway I'l try this to see how things goes.

J.

2008/10/6 Walter Milan <Walter.Milan@hilton.com>

> My take is that you could not fix it because you had
> ONDBSPACEDOWN set to 0 (continue). Had you had it set it to 1 (Abort),

> the instance will error out and give you the chance to put the chunk
> back in place and try again. When it is set to continue, it is marked
> down and the only way to recover it is thru a restore or a call to
> Technical support.
>
> I had several occasions when for any reason a chunk was not available
> and I was able to start the engine fine after the issue with the chunk

> was resolved.
>
> Walter Milan
> DBA
>
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
> Jean Sagi
> Sent: Monday, October 06, 2008 12:28 PM
> To: ids@iiug.org
> Subject: Re: How to recover [13601]
>
> it is.
>
> J.
>
> BTW: One can create hard links in windows with fsutil ...
>
> 2008/10/6 jack.parker4@verizon.net <jack.parker4@verizon.net>
>
> > Ensure that %ONCONFIG% ROOTPATH still points to the correct place.
> >
> > j.
> >
> > On Mon, Oct 6, 2008 at 10:42 AM, Jean Sagi wrote:
> >
> > > No luck yet.
> > Even creating hard links (in windows!) I'm still having the same
> > errors...
> >
> > Now checking with onchek's
> >
> > J.
> >
> > PD: This does not looks good...
> >
> > 2008/10/4 Art Kagel <art.kagel@gmail.com
<mailto:art.kagel@gmail.com>
> > <mailto:art.kagel@gmail.com> >
> >
> > > Try creating a link so that both names exist.
> > > Art
> > > On Sat, Oct 4, 2008 at 3:12 PM, Jean Sagi <jeansagi.ifx@gmail.com
> > > <mailto:jeansagi.ifx@gmail.com> <mailto:jeansagi.ifx@gmail.com> >
> > > wrote:
> > >> Hi everyone... Some help would be helpfull:
> > >> I was trying different sizes for a chunk and was creating it and
> then
> > >> deleting it (with diffferent sizes). In an unknow turn of events
I
> > >> didn't drop a chunk properly (onspaces -d ...) , instead I
renamed
> > >> the chunk from "chunk_name" to "__chunkname" and
> > > swith
> > >> off the engine. Now when I bring up the instance (oninit -v) I
get
> > >> this message:
> > >> Opening primary chunks...Bad Primary Chunk
> > >> 'D:\IFMXDATA\ol_svr_custom\ol_svr_custom_dat.002'.
> > >> because I renamed ol_svr_custom_dat.002 to
__ol_svr_custom_dat.002
> > >> All in all the database goes on-line but when I try to do
something
> I
> > >> get this:
> > >> 311: Cannot open system catalog (systables). 155: ISAM error:
> Primary
> > >> and Mirror chunks are bad
> > >> Then i renamed the chunk back to its original name
> > >> ol_svr_custom_dat.002
> > >> And tryed to start the instance but same error still appear...
> > >> So what can I do? Any help/hint would be very appreciated.
> > >> Thanks in advance
> > >> J.
> > >> BTW this is a test : Window XP-SP2 IDS 11.5 TC1
> > >>
> > >>
> > >>
> > >
> > >
> >
> >
> >
> >
>
************************************************************************

> *******
> > >> Forum Note: Use "Reply" to post a response in the discussion
forum.
>
> > >>
> > >
> > > --
> > > Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors
> > > (art@iiug.org) <mailto:(art@iiug.org)> <mailto:(art@iiug.org)>
> > >
> > > Disclaimer: Please keep in mind that my own opinions are my own
> > > opinions and do not reflect on my employer, Oninit, the IIUG, nor
> any
> > > other organization with which I am associated either explicitly or

> > > implicitly. Neither do those opinions reflect those of other
> > > individuals affiliated with any entity with which I am affiliated
> nor
> > > those of the entities themselves.
> > >
> > >
> > >
> >
> >
> >
> >
>
************************************************************************

> *******
> > > 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.
>
>
>
>
************************************************************************
*******
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• How to recover
  Jean Sagi -- Saturday, 4 October 2008, at 3:12 p.m.
  • Re: How to recover
    Art Kagel -- Saturday, 4 October 2008, at 11:01 p.m.
    • Re: How to recover
      Jean Sagi -- Monday, 6 October 2008, at 10:42 a.m.
      • Re: How to recover
        Jean Sagi -- Monday, 6 October 2008, at 12:39 p.m.
      • Re: How to recover
        jack.parker4@verizon.net -- Monday, 6 October 2008, at 1:20 p.m.
        • Re: How to recover
          Jean Sagi -- Monday, 6 October 2008, at 1:28 p.m.
          • Re: How to recover
            jack.parker4@verizon.net -- Monday, 6 October 2008, at 2:15 p.m.
          • RE: How to recover
            Walter Milan -- Monday, 6 October 2008, at 2:19 p.m.
            • Re: How to recover
              Jean Sagi -- Monday, 6 October 2008, at 3:08 p.m.
              • RE: How to recover
                Walter Milan -- Monday, 6 October 2008, at 3:40 p.m.
                • Re: How to recover
                  Jean Sagi -- Monday, 6 October 2008, at 4:03 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.