cancel
Showing results for 
Search instead for 
Did you mean: 

Disaster Recovery or Business Continuity for IQ

0 Kudos

As the replication server can´t have SAP IQ as a data source, only as a target, which is the option for having a SAP IQ Standby with the data synchronized

Accepted Solutions (0)

Answers (1)

Answers (1)

markmumy
Advisor
Advisor
0 Kudos

IQ customers will either use standard database backups for HA and DR or 3rd party utilities.  The BACKUP/RESTORE method works quite well if you have a smaller database (sub 5-10 TB) and can handle the time it takes to write it to disk.

Additionally, we integrate with 3rd party hardware and software vendors.  Most of the larger IQ sites will leverage storage replication for their HA and DR needs.  IQ can launch the commands to sync and split the replication images, etc as part of the backup operation.  This has been in place for 15 years now and is widely used.

The docs will reference an ENCAPSULATED and DECOUPLED backup as part of the BACKUP syntax.  This is how you would leverage storage replication.

SAP also has a partner that helped pioneer the technology and is quite versed in the various storage frameworks on the market and how to efficiently tap into them to build a sounds HA/DR framework.

Mark

Former Member
0 Kudos

Hi Mark,

I am also planning the DR implementation for IQ NLS. I have a few questions regarding the two options on that you provide:

1) Backup/Restore method, I know IQ 16SP10 has PITR recovery, can we do the initial full backup restore at DR site, then shipping PITR log to the DR site and restore to a point in time frequently (e.g. if shipped PITR log file at several GB), to keep DR site in sync with Primary IQ site.

2) Storage Replication: Is this option suitable for a remote DR site, I mean DR site and Primary site are not in the same location, I am sure if the storage clone can be used in such case. As you said this has been there for a long time, do you have any document that we can refer for such implementation  with HANA/IQ NLS?

Thanks!

hans-juergen_schwindke
Active Participant

Hi,

usually you do not need PITR for NLS. The SAP NLS solution performs an incremental backup during archiving. The process is like this: data is copied from the primary database to NLS/IQ. Then an incremental backup is done. Only if this backup is successful, data is deleted from the primary database.

Consequently each data change is backed up. So the incrementals are sufficient and PITR is not required.

Coming back to your first question: yes this is possible but you take the incrementals instead of the PITR.

Best regards,

Juergen

Former Member
0 Kudos

Thank you Juergen for the answer.

Xiang