Oninit cdi / Archive
Talk to an expert →

restoring to another server using psm

Posted in 2018

Topics: High Availability & Replication, Backup & Restore, Storage & Space Management, Versions, Editions & End-of-Life

KAMRAN HAQ — — source: IIUG Forums & Mailing Lists

We are using informix IDS 12.10.FC7. We use ontpe for backup and trying to replace it with onbar. When we tried to restore the backup taken from one server to another server,we are facing issues like shown in below bar_act.log: ----------------------------------------------------------------- 2018-03-22 13:28:58 20821 15788 onsmsync -I -p inst0006_01 2018-03-22 13:28:58 20821 15788 Using IBM's PSM version 12.10.FC7 as the Storage Manager. XBSA API version is 1.0.3. 2018-03-22 13:28:58 20821 15788 Successfully connected to Storage Manager. 2018-03-22 13:28:58 20821 15788 (-43050) Copy of old emergency bootfile saved in /u/informix12.10.FC7/etc/ixbar.6.20180322.132858 . 2018-03-22 13:28:58 20821 15788 Importing PSM object rootdbs_mcp:/u/ids_backup/m114extpool/inst0006_01/inst0006_01/rootdbs_mcp/0 2018-03-22 13:28:58 20821 15788 XBSA Error: (BSACreateObject) That object already exists. 2018-03-22 13:28:58 20821 15788 onsmsync complete, returning 13 (0x0d) ----------------------------------------------------------------- Configurations: BAR_BSALIB_PATH $INFORMIXDIR/lib/libbsapsm.so BAR_MAX_BACKUP 4 PSM_CATALOG_PATH /u/ids_backup/pcp PSM_DBS_POOL DBSPOOL PSM_LOG_POOL LOGPOOL $INFORMIXDIR/lib is added in LD_LIBRARY_PATH onpsm -D list ------------- Informix Primary Storage Manager Device List Type Prio Block/Size (MB) Pool Name Device Name FILE LOW --/-- DBSPOOL /u/informix12.10.FC7/backups FILE LOW --/-- LOGPOOL /u/informix12.10.FC7/backups FILE HIGHEST --/-- EXTPOOL /u/ids_backup/m114extpool Steps followed: We are trying to make an hdr, so on primary instance we take Level-0 backup onbar -b -L 0 Exported the backup onsmsync -E -p inst0006_01 -g 1 Copied he backup to other server cd /u/ids_backup/m114extpool scp -r inst0006_01 192.168.150.154:/u/ids_backup/m114extpool/ Importing the bacup onsmsync -I -p inst0006_01 At that step we are getting failure message Can you guide what we are missing?

↪ replying to KAMRAN HAQ
Alexandre Marini — — source: IIUG Forums & Mailing Lists

Hello my friend. I think you must have made some confusion. From the manual page: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.bar.doc/ids _bar_271.htm Onsmsync utility is used only for storage manager catalog, it is not made for backup/restore, required by HDR setup. Follow up this page, and you will be ready for HDR: https://www.ibm.com/support/knowledgecenter/en/SSGU8G_12.1.0/com.ibm.admin.doc/i ds_admin_0931.htm HTH Regards. Alexandre Marini IBM Informix Certified Professional v10 / v11.50 / v11.70 / v12.10 IBM Informix on Cloud - Database Administrator - 2017 IBM dashDB Managed Service for Analytics and Transactions - 2017 DB2 Advanced DBA - v10.5 for LUW IBM Information Management Informix Technical Professional IBM Certified Developer - Informix Genero Informix independent consultant ________________________________ De: ids-bounces@iiug.org <ids-bounces@iiug.org> em nome de KAMRAN HAQ <khaq@i2cinc.com> Enviado: quinta-feira, 22 de março de 2018 10:01 Para: ids@iiug.org Assunto: restoring to another server using psm [40912] We are using informix IDS 12.10.FC7. We use ontpe for backup and trying to replace it with onbar. When we tried to restore the backup taken from one server to another server,we are facing issues like shown in below bar_act.log: ----------------------------------------------------------------- 2018-03-22 13:28:58 20821 15788 onsmsync -I -p inst0006_01 2018-03-22 13:28:58 20821 15788 Using IBM's PSM version 12.10.FC7 as the Storage Manager. XBSA API version is 1.0.3. 2018-03-22 13:28:58 20821 15788 Successfully connected to Storage Manager. 2018-03-22 13:28:58 20821 15788 (-43050) Copy of old emergency bootfile saved in /u/informix12.10.FC7/etc/ixbar.6.20180322.132858 .. 2018-03-22 13:28:58 20821 15788 Importing PSM object rootdbs_mcp:/u/ids_backup/m114extpool/inst0006_01/inst0006_01/rootdbs_mcp/0 2018-03-22 13:28:58 20821 15788 XBSA Error: (BSACreateObject) That object already exists. 2018-03-22 13:28:58 20821 15788 onsmsync complete, returning 13 (0x0d) ----------------------------------------------------------------- Configurations: BAR_BSALIB_PATH $INFORMIXDIR/lib/libbsapsm.so BAR_MAX_BACKUP 4 PSM_CATALOG_PATH /u/ids_backup/pcp PSM_DBS_POOL DBSPOOL PSM_LOG_POOL LOGPOOL $INFORMIXDIR/lib is added in LD_LIBRARY_PATH onpsm -D list ------------- Informix Primary Storage Manager Device List Type Prio Block/Size (MB) Pool Name Device Name FILE LOW --/-- DBSPOOL /u/informix12.10.FC7/backups FILE LOW --/-- LOGPOOL /u/informix12.10.FC7/backups FILE HIGHEST --/-- EXTPOOL /u/ids_backup/m114extpool Steps followed: We are trying to make an hdr, so on primary instance we take Level-0 backup onbar -b -L 0 Exported the backup onsmsync -E -p inst0006_01 -g 1 Copied he backup to other server cd /u/ids_backup/m114extpool scp -r inst0006_01 192.168.150.154:/u/ids_backup/m114extpool/ Importing the bacup onsmsync -I -p inst0006_01 At that step we are getting failure message Can you guide what we are missing? ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary