Dear Mike,
Thanks for Steps. I followed in the same way , but still it is showing FAST RECOVERY<sec>
online.log
11:55:27 Maximum server connections 0
11:56:36 DR: Reservation of the last logical log for log backup turned off
11:56:36 DR: new type = secondary, primary server name = on_nebula31
11:56:36 SDS: No server name was found in either DBSERVERNAME or DBSERVERALIASES that
can be used by SDS servers to connect to this server.
11:56:36 DR: Could not set the disk owner information in the reserved pages.
And moreover when I take the full backup on primary and scp to secondary and run ontape -p , restore fails.. So I rename the backup file manually.
informix@sk-om-ifx-401:/backup/tapedev> ontape -p
Restore file /backup/tapedev/sk-om-ifx-401_1_L0 and press Return to continue ...
File /backup/tapedev/sk-om-ifx-401_1_L0 not found, continuing ...
Physical restore failed - function open tape device /backup/tapedev/ failed code -1 errno 2
Program over.
informix@sk-om-ifx-401:/backup/tapedev> cp sk-om-ifx-402_1_L0 sk-om-ifx-401_1_L0
informix@sk-om-ifx-401:/backup/tapedev> cp sk-om-ifx-402_1_L0 sk-om-ifx-401_1_L0
informix@sk-om-ifx-401:/backup/tapedev> onstat -
shared memory not initialized for INFORMIXSERVER 'on_nebula21'
informix@sk-om-ifx-401:/backup/tapedev> ontape -p
Restore file /backup/tapedev/sk-om-ifx-401_1_L0 and press Return to continue ...
after Restore done.
informix@sk-om-ifx-401:/backup/tapedev> onstat -
IBM Informix Dynamic Server Version 11.50.UC1 -- Fast Recovery -- Up 00:00:58 -- 145208 Kbytes
informix@sk-om-ifx-401:/backup/tapedev> onmode -d secondary on_nebula31
informix@sk-om-ifx-401:/backup/tapedev> onstat -
IBM Informix Dynamic Server Version 11.50.UC1 -- Fast Recovery (Sec) -- Up 00:01:24 -- 145208 Kbytes
------------------------------
AMIT PATEL
------------------------------
Original Message:
Sent: Sun February 21, 2021 11:37 PM
From: Mike Walker
Subject: HDR
The secondary MUST be OFFLINE when you do the restore (a COLD restore).
The restore of the secondary must use the backup that was taken from the Primary, so the backup MUST be copied over to the secondary BEFORE you begin the restore.
Basically it should be similar to the following:
Secondary:
onmode -ky
Primary:
ontape -s -L 0
scp archive file to secondary
Secondary:
Make sure backup from the primary is available and will be referenced by the restore...
ontape -p
When restore is complete...
Primary:
onmode -d primary <sec_server>
Secondary:
onmode -d secondary <pri_server>
------------------------------
Mike Walker
Original Message:
Sent: Sun February 21, 2021 11:05 PM
From: AMIT PATEL
Subject: HDR
Hi Mike,
I took both servers on ONLINE mode amd started the process from starting.
Primary -
BACKUP --> ontape -s -L 0;
MODE --> onmode -d primary <sec_server>
STATUS --> -- On-Line (Prim)
ONLINE LOG --> 09:37:09 DR: Cannot connect to secondary server
09:37:09 DR: Turned off on primary server
SECONDARY
RESTORE --> ontape -p
MODE --> onmode -d secondary <prim_server>
ERROR --> DR: Unable to change server type
onmode: Please check the message log for errors.
STATUS --> -- On-Line -- (No Read_only <Sec>)
ONLINE LOG --> 09:35:35 Booting Language <spl> from module <>
09:35:35 Loading Module <SPLNULL>
09:35:35 SCHAPI: 'sysadmin' database setup is incomplete. (No idea if something linked with sysadmin error)
09:35:35 SCHAPI: Failed to setup dbScheduler thread.
09:35:36 On-Line Mode
09:38:05 DR: Server not in quiescent mode ( Don't know why it stuck here).
First I just run the ontape -s -L 0 on primary and ontape -p on secondary without copying the backup file on secondary.
and then scp backup file to secondary and followed the step again.
Attached word file.
Kindly check and help.
------------------------------
AMIT PATEL
Original Message:
Sent: Sun February 21, 2021 08:07 PM
From: Mike Walker
Subject: HDR
The onmode -d secondary <primary> MUST be done after the physical restore is done and BEFORE any onmode -m or oninit commands are executed on the restored server. If you do not do this, there will be activity in the logs of the restored server and you will not be able to establish replication. As Casey said, you will need to perform the restore again.
------------------------------
Mike Walker
Original Message:
Sent: Sun February 21, 2021 07:26 PM
From: AMIT PATEL
Subject: HDR
Yes Mark, Initially I was running only "onmode -d secondary <Prim-servrr>" , but when Didn't get proper results so I tried with oninit -PHY..
ALL ONCONFIG parameters n dbspaces are same even.
Regards
Amit
------------------------------
AMIT PATEL
Original Message:
Sent: Sun February 21, 2021 02:14 PM
From: Mike Walker
Subject: HDR
Maybe I am wrong, but it looks like you tried to bring up the secondary server. I would not expect the "On-Line Mode" message on the secondary.
The restore you performed must be a physical only. When the physical restore is done, do NOTissue any oninit commands, or onmode -m or anything else but only:
onmode -d secondary <primary_name>
------------------------------
Mike Walker
Original Message:
Sent: Sun February 21, 2021 01:08 PM
From: AMIT PATEL
Subject: HDR
Hello all,
I'm doing the HDR setup on my personal laptop with IDS 11.50(OLD ONE) for learning purpose.
I created two server on VMWARE and did FIREWALL off and both server can ping to each other.
I'm facing problem when I go to create 2ndary Server. I've attached the doc for the same.
Kindly let me know , where I'm making mistake.
I've done the setting thru /etc/hosts . No entry I made in /etc/services and /etc/hosts.equiv.
Kindly assist.
Thanks
Amit patel
------------------------------
AMIT PATEL
------------------------------
#Informix