PRI/HDR/RSS logical recovery from logical log backups using PSM
Answered: green (solid confidence) — Art Kagel clarified that onsmsync can only export entire backup sets, not individual logical logs, and recommended re-establishing the primary with ifxclone and keeping several days of logical logs. The asker thanked him.
Advisory only.
Posted in 2024
Milan Rafaj asked whether onsmsync can export only specific logical logs from PSM, to recover a former primary from HDR backups. Art Kagel first pointed to onbar -r -l, then confirmed that onsmsync exports only whole backup sets. He advised using ifxclone to re-establish the old primary as secondary and keeping several days of logical logs. Milan noted the customer uses a Connection Manager.
Topics: High Availability & Replication, Logging & Checkpoints, Clustering, Grid & MACH11
Hi all, My customer plans to backup MACH11 cluster using PSM. What procedure should be used if secondary server requires logical logs from "tape" using onpsm/onsmsync? Is it possible to export/import only logical logs from PSM using onsmsync or onsmsync -E -p xxx to export backup and related logs is the only possibility (backup might be huge)? Thank you Milan Rafaj -- Unless stated otherwise above: Kyndryl Česká republika, spol. s r. o. Sídlo: V Parku 2308/8, Chodov, 148 00 Praha 4, IČ: 096 28 886 Zapsaná v obchodním rejstříku, vedeném Městským soudem v Praze (oddíl C, vložka 339277) Registered address: V Parku 2308/8, Chodov, 148 00 Prague 4 Company ID: 096 28 886 Registered in the Commercial Register maintained by the Municipal Court in Prague (Part C, Entry 339277)
Milan:
PSM is the default storage engine for onbar, the more advanced of the Informix backup utilities. You perform a logical recovery following a physical restore simply by using onbar -r -l optionally with the -t <timestamp> or -n <logid>
Read up on onbar in the online Informix manuals or the PDF version of the Backup and Restore manual.
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------
Hello Art,
I was probably not cleared. I meant to use onbar with PSM for recovering former Primary server back to its role when some logical logs backed up by HDR (now primary) are no more available on HDR server and must be recovered from logical logs backups done on HDR.
I am asking if there is a way how to export using onsmsync -E only missing logical logs and not the whole backup set covering last backup and logical logs since that as
onsmsync -E -p prefix -g 1 exports the whole backup set. This can be many gigabytes - and takes time and space to export, if I need, for example, only 2-3 logical logs which are not available on HDR server logical log dbspace any more.
Milan Rafaj
--
Unless stated otherwise above:
Kyndryl Česká republika, spol. s r. o.
Sídlo: V Parku 2308/8, Chodov, 148 00 Praha 4,
IČ: 096 28 886
Zapsaná v obchodním rejstříku, vedeném Městským soudem v Praze (oddíl C, vložka 339277)
Registered address: V Parku 2308/8, Chodov, 148 00 Prague 4
Company ID: 096 28 886
Registered in the Commercial Register maintained by the Municipal Court in Prague (Part C, Entry 339277)
Milan: Ahh, gotya. So, no. The onsmsync can only export entire backup sets. The best solution for you will be to use ifxclone to reestablish the original primary as the HDR secondary the swap roles. For the future, make sure that you have at least four days' worth of logical logs to minimize the possibility that you will have a primary or secondary down for long enough that the oldest log needed for recovery is no longer online. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------
Thank you Art, customer is using CM to manage the cluster. And thank you for a tip to configure logical logs covering sufficient number of days. Milan Rafaj Senior Lead, Infrastructure/Cloud Architecture Kyndryl Consult +420 737 264 248 www.kyndryl.cz Planned absence/Plánovaná nepřítomnost: 27.3.2024 Kyndryl Česká republika, spol. s r. o. Sídlo: Praha 4, Chodov, V Parku 2308/8, PSČ: 148 00, IČ: 14890992 Zapsaná v obchodním rejstříku, vedeném Městským soudem v Praze (oddíl C, vložka 339277) Registered address: Prague 4, Chodov, V Parku, 2308/8, Zip code: 148 00 Company ID: 14890992 Entered in the Commercial Register maintained by the Municipal Court in Prague (Part C, Entry 339277) --