Physical restore for High Availablity

[gora]

Hi All,

I am trying to configure two Informix Server for HAP(High Avaibality). For this on secondary server, when I try to perform physical recovery using ontape I am getting following error.
Following is the command used
ontape -p
Error Message
Physical restore failed - function read archive backup failed code -1 errno 0
So, could any body tell me what could be the problem ??

Thaks in Advance,
Govind

 

[gheist]

a tape problem - check if blocksizes are same on both servers ( or the whole onconfig)

 

[gora]

Hi Gheist,

Thank you very much for your quick response
I have checked blocksizes on both servers.. They are same.. And onconfig files on both servers are identical..
Actually I am following Administrators Guide for Informix Dynamic Server. In that there is chapter"Using High Availablity Data Replication".

Thanks and Regards,
Govind

 

[gheist]

Make tar backup on primary (tar cvf /dev/rmt9 /tmp) and test it on secondary ( tar tvf /dev/rmt9) to ensure tapes are ok

 

[gora]

Hi Gheist,

Thank you very much for quick response.

Instead of using ontape , now I have used onarchive to create a level-0 backup on my primary server using following command.
ARCHIVE/DBSPACESET=*
which is given in the Administrator's guide. It crearted archive successfully.

After that I tried to retrive from secondary server using ondatartr with following command..
RETRIEVE/DBSPACESET=*/REQUEST=2/TAPE=(primary:/dev/remotedrive)
according to Administrator's guide.
But it asking following question
What saveset ID is to be used on volume primary:/dev/remotedrive?
Could you please let me know what could be the problem here ..
Is this retrieve command is correct ?

Thanks in Advance,
Govind

 

[gora]

Hi,

When I use following command for the retrieve , I am getting following error.
Could you please let me know what could the problem.

Copyright (c) 1993,1994 - Informix Software, Inc.
ONDATARTR> RETRIEVE/DBSPACESET=*/REQUEST=2/DISK=(primary:/opt/informix/test)
Executing...
What saveset ID is to be used on volume primary:/opt/informix/test?:2

ARC-E-01827, Cannot define a remote node for a DISK device.
ARC-E-01040, File not found.


Thanks and Regards,
Govind

 

[gheist]

you need to use ONTAPE because oninit -r restores only this way

 

[gora]

Hi Gheist,

Now I have done archive using TAPE on my primary server called roadrun.
And tried to RETRIEVE from my secondary server called london using following command using ONDATARTR.

RETRIEVE/DBSPACESET=*/REQUEST=8/TAPE=(roadrun:/dev/rmt/0m)

Then I got error saying that
ARC-E-01342, Save-set file not found.
But Saveset file exists on roadrun..

Then I tried to recover from same server (roadrun) using following command
RETRIEVE/DBSPACESET=*/REQUEST=8/TAPE=(/dev/rmt/0m)
Then it worked fine and I could able to recover the data..

The problem is when I try to recover from the remote machine the problem is coming .
Do you have any idea on this problem ??

Thanks in Adavance ,
Govind

 

[gheist]

I've put ontape backup to remote NFS filesystem, then restored ftom that file with ontape - and made onmode adjustments quickly, it works for some 1/2 year now