Re: RE: Dev server restore fails
User attempted to restore logical logs after a physical database restore using ontape -l with -t STDIO option, which failed. Experts advised that LTAPEDEV should point to a directory containing log backups, ontape -l should be used without STDIO, and the server automatically identifies needed logs without specifying individual files. One expert questioned whether -l option supports -t STDIO at all. No final resolution confirmation provided.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
If you have done a ontape -p
- Change -p to -l
- Change the filename to the filename for the logical log backup.
Regards,
David.
> On 19 April 2017 at 20:23 BENJI LONG <ruggedmouse@hotmail.com> wrote:
>
>
> when you say to use -l -t STDIO, what is the complete command for that?
>
> I did a ontape -p and that restored everything except my logical log "I
> think". Now I want to restore the logical log which I backed up to a file
> before the restore.
>
> I tried a number of things but it said There are no DBSpaces to recover.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
This is what I am attempting to do. It is based on the PROD server we have
taken over and I'm trying to replicate that.
I set LTAPEDEV to /opt/informix/log_backups
I think I then ran ontape -a to backup the log files and I see that file in
the log_backups folder.
I then ran:
ontape -r -t STDIO < /opt/informix/full_backup/1_L0_Arhive
and that worked.
I then ran:
ontape -l -t STDIO </opt/informix/log_backups/name of log file
and that failed.
I was listening to Lesters webcast and I think I might know where I went wrong
and will check in the morning.
It looks like I have the correct command to restore, but I believe I might
have an issue with my log file. I think it used the onbar command. I need to
have a closer look.
My environment uses log_full.sh instead of alarmprogram.sh
a lot of different things can go wrong here when it is being done so
differently.
> On 20 Apr 2017, at 17:18, BENJI LONG <ruggedmouse@hotmail.com> wrote:
>
> This is what I am attempting to do. It is based on the PROD server we have
> taken over and I'm trying to replicate that.
>
> I set LTAPEDEV to /opt/informix/log_backups
>
> I think I then ran ontape -a to backup the log files and I see that file in
> the log_backups folder.
>
> I then ran:
> ontape -r -t STDIO < /opt/informix/full_backup/1_L0_Arhive>
> and that worked.
>
> I then ran:
> ontape -l -t STDIO </opt/informix/log_backups/name of log file>
> and that failed.
And what was the error you got?
also you dont NEED the STDIO in the restore - just point at the file
Remove the STDIO on the ontape -l -t /opt/informix/log_backups/name of log file
In case you have the LTAPEDEV pointed to a directory, which seems to be the
case,
ontape -l will identify the logfiles there without any further options.(the same way ontape -a will save them automatically appended with a logno).
The only thing to prepare is the correct access rights (mode 660, owner/group
informix)
and to have either the same servername or IFX_ONTAPE_FILE_PREFIX value (which
sets the prefix of the file names).
After a physical restore, the server will also know exactly which log will be
needed next,
there is no need to point to a specific file. In a productive environment,
normally there are multiple
logs to restore, this would be very annoying to name each logfile one by one.
Hope this helps,
Marcus
Von: "Clive Eisen" <clive@serendipita.com>
An: "ids" <ids@iiug.org>
Gesendet: Freitag, 21. April 2017 19:42:25
Betreff: Re: Dev server restore fails [39007]
> On 20 Apr 2017, at 17:18, BENJI LONG <ruggedmouse@hotmail.com> wrote:
>
> This is what I am attempting to do. It is based on the PROD server we have
> taken over and I'm trying to replicate that.
>
> I set LTAPEDEV to /opt/informix/log_backups
>
> I think I then ran ontape -a to backup the log files and I see that file in
> the log_backups folder.
>
> I then ran:
> ontape -r -t STDIO < /opt/informix/full_backup/1_L0_Arhive>
> and that worked.
>
> I then ran:
> ontape -l -t STDIO </opt/informix/log_backups/name of log file>
> and that failed.
And what was the error you got?
also you dont NEED the STDIO in the restore - just point at the file
Remove the STDIO on the ontape -l -t /opt/informix/log_backups/name of log
file
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
I'm unsure -l option (logical restore) would support -t STDIO at all ....
From: "Marcus Haarmann" <marcus.haarmann@midoco.de>
To: ids@iiug.org
Date: 22.04.2017 17:24
Subject: Re: Dev server restore fails [39008]
Sent by: ids-bounces@iiug.org
In case you have the LTAPEDEV pointed to a directory, which seems to be=20
the=20
case,=20
ontape -l will identify the logfiles there without any further options.=20(the same way ontape -a will save them automatically appended with a=20
logno).=20
The only thing to prepare is the correct access rights (mode 660,=20
owner/group=20
informix)=20
and to have either the same servername or IFX=5FONTAPE=5FFILE=5FPREFIX valu=
e=20
(which=20
sets the prefix of the file names).=20
After a physical restore, the server will also know exactly which log will =
be=20
needed next,=20
there is no need to point to a specific file. In a productive environment, =
normally there are multiple=20
logs to restore, this would be very annoying to name each logfile one by=20
one.=20
Hope this helps,=20
Marcus=20
Von: "Clive Eisen" <clive@serendipita.com>=20
An: "ids" <ids@iiug.org>=20
Gesendet: Freitag, 21. April 2017 19:42:25=20
Betreff: Re: Dev server restore fails [39007]=20
> On 20 Apr 2017, at 17:18, BENJI LONG <ruggedmouse@hotmail.com> wrote:=20
>=20
> This is what I am attempting to do. It is based on the PROD server we=20
have=20
> taken over and I'm trying to replicate that.=20
>=20
> I set LTAPEDEV to /opt/informix/log=5Fbackups=20
>=20
> I think I then ran ontape -a to backup the log files and I see that file =
in=20
> the log=5Fbackups folder.=20
>=20
> I then ran:=20
> ontape -r -t STDIO < /opt/informix/full=5Fbackup/1=5FL0=5FArhive=20
>=20
> and that worked.=20
>=20
> I then ran:=20
> ontape -l -t STDIO </opt/informix/log=5Fbackups/name of log file=20
>=20
> and that failed.=20And what was the error you got?=20
also you dont NEED the STDIO in the restore - just point at the file=20
Remove the STDIO on the ontape -l -t /opt/informix/log=5Fbackups/name of lo=
g=20
file=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20