IDS Forum

Re: Restore Problem

Posted By: Eric Rowell
Date: Tuesday, 14 February 2006, at 12:40 a.m.

In Response To: RE: Restore Problem (Jarratt, Linwood B.)

One last set of suggestions before I go off to sleep for work tomorrow....

Have you tried doing the physical only? ontape -p
and then running the logical? ontape -l

Again make sure everything matches in the two servers onconfigs as best you
can. As always including chunk locations...

It seems like I'm missing something easy. If you get it me let me know.

On 2/14/06, Jarratt, Li.... <LJarratt@co.lake.il.us> wrote:
>
>
> The backup was done with ontape -s -L 0 and the restore with ontape -r.
>
> I did bring up a default instance with oninit -ivy. There is a differend
> in
> that the restored copy has the physical logs in its own dbspace. After I
> shut down the default instance, I modified the onconfig file to reflect
> the
> correct location of the physical logs before doing the restore.
>
> Thanks so far. Any suggestion is better than what I have right now. I have
> tried everything I know.
>
> Lennie
>
> > -----Original Message-----
> > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of
> > Eric Rowell
> > Sent: Monday, February 13, 2006 11:22 PM
> > To: ids@iiug.org
> > Subject: Re: Restore Problem [6384]
> >
> >
> >
> > None that I know of.
> >
> > The following was leading me to think that you had HDR running.
> >
> > "the 'onmode -d' command and wait for the pair to be operational"
> >
> > Ummm.... What commands are you using for the backup and the
> > restore. Also
> > did you get the new instance to start without doing the restore? Just
> > using the oninit -ivy or the like?
> >
> > Have you made sure that the instance name and server number
> > are the same?
> > host and port don't matter.
> >
> > I wish I was more help right now but it has been a while since I have
> > fumbled through an ontape problem.
> >
> > On 2/14/06, Jarratt, Li.... <LJarratt@co.lake.il.us> wrote:
> > >
> > >
> > > >From production:
> > >
> > > IBM Informix Dynamic Server Version 9.40.UC7 -- On-Line --
> > Up 21:27:53
> > > -- 1116012 Kbytes
> > >
> > > It fails within 30 seconds evey time. It initializes shared
> > memory and
> > > starts the restore. I believe it crashes at that spot.
> > onmode -d standard
> > > errors out. I tried it just in case. The original backups
> > was a normal
> > > ontape backup and is 93 GB.
> > >
> > > Is there something in the ontape backup that keeps if from
> > restoring if
> > > the
> > > original server is still available?
> > >
> > > Lennie
> > >
> > > > -----Original Message-----
> > > > From: ids-bounces@iiug.org
> > [mailto:ids-bounces@iiug.org]On Behalf Of
> > > > Eric Rowell
> > > > Sent: Monday, February 13, 2006 11:11 PM
> > > > To: ids@iiug.org
> > > > Subject: Re: Restore Problem [6382]
> > > >
> > > >
> > > >
> > > > Can you provide an "onstat -" from the server the backup
> > came from?
> > > >
> > > > Have you tried issuing the "onmode -d standard" or is this a
> > > > very lengthy
> > > > restore that you only want to try getting this right once?
> > > >
> > > > On 2/14/06, Jarratt, Li.... <LJarratt@co.lake.il.us> wrote:
> > > > >
> > > > >
> > > > > Nope, I am not using HRD. I am doing a stand alone server
> > > > just to recover
> > > > > the production backup from friday night. I installed
> > > > informix, then copied
> > > > > over the backup file and ran ontape -r.
> > > > >
> > > > > Lennie
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: ids-bounces@iiug.org
> > > > [mailto:ids-bounces@iiug.org]On Behalf Of
> > > > > > Eric Rowell
> > > > > > Sent: Monday, February 13, 2006 10:59 PM
> > > > > > To: ids@iiug.org
> > > > > > Subject: Re: Restore Problem [6380]
> > > > > >
> > > > > >
> > > > > >
> > > > > > Please don't use stars in running this command. Darn text
> > > > > > editor and system
> > > > > > user errors.
> > > > > >
> > > > > > The following should be correct.
> > > > > >
> > > > > > onmode -d standard
> > > > > >
> > > > > > On 2/13/06, Eric Rowell <erowell@gmail.com> wrote:
> > > > > > >
> > > > > > >
> > > > > > > Are you using HDR? I have only ever seen this when
> > > > > > restoring a Primary
> > > > > > > server to a would be secondary. It has been a bit over a
> > > > > > year but you
> > > > > > > should be able to give the command to make this a
> > > > > > standalone server and it
> > > > > > > will return to normal function. You should restore any
> > > > > > logical logs you
> > > > > > > want applied before running the following...
> > > > > > >
> > > > > > > *onmode* -*d* standard
> > > > > > >
> > > > > > > Only way to avoid this in the future is to not backup
> > > > while HDR is
> > > > > > > running.
> > > > > > > Not suggested for data safety and all of the pain you may
> > > > > > have to go
> > > > > > > through
> > > > > > > to get things re-sync'd.
> > > > > > >
> > > > > > > Eric B. Rowell
> > > > > > >
> > > > > > > On 2/13/06, Jarratt, Li.... <LJarratt@co.lake.il.us> wrote:
> > > > > > > >
> > > > > > > >
> > > > > > > > I am tyring to restore a production backup to a spare box
> > > > > > to get some
> > > > > > > > deleted rows from one table. I am getting the following
> > > > > > error when
> > > > > > > trying
> > > > > > > > to restore:
> > > > > > > >
> > > > > > > > 22:38:04 Event alarms enabled. ALARMPROG =
> > > > > > > > '/ifxapp/informix/etc/alarmprogram.sh'
> > > > > > > > 22:38:04 Booting Language <c> from module <>
> > > > > > > > 22:38:04 Loading Module <CNULL>
> > > > > > > > 22:38:04 Booting Language <builtin> from module <>
> > > > > > > > 22:38:04 Loading Module <BUILTINNULL>
> > > > > > > > 22:38:10 IBM Informix Dynamic Server Version 9.40.UC7
> > > > > > Software Serial
> > > > > > > > Number AAA#B000000
> > > > > > > > 22:38:10 IBM Informix Dynamic Server Initialized --
> > > > Shared Memory
> > > > > > > > Initialized.
> > > > > > > >
> > > > > > > > 22:38:10 Data replication type and state information
> > > > > > reset. To start DR,
> > > > > > > > use
> > > > > > > >
> > > > > > > > the 'onmode -d' command and wait for the pair to be
> > > > operational,
> > > > > > > >
> > > > > > > > before shutting down the database server
> > > > > > > >
> > > > > > > > 22:38:10 Dataskip is now OFF for all dbspaces
> > > > > > > > 22:38:10 Restartable Restore has been ENABLED
> > > > > > > > 22:38:10 Recovery Mode
> > > > > > > > 22:38:12 Get Shadow Password for user [informix] failed!
> > > > > > > > 22:38:12 Check for password aging/account lock-out.
> > > > > > > > 22:38:12 listener-thread: err = -951: oserr = 0: errstr =
> > > > > > informix:
> > > > > > > > Incorrect password or user informix is not known on the
> > > > > > database server.
> > > > > > > >
> > > > > > > > I am running the restore user Informix so that is not the
> > > > > > issue. Both
> > > > > > > > systems have the same password. I have tried using the
> > > > > > same instance
> > > > > > > name
> > > > > > > > and different names as production.
> > > > > > > >
> > > > > > > > This in on IDS 9.4.UC7 on Redhat Linux 3.
> > > > > > > >
> > > > > > > > Thanks for the help.
> > > > > > > >
> > > > > > > > Lennie
> > > > > > > >
> > > > > > > > Informix DBA
> > > > > > > > Information Technology Tax team
> > > > > > > > Lake County, IL
> > > > > > > > O: 847-377-2092
> > > > > > > > C: 847-309-7718
> > > > > > > >
> > > > > > > > Math illiteracy affects 7 out of every 5 people.
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > **************************************************************
> > > > > > *****************
> > > > > > > > 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.
> > >
> > >
> >
> >
> > **************************************************************
> > *****************
> > 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

• Restore Problem
  Jarratt, Linwood B. -- Monday, 13 February 2006, at 11:43 p.m.
  • Re: Restore Problem
    Eric Rowell -- Monday, 13 February 2006, at 11:55 p.m.
    • Re: Restore Problem
      Eric Rowell -- Monday, 13 February 2006, at 11:59 p.m.
      • RE: Restore Problem
        Jarratt, Linwood B. -- Tuesday, 14 February 2006, at 12:02 a.m.
        • Re: Restore Problem
          Eric Rowell -- Tuesday, 14 February 2006, at 12:10 a.m.
          • RE: Restore Problem
            Jarratt, Linwood B. -- Tuesday, 14 February 2006, at 12:16 a.m.
            • Re: Restore Problem
              Eric Rowell -- Tuesday, 14 February 2006, at 12:22 a.m.
              • RE: Restore Problem
                Jarratt, Linwood B. -- Tuesday, 14 February 2006, at 12:27 a.m.
                • Re: Restore Problem
                  Eric Rowell -- Tuesday, 14 February 2006, at 12:40 a.m.
                  • RE: Restore Problem
                    Jarratt, Linwood B. -- Tuesday, 14 February 2006, at 12:42 a.m.
  • Re: Restore Problem
    Martin Fuerderer -- Tuesday, 14 February 2006, at 5:51 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.