[IQUG] IQUG Digest, Vol 61, Issue 16

Ron Watkins rwatkins at dssolutions.com
Wed Jan 31 13:26:38 MST 2018


Also, be aware that when you perform a "restore" operation in DR, once you
"start" the DR IQ node (for any reason, such as DBCC or other checks), you
are required to resume restores using a fresh FULL dump, you can no-longer
apply incrementals once you have started the IQ DR server as the state of
the devices is changed by the startup.

Ron

 

From: Steve Shen [mailto:sshen at sscinc.com] 
Sent: Wednesday, January 31, 2018 1:05 PM
To: 'Ron Watkins'; iqug at iqug.org
Subject: RE: IQUG Digest, Vol 61, Issue 16

 

Hi Ron,

 

You are correct in terms of using the terminology on full and incremental
backups in IQ instead of log-shipping.

 

Senior Unix SAs were afraid of potential concurrent disk corruptions.  They
had decided not considering Snap/Clone HW replications.

 

Thank you.

 

Regards,

Steve Shen

From: Ron Watkins [mailto:rwatkins at dssolutions.com] 
Sent: Wednesday, January 31, 2018 2:54 PM
To: Steve Shen; iqug at iqug.org
Subject: RE: IQUG Digest, Vol 61, Issue 16

 

FYI, there is no such thing as log shipping in IQ.

Your only options are:

1)      Full/Incremental dump/restore (somewhat slow).

2)      Snap/Clone using HW to replicate IQ quickly.

Ron

 

From: Steve Shen [mailto:sshen at sscinc.com] 
Sent: Wednesday, January 31, 2018 12:24 PM
To: iqug at iqug.org; 'Ron Watkins'
Subject: RE: IQUG Digest, Vol 61, Issue 16

 

Hi all,

 

I am  appending one more sub-topic:

4. How to take full and transaction dumps from an Multiplex with the
Coordinator node and the Writer Node and restore them to the DR Multiplex
with two nodes using log shipping?

 

Assuming that I have the primary Multiplex with the Coordinator node (PC)
and the Writer Node (PW) and the DR Multiplex with (DC) and (DW) machine
names, how do I restore full backups and transaction backups from the
primary Multiplex to the DR Multiplex?  Of course we have only utility_db
running in either DC and DW hosts.

 

Please advise.  Thank you.

 

Regards,

Steve Shen
_____________________________________________
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 9:56 AM
To: iqug at iqug.org
Subject: IQUG Digest, Vol 61, Issue 16

 

 

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. How to restore full database and transaction backups from an

      IQ Simplex to an IQ Multiplex? (Steve Shen)

   2. Re: How to restore full database and transaction backups  from

      an IQ Simplex to an IQ Multiplex? (Ron Watkins)

   3. 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 13:49:06 +0000

From: Steve Shen <sshen at sscinc.com>

To: "iqug at iqug.org" <iqug at iqug.org>

Subject: [IQUG] How to restore full database and transaction backups

        from an IQ Simplex to an IQ Multiplex?

Message-ID:

        <0C03FF7E7FA66E41A61525750FD653399035E00E at ykt1emxprd6.globeop.com>

Content-Type: text/plain; charset="us-ascii"

 

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.

-------------- next part --------------

An HTML attachment was scrubbed...

URL:
<http://iqug.org/pipermail/iqug/attachments/20180123/8326daa2/attachment-000
1.html>

 

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

 

Message: 2

Date: Tue, 23 Jan 2018 07:50:08 -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: <00e801d39459$76f2f330$64d8d990$@dssolutions.com>

Content-Type: text/plain; charset="us-ascii"

 

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. 

 

-------------- next part --------------

An HTML attachment was scrubbed...

URL:
<http://iqug.org/pipermail/iqug/attachments/20180123/a41e85d5/attachment-000
1.html>

 

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

 

Message: 3

Date: Tue, 23 Jan 2018 14:56:10 +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:

        <0C03FF7E7FA66E41A61525750FD653399035EA17 at ykt1emxprd6.globeop.com>

Content-Type: text/plain; charset="us-ascii"

 

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%3cmailto: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%3cmailto: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.

-------------- next part --------------

An HTML attachment was scrubbed...

URL:
<http://iqug.org/pipermail/iqug/attachments/20180123/43c59c5a/attachment.htm
l>

 

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

 

_______________________________________________

IQUG mailing list

 <mailto:IQUG at iqug.org> IQUG at iqug.org

 <http://iqug.org/mailman/listinfo/iqug>
http://iqug.org/mailman/listinfo/iqug

 

End of IQUG Digest, Vol 61, Issue 16

************************************

 

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/20180131/454968e2/attachment-0001.html>


More information about the IQUG mailing list