Hi Paul,
Thanks for the response. After physical restore and promoting it to secondary(onmode -d secondary <primaryname>) - it is identifying the correct logical log to start the recovery but saying that "Checkpoint Record not Found in logical log" and then getting assert failure and eventually crashing.
I have restricted access to the environment and might have to wait for another 1 week before I can retry any alternate solution. As of now, the only thing I could suspect is that backup taken on primary is whole system backup (onbar -b -w) instead of standard full backup (onbar -b -L 0).
I might have to wait and see if someone else faced my situation.
21:04:52 Starting Log Position - 304338 0x370f018
21:04:54 DR: Cleared 353216 KB of logical log in 1 seconds.
21:04:56 Checkpoint Record not Found in Logical Log. <<<<------------------
21:04:57 DR_ERR set to -5
21:04:57 Assert Failed: DR: Log Record Apply Thread Exited Abnormally. Internal Error.
A restart of the database server shall be required to correct
this problem.
21:04:57 IBM Informix Dynamic Server Version 12.10.FC8W1XH
21:04:57 Who: Session(66, informix@, 0, 7000000782e9048)
Thread(197, dr_secapply, 7000000782a4ba8, 10)
File: hdr/hdrApply.c Line: 580
21:04:57 Results: Dynamic Server must abort
21:04:57 Action: Reinitialize shared memory
21:04:57 stack trace for pid 3998394 written to /usr/informix/tmp/af.4adec79
21:04:57 See Also: /usr/informix/tmp/af.4adec79, shmem.4adec79.0
21:05:22 Thread ID 197 will NOT be suspended because
it is a daemon.
21:05:22 hdr/hdrApply.c, line 580, thread 197, proc id 3998394, DR: Log Record Apply Thread Exited Abnormally. Internal Error.
A restart of the database server shall be required to correct
this problem.
.
21:05:22 Fatal error in ADM VP at mt.c:14414
21:05:22 Unexpected virtual processor termination: pid = 3998394, exit status = 0x1.
21:05:22 PANIC: Attempting to bring system down
------------------------------
Vijayanand Dhandapani
------------------------------
Original Message:
Sent: Sat July 10, 2021 07:44 PM
From: Paul Watson
Subject: Silly question on HDR setup
Never used onbar to set up HDR - the key is to stop the secondary completing logical recovery. After the restore you probably can do a oninit -PHY and the do the normal onmode commands.
Never tried with onbar but works with ontape
Cheers
Paul
Paul Watson
Oninit LLC
+1-913-387-7529
www.oninit.com
Oninit®️ is a registered trademark of Oninit LLC
Original Message:
Sent: 7/10/2021 7:25:00 PM
From: Vijayanand Dhandapani
Subject: Silly question on HDR setup
Hi Everyone,
Can we use the whole system backup (onbar -b-w) from Primary to do physical restore of HDR secondary instead of the standard level 0 backup (onbar -b -L 0).
------------------------------
Thanks & Regards
Vijayanand Dhandapani.
------------------------------
#Informix