Restore Problem
A DBA tried to restore a 93GB ontape level-0 backup of a production IDS 9.40.UC7 server (Red Hat Linux 3) onto a spare box to recover deleted rows. The restore died within ~30 seconds with 'Get Shadow Password for user [informix] failed!' and error -951 (incorrect password/unknown user), plus messages about data replication state being reset. Eric Rowell suspected HDR state in the backup and suggested 'onmode -d standard', but the poster wasn't using HDR and that command errored out. Discussion covered backup/restore commands, instance name/server number matching and a relocated physical log dbspace, but the thread records no resolution.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
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.
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.
>
>
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.
>
>
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.
>
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.
>
>
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.
>
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.
>
>
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.
> > > > > > >
> > > > > > >
> > > > > >@
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.
> >
still doesn't work. Thanks. I guess I'll be calling IBM in the morning.
Lennie
> -----Original Message-----
> From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of
> Eric Rowell
> Sent: Monday, February 13, 2006 11:40 PM
> To: ids@iiug.org
> Subject: Re: Restore Problem [6386]
>
>
>
> 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 Dat
Hi,
forget about the "onmode -d" command. It does not concern you
as you did not have HDR in the first place. This would lead
you into wrong direction.
Your problem is as stated: the (correct) password for user informix
cannot be retrieved from /etc/shadow file.
Most likely this is a permission problem of the binary files.
How did you "install" IDS on the spare machine.
Please do this installation again - by the book.
No fancy copy/tar/pipe... stuff, but real install of the real product.
This will set the permissions correctly. Then you have to configure
the sqlhosts file correctly, as the spare machine probably has a
different hostname than the production machine ...
Then configure the onconfig file correctly, where this means it
should be pretty much the same as on the production system.
Then set the environment correctly.
After that your restore should work.
Regards,
Martin
--
Martin Fuerderer
IBM Informix Development Munich, Germany
Information Management
ids-bounces@iiug.org wrote on 14.02.2006 05:43:59:
>
> 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.
>