[IQUG] IQUG Digest, Vol 61, Issue 17

Steve Shen sshen at sscinc.com
Tue Jan 23 08:43:12 MST 2018


I am adding one more topic below.  Refer to topic #3.

Today's Topics:

   1. Re: How to restore full database and transaction backups  from
      an IQ Simplex to an IQ Multiplex? (Ron Watkins)
   2. Re: How to restore full database and transaction backups from
      an IQ Simplex to an IQ Multiplex? (Steve Shen)
  3. How to restore the full backups from the coordinator machine to an Simplex?

Assuming that I had an IQ Multiplex with the coordinator M1 and the reader node M2, can I take the full backups from M1 and restore the backups to an IQ Simplex machine S?

In my understanding this cannot be done unless I change the IQ Multiplex (M1 + M2) to Simplex (M1) first before taking the full backups.

Please advise.  Thank you.

Regards,

Steve Shen

-----Original Message-----
From: iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org] On Behalf Of iqug-request at iqug.org
Sent: Tuesday, January 23, 2018 10:29 AM
To: iqug at iqug.org
Subject: IQUG Digest, Vol 61, Issue 17

Send IQUG mailing list submissions to
        iqug at iqug.org

To subscribe or unsubscribe via the World Wide Web, visit
        http://iqug.org/mailman/listinfo/iqug
or, via email, send a message with subject or body 'help' to
        iqug-request at iqug.org

You can reach the person managing the list at
        iqug-owner at iqug.org

When replying, please edit your Subject line so it is more specific than "Re: Contents of IQUG digest..."


Today's Topics:

   1. Re: How to restore full database and transaction backups  from
      an IQ Simplex to an IQ Multiplex? (Ron Watkins)
   2. Re: How to restore full database and transaction backups from
      an IQ Simplex to an IQ Multiplex? (Steve Shen)


----------------------------------------------------------------------

Message: 1
Date: Tue, 23 Jan 2018 08:15:04 -0700
From: "Ron Watkins" <rwatkins at dssolutions.com>
To: "'Steve Shen'" <sshen at sscinc.com>,  <iqug at iqug.org>
Subject: Re: [IQUG] How to restore full database and transaction
        backups from an IQ Simplex to an IQ Multiplex?
Message-ID: <012f01d3945c$f2830050$d78900f0$@dssolutions.com>
Content-Type: text/plain; charset="us-ascii"

Further notes.

The "restore" operation will require the exact same lun layout on the target node as on the source node. It will not use existing storage resources unless the have the exact same naming convention.

In addition, you will be able to "name" the restored server "M1" as you suggest, but it will be a simplex node at the time of the restore.

Also, once you perform the restore, if you wish to apply incrementals, you cannot start the restored server as it will change the "state" of the server and prevent application of additional incrementals.

Ron



From: Steve Shen [mailto:sshen at sscinc.com]
Sent: Tuesday, January 23, 2018 7:56 AM
To: 'Ron Watkins'; iqug at iqug.org
Subject: RE: [IQUG] How to restore full database and transaction backups from an IQ Simplex to an IQ Multiplex?



Hi Ron,



It's very interesting!  You have answered my question.



Thank you very much.



Regards,

Steve Shen

From: Ron Watkins [mailto:rwatkins at dssolutions.com]
Sent: Tuesday, January 23, 2018 9:50 AM
To: Steve Shen; iqug at iqug.org
Subject: RE: [IQUG] How to restore full database and transaction backups from an IQ Simplex to an IQ Multiplex?



No, when you "restore", you will get a copy of the simplex server. After the restore, you can "add" the second node to make it a multiplex.

The "restore" is done using the utility database, so the target server is a complete copy of the source server. It doesn't restore into an existing simple or multiplex server, but over-writes and creates a new stand-alone server.

Ron



From: iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org] On Behalf Of Steve Shen
Sent: Tuesday, January 23, 2018 6:49 AM
To: iqug at iqug.org
Subject: [IQUG] How to restore full database and transaction backups from an IQ Simplex to an IQ Multiplex?



Subject:

How to restore a full database dumps from an IQ Simplex to an IQ Multiplex?

                How to restore transaction dumps from an IQ Simplex to an IQ Multiplex?



Assuming that I have an IQ Simplex machine name S and an IQ Multiplex with two nodes, coordinator node M1 and reader node M2.



If I take the full backups from the Simplex machine S, is it possible to restore the backups to the coordinator node M1?



If I take transaction dumps from the Simplex machine S, is it possible to restore the transaction backups to the coordinator node M1?



If I change the Multiplex (M1 + M2) to Simplex (M1), I will be able to load the full and transaction backups from S; but I am wondering whether I can avoid this step because I will have to convert it to Multiplex again.



Please advise.  Thank you.



Regards,

Steve Shen



This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the
addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto.

This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the
addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20180123/4fd66f8b/attachment-0001.html>

------------------------------

Message: 2
Date: Tue, 23 Jan 2018 15:29:15 +0000
From: Steve Shen <sshen at sscinc.com>
To: 'Ron Watkins' <rwatkins at dssolutions.com>, "iqug at iqug.org"
        <iqug at iqug.org>
Subject: Re: [IQUG] How to restore full database and transaction
        backups from an IQ Simplex to an IQ Multiplex?
Message-ID:
        <0C03FF7E7FA66E41A61525750FD653399035EEF7 at ykt1emxprd6.globeop.com>
Content-Type: text/plain; charset="us-ascii"

Hi Ron,

Thank you very much again.

Regards,
Steve Shen
From: Ron Watkins [mailto:rwatkins at dssolutions.com]
Sent: Tuesday, January 23, 2018 10:15 AM
To: Steve Shen; iqug at iqug.org
Subject: RE: [IQUG] How to restore full database and transaction backups from an IQ Simplex to an IQ Multiplex?

Further notes...
The "restore" operation will require the exact same lun layout on the target node as on the source node. It will not use existing storage resources unless the have the exact same naming convention.
In addition, you will be able to "name" the restored server "M1" as you suggest, but it will be a simplex node at the time of the restore.
Also, once you perform the restore, if you wish to apply incrementals, you cannot start the restored server as it will change the "state" of the server and prevent application of additional incrementals.
Ron

From: Steve Shen [mailto:sshen at sscinc.com]
Sent: Tuesday, January 23, 2018 7:56 AM
To: 'Ron Watkins'; iqug at iqug.org<mailto:iqug at iqug.org>
Subject: RE: [IQUG] How to restore full database and transaction backups from an IQ Simplex to an IQ Multiplex?

Hi Ron,

It's very interesting!  You have answered my question.

Thank you very much.

Regards,
Steve Shen
From: Ron Watkins [mailto:rwatkins at dssolutions.com]
Sent: Tuesday, January 23, 2018 9:50 AM
To: Steve Shen; iqug at iqug.org<mailto:iqug at iqug.org>
Subject: RE: [IQUG] How to restore full database and transaction backups from an IQ Simplex to an IQ Multiplex?

No, when you "restore", you will get a copy of the simplex server. After the restore, you can "add" the second node to make it a multiplex.
The "restore" is done using the utility database, so the target server is a complete copy of the source server. It doesn't restore into an existing simple or multiplex server, but over-writes and creates a new stand-alone server.
Ron

From: iqug-bounces at iqug.org<mailto:iqug-bounces at iqug.org> [mailto:iqug-bounces at iqug.org] On Behalf Of Steve Shen
Sent: Tuesday, January 23, 2018 6:49 AM
To: iqug at iqug.org<mailto:iqug at iqug.org>
Subject: [IQUG] How to restore full database and transaction backups from an IQ Simplex to an IQ Multiplex?

Subject:
How to restore a full database dumps from an IQ Simplex to an IQ Multiplex?
                How to restore transaction dumps from an IQ Simplex to an IQ Multiplex?

Assuming that I have an IQ Simplex machine name S and an IQ Multiplex with two nodes, coordinator node M1 and reader node M2.

If I take the full backups from the Simplex machine S, is it possible to restore the backups to the coordinator node M1?

If I take transaction dumps from the Simplex machine S, is it possible to restore the transaction backups to the coordinator node M1?

If I change the Multiplex (M1 + M2) to Simplex (M1), I will be able to load the full and transaction backups from S; but I am wondering whether I can avoid this step because I will have to convert it to Multiplex again.

Please advise.  Thank you.

Regards,
Steve Shen

This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto.
This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto.
This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20180123/b99afaae/attachment.html>

------------------------------

_______________________________________________
IQUG mailing list
IQUG at iqug.org
http://iqug.org/mailman/listinfo/iqug

End of IQUG Digest, Vol 61, Issue 17
************************************
This email with all information contained herein or attached hereto may contain confidential and/or privileged information intended for the addressee(s) only. If you have received this email in error, please contact the sender and immediately delete this email in its entirety and any attachments thereto.


More information about the IQUG mailing list