Is it possible to implement HDR
A user with a rootdbs made of two chunks (rootdbs.000 and rootdbs_p_1.000) asked whether HDR is possible, after an ontape physical restore (ontape -p) on the secondary failed with "Cannot Open Primary Chunk ... errno = 2/9" for rootdbs_p_1. Respondents (Kagel, Haarmann, Legner) said multiple chunks per dbspace are fine and irrelevant to HDR: the restore simply requires every chunk file/device to pre-exist on the secondary at exactly the same path/name (note rootdbs_p_1 vs rootdbs_p_1.000), with the same size (files may be zero-length but space must be available) and correct informix ownership/permissions; later chunk additions must also be mirrored. No confirmation from the original poster is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hello All
My production server consists of two different rootdbs chunks.
Is it possible to implement the HDR in this scenario, because while using
ONTAPE to taking backup and for physical restore we are getting an ambiguity
in chunks. how to resolve this.
I think the only way is to make the rootdbs chunks in production server as one
using dbexport and dbimport.
Suggest me please.
Hi,
What is meant by "getting an ambiguity in chunks"?
Regards,
David.
> On 17 July 2017 at 04:20 MUKESH TANUKU <mukeshbt1328@gmail.com> wrote:
>
>
> Hello All
>
> My production server consists of two different rootdbs chunks.
>
> Is it possible to implement the HDR in this scenario, because while using
> ONTAPE to taking backup and for physical restore we are getting an ambiguity
> in chunks. how to resolve this.
>
> I think the only way is to make the rootdbs chunks in production server as
one
> using dbexport and dbimport.
>
> Suggest me please.
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
It should not be an issue affecting whether you can set up HDR or not. The
archive and restore goes dbspace by dbspace starting with the rootdb
dbspace, so as long as the same chunk files are available on the secondary
and each is at least as big as it is ont he primary, the physical restore
should complete without a problem.
What ambiguity are you seeing or expecting?
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Sun, Jul 16, 2017 at 10:20 PM, MUKESH TANUKU <mukeshbt1328@gmail.com>
wrote:
> Hello All
>
> My production server consists of two different rootdbs chunks.
>
> Is it possible to implement the HDR in this scenario, because while using
> ONTAPE to taking backup and for physical restore we are getting an
> ambiguity
> in chunks. how to resolve this.
>
> I think the only way is to make the rootdbs chunks in production server as
> one
> using dbexport and dbimport.
>
> Suggest me please.
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
My primary server rootdbs is having two chnaks
rootdbs.000 and rootdbs_p_1.000
As a part of implementing HDR, After taking ontape backup of primary server
and restoring to secondary server using ontape -p. i am getting below error.
15:55:28 Warning: stat() failed for chunk file E:\\\\informix\\\\storage\\\\rootdbs_p_1
15:55:28 Cannot Open Primary Chunk 'E:\\\\informix\\\\storage\\\\rootdbs_p_1', errno = 2
15:55:28 oninit: Cannot open chunk 'E:\\\\informix\\\\storage\\\\rootdbs_p_1'. errno = 9
If i created the rootdbs_p_1.000 it is also throughing an error like rootdbs
is differ from the ontape backup.
So that im asking like, Is it mandatory to be having the rootdbs as one chunk
while working with ontape?
Hi,
you can split the rootdbs over any number of chunks up the limits same as
other dbs.
Ontape has no restrictions here.
The point is, when restoring on a second machine the chunks need to be present
at the same location.
(with the correct access rights).
Also, if you add a chunk later for any dbs, this will fail if the secondary
machine cannot add the
same chunk on the other host.
Marcus Haarmann
Von: "MUKESH TANUKU" <mukeshbt1328@gmail.com>
An: "ids" <ids@iiug.org>
Gesendet: Montag, 17. Juli 2017 11:41:24
Betreff: Re: Is it possible to implement HDR [39595]
My primary server rootdbs is having two chnaks
rootdbs.000 and rootdbs_p_1.000
As a part of implementing HDR, After taking ontape backup of primary server
and restoring to secondary server using ontape -p. i am getting below error.
15:55:28 Warning: stat() failed for chunk file E:\\\\informix\\\\storage\\\\rootdbs_p_1
15:55:28 Cannot Open Primary Chunk 'E:\\\\informix\\\\storage\\\\rootdbs_p_1', errno =
2
15:55:28 oninit: Cannot open chunk 'E:\\\\informix\\\\storage\\\\rootdbs_p_1'. errno =
9
If i created the rootdbs_p_1.000 it is also throughing an error like rootdbs
is differ from the ontape backup.
So that im asking like, Is it mandatory to be having the rootdbs as one chunk
while working with ontape?
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Any dbspace can have as many chunks as you want. This, at this restore
stage, is not about HDR, but about restoring a backup.
What a restore expects on the target system is:
- files or devices defined for any chunk to be restored, so in your case
for any chunk existing on the primary
-> your errno 2 indicates this wasn't the case for rootdbs_p_1 --
what is this in relation to rootdbs_p_1.000 ?
- files can be empty (zero size), but storage space must be able to
accommodate full chunk sizes
- files/devices must have proper permissions - should be the case if you
created them as user informix
Maybe you're confusing rootdbs_p_1 with rootdbs_p_1.000 ?
HTH,
Andreas
From: "MUKESH TANUKU" <mukeshbt1328@gmail.com>
To: ids@iiug.org
Date: 07/17/2017 11:41 AM
Subject: Re: Is it possible to implement HDR [39595]
Sent by: ids-bounces@iiug.org
My primary server rootdbs is having two chnaks
rootdbs.000 and rootdbs_p_1.000
As a part of implementing HDR, After taking ontape backup of primary server
and restoring to secondary server using ontape -p. i am getting below
error.
15:55:28 Warning: stat() failed for chunk file E:\\\\informix\\\\storage
\\\\rootdbs_p_1
15:55:28 Cannot Open Primary Chunk 'E:\\\\informix\\\\storage\\\\rootdbs_p_1', errno
=
2
15:55:28 oninit: Cannot open chunk 'E:\\\\informix\\\\storage\\\\rootdbs_p_1'. errno
=
9
If i created the rootdbs_p_1.000 it is also throughing an error like
rootdbs
is differ from the ontape backup.
So that im asking like, Is it mandatory to be having the rootdbs as one
chunk
while working with ontape?
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
No. However, the files for each chunk MUST:
1. already exist as files (they can be zero length, but they have to
exist)
2. have to be in the same location/path as on the primary
3. have correct permissions as on the primary
Art
Art S. Kagel, President and Principal Consultant
ASK Database Management
www.askdbmgt.com
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on the IIUG, nor any other organization with which I am
associated either explicitly, implicitly, or by inference. Neither do
those opinions reflect those of other individuals affiliated with any
entity with which I am affiliated nor those of the entities themselves.
On Mon, Jul 17, 2017 at 4:41 AM, MUKESH TANUKU <mukeshbt1328@gmail.com>
wrote:
> My primary server rootdbs is having two chnaks
> rootdbs.000 and rootdbs_p_1.000
>
> As a part of implementing HDR, After taking ontape backup of primary server
> and restoring to secondary server using ontape -p. i am getting below
> error.
>
> 15:55:28 Warning: stat() failed for chunk file
> E:\\\\informix\\\\storage\\\\rootdbs_p_1
> 15:55:28 Cannot Open Primary Chunk 'E:\\\\informix\\\\storage\\\\rootdbs_p_1',
> errno =
> 2
> 15:55:28 oninit: Cannot open chunk 'E:\\\\informix\\\\storage\\\\rootdbs_p_1'.
> errno =
> 9
>
> If i created the rootdbs_p_1.000 it is also throughing an error like
> rootdbs
> is differ from the ontape backup.
>
> So that im asking like, Is it mandatory to be having the rootdbs as one
> chunk
> while working with ontape?
>
>
> ************************************************************
> *******************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>