[IQUG] Restoring Incremental backups between IQ 15.2 and IQ 15.4

Louie, David David.Louie at blackrock.com
Thu Oct 9 11:53:35 MST 2014


Just did the same test on a small IQ 15.2 server and both restore full and restore incremental worked too.

Will run the restore validate as you suggested Mark as I too think there is something wrong with my backups.

From: Louie, David
Sent: Thursday, October 09, 2014 2:23 PM
To: 'Mumy, Mark'; 'Brookman-Amissah, Joseph'; 'iqug at dssolutions.com'
Subject: RE: Restoring Incremental backups between IQ 15.2 and IQ 15.4

I did  a test on another small server ( it’s IQ 16.0 not 15.4 though) and was able to backup “FULL” and then backup ‘INCREMENTAL” and then do the full and incremental restores.

backup database full to '/var/tmp/NDHADM_DEV_IQ.dbdmp.2014109135150.FULL'

backup database incremental '/var/tmp/NDHADM_DEV_IQ.dbdmp.2014109135150.INCR'



1> RESTORE DATABASE '/usr/local/sybase16/IQ-16_0/ndhadm_dev_iq/ndhadm_dev_iq.db'
2> from '/var/tmp/NDHADM_DEV_IQ.dbdmp.2014109135150.FULL'
3> go


1> RESTORE DATABASE '/usr/local/sybase16/IQ-16_0/ndhadm_dev_iq/ndhadm_dev_iq.db'
2> from '/var/tmp/NDHADM_DEV_IQ.dbdmp.2014109135150.INCR'
3> go

Total number of IQ blocks being restored: 1100535
Total number of IQ blocks being restored: 1150560
Total number of IQ blocks being restored: 1200585
Total number of IQ blocks being restored: 1250610
Total number of IQ blocks being restored: 1300624
Total number of IQ blocks restored: 1309792  at 2014-10-09 18:06:04
    IQ blocksize = 8192
    backup blocksize = 8232
    blocking factor = 25
    buffersize = 205816
Total number of IQ blocks restored: 3794  at 2014-10-09 18:07:49
    IQ blocksize = 8192
    backup blocksize = 8232
    blocking factor = 25
    buffersize = 205816





From: Louie, David
Sent: Thursday, October 09, 2014 1:40 PM
To: 'Mumy, Mark'; Brookman-Amissah, Joseph; iqug at dssolutions.com<mailto:iqug at dssolutions.com>
Subject: RE: Restoring Incremental backups between IQ 15.2 and IQ 15.4

We do


1)     Backup database FULL

2)     Backup database incremental

This script has been in place for years.  I was able to restore FULL backups then subsequent incrementals produced by this script before.

David


From: Mumy, Mark [mailto:mark.mumy at sap.com]
Sent: Thursday, October 09, 2014 11:43 AM
To: Louie, David; Brookman-Amissah, Joseph; iqug at dssolutions.com<mailto:iqug at dssolutions.com>
Subject: RE: Restoring Incremental backups between IQ 15.2 and IQ 15.4

David,

What are the different backups that you are doing?  Is it a full then incremental since full?  Or do you have multiple incrementals (not since full) in there?

Mark

Mark Mumy
Director, Enterprise Architecture, SAP HANA GCoE
M +1 347-820-2136 | E mark.mumy at sap.com<mailto:mark.mumy at sap.com>
My Blogs: http://scn.sap.com/people/markmumy/blog

https://sap.na.pgiconnect.com/I825063
Conference tel: 18663127353,,7090196396#

[Description: Description: Description: Description: Description: sap_09_logo.JPG]

From: Louie, David [mailto:David.Louie at blackrock.com]
Sent: Thursday, October 09, 2014 09:20
To: Brookman-Amissah, Joseph; Mumy, Mark; iqug at dssolutions.com<mailto:iqug at dssolutions.com>
Subject: RE: Restoring Incremental backups between IQ 15.2 and IQ 15.4

RESTORE DATABASE 'db_file'
    'archive_device' [ FROM 'archive_device' ]…
   … [ CATALOG ONLY ]
   … [ KEY key_spec ]
   … [ [ RENAME logical-dbfile-name TO 'new-dbspace-path']...
       | VERIFY [ COMPATIBLE ] ]
Syntax 2
RESTORE DATABASE 'database-name'
   [ restore-option ... ]
   FROM 'archive_device' ...

restore-option:
   READONLY dbspace-or-file [, … ]
   KEY key_spec
   RENAME file-name TO new-file-path ...


There is nothing in the doc which suggest I need INCREMENTAL SINCE FULL in the restore command.

This is only used in the BACKUP command.

David


From: Louie, David
Sent: Thursday, October 09, 2014 10:18 AM
To: 'Brookman-Amissah, Joseph'; Mumy, Mark; iqug at dssolutions.com<mailto:iqug at dssolutions.com>
Subject: RE: Restoring Incremental backups between IQ 15.2 and IQ 15.4

Hi Joseph.

I just posed this question to SAP tech support (whether I’m missing something in the syntax).

I’ll try this.

David

From: Brookman-Amissah, Joseph [mailto:Joseph.Brookman-Amissah at SAPNS2.com]
Sent: Thursday, October 09, 2014 10:14 AM
To: Louie, David; Mumy, Mark; iqug at dssolutions.com<mailto:iqug at dssolutions.com>
Subject: RE: Restoring Incremental backups between IQ 15.2 and IQ 15.4

Try using

restore backup 'INCREMENTAL SINCE FULL'




From: iqug-bounces at iqug.org<mailto:iqug-bounces at iqug.org> [mailto:iqug-bounces at iqug.org] On Behalf Of Louie, David
Sent: Thursday, October 09, 2014 9:35 AM
To: Mumy, Mark; iqug at dssolutions.com<mailto:iqug at dssolutions.com>
Subject: Re: [IQUG] Restoring Incremental backups between IQ 15.2 and IQ 15.4

I reloaded the backup into the target as 15.2 and the first incremental.

Still encountered this error.

$ isql -Udba -Psql -S utility_db -i loadit_inc1
Msg 21, Level 14, State 0:
SQL Anywhere Error -1012009: This restore cannot immediately follow the previous
restore.
-- (db_backupID.cxx 632)
$ more loadit_inc1
RESTORE DATABASE '/usr/local/sybase15/IQ-15_2/ndhadm_iq/ndhadm_iq.db'
from '/mnt/incrementals/sybdump1/NDHARC_IQ.dbdmp.20141064024.INCRE'
from '/mnt/incrementals/sybdump2/NDHARC_IQ.dbdmp.20141064024.INCRE'
from '/mnt/incrementals/sybdump3/NDHARC_IQ.dbdmp.20141064024.INCRE'
from '/mnt/incrementals/sybdump4/NDHARC_IQ.dbdmp.20141064024.INCRE'
from '/mnt/incrementals/sybdump5/NDHARC_IQ.dbdmp.20141064024.INCRE'
from '/mnt/incrementals/sybdump6/NDHARC_IQ.dbdmp.20141064024.INCRE'
go
$

Should I redo the full and start again?

Thanks
David


From: Mumy, Mark [mailto:mark.mumy at sap.com]
Sent: Wednesday, October 08, 2014 2:17 PM
To: Louie, David; iqug at dssolutions.com<mailto:iqug at dssolutions.com>
Subject: RE: Restoring Incremental backups between IQ 15.2 and IQ 15.4

AH, ok.  I would try a restore with 15.2 to make sure that it works all the way through.  If so, then the issue is with restoring a 15.2 database into 15.4.

Mark

Mark Mumy
Director, Enterprise Architecture, SAP HANA GCoE
M +1 347-820-2136 | E mark.mumy at sap.com<mailto:mark.mumy at sap.com>
My Blogs: http://scn.sap.com/people/markmumy/blog

https://sap.na.pgiconnect.com/I825063
Conference tel: 18663127353,,7090196396#

[Description: Description: Description: Description: Description: sap_09_logo.JPG]

From: Louie, David [mailto:David.Louie at blackrock.com]
Sent: Wednesday, October 08, 2014 13:10
To: Mumy, Mark; iqug at dssolutions.com<mailto:iqug at dssolutions.com>
Subject: RE: Restoring Incremental backups between IQ 15.2 and IQ 15.4

No that’s a month ago after I loaded just the FULL to test out the restore from 15.2 --> 15.4

This time around I didn’t bring the newly loaded 15.4 up since the catalog would be invalidated,etc..

From: Mumy, Mark [mailto:mark.mumy at sap.com]
Sent: Wednesday, October 08, 2014 2:05 PM
To: Louie, David; iqug at dssolutions.com<mailto:iqug at dssolutions.com>
Subject: RE: Restoring Incremental backups between IQ 15.2 and IQ 15.4

OK, so you started the restored database and ran an alter database upgrade??  If so, that would invalidate the catalog from future restores as you have changed it so that it is no longer in sync with the primary system to be backed up.

Mark

Mark Mumy
Director, Enterprise Architecture, SAP HANA GCoE
M +1 347-820-2136 | E mark.mumy at sap.com<mailto:mark.mumy at sap.com>
My Blogs: http://scn.sap.com/people/markmumy/blog

https://sap.na.pgiconnect.com/I825063
Conference tel: 18663127353,,7090196396#

[Description: Description: Description: Description: Description: sap_09_logo.JPG]

From: Louie, David [mailto:David.Louie at blackrock.com]
Sent: Wednesday, October 08, 2014 13:01
To: Mumy, Mark; iqug at dssolutions.com<mailto:iqug at dssolutions.com>
Subject: RE: Restoring Incremental backups between IQ 15.2 and IQ 15.4

Yes Mark. That’s what I’m doing now so verify the backups.

The full backups definitely work between 15.2--> 15.4.  I ran the alter database upgrade after the full backup restore the one time I did this.

As we are doing the final data sync between the 15.2 and 15.4 I wanted to do my full followed by the incrementals and now running into this issue.

Thanks
David

From: Mumy, Mark [mailto:mark.mumy at sap.com]
Sent: Wednesday, October 08, 2014 1:01 PM
To: Louie, David; iqug at dssolutions.com<mailto:iqug at dssolutions.com>
Subject: RE: Restoring Incremental backups between IQ 15.2 and IQ 15.4

David,

I don’t know that we support backing up from one version and restoring to another.  Typically, we see the same major/minor version being used on both sides.

Can you try this with 15.2 on the target to make sure that it isn’t an issue with the backups, etc?

Mark

Mark Mumy
Director, Enterprise Architecture, SAP HANA GCoE
M +1 347-820-2136 | E mark.mumy at sap.com<mailto:mark.mumy at sap.com>
My Blogs: http://scn.sap.com/people/markmumy/blog

https://sap.na.pgiconnect.com/I825063
Conference tel: 18663127353,,7090196396#

[Description: Description: Description: Description: Description: sap_09_logo.JPG]

From: iqug-bounces at iqug.org<mailto:iqug-bounces at iqug.org> [mailto:iqug-bounces at iqug.org] On Behalf Of Louie, David
Sent: Wednesday, October 08, 2014 11:56
To: iqug at dssolutions.com<mailto:iqug at dssolutions.com>
Subject: [IQUG] Restoring Incremental backups between IQ 15.2 and IQ 15.4

I have completed a FULL restore from a 15.2 source to a 15.4 target however when applying the first INCREMENTAL backup it fails with:

$ isql -Udba -Psql -S utility_db -i loadit_inc
Msg 21, Level 14, State 0:
SQL Anywhere Error -1012009: This restore cannot immediately follow the
previous
restore.
-- (db_backupID.cxx 632)

I didn’t bring up the target 15.4 server at all and confirmed I loaded the correct next incremental after full backup.

Has anyone successfully restore full and subsequent incremental backups between 15.2 and 15.4?

Could this be a version compatibility problem?

Thanks
David



David Louie, V.P.| AT-APG-CoreSysOps-DB Ops | BlackRock, Inc.| 212 810-3541| David.Louie at blackrock.com<mailto:David.Louie at blackrock.com>


This message may contain information that is confidential or privileged. If you are not the intended recipient, please advise the sender immediately and delete this message. See http://www.blackrock.com/corporate/en-us/compliance/email-disclaimers for further information.  Please refer to http://www.blackrock.com/corporate/en-us/compliance/privacy-policy for more information about BlackRock’s Privacy Policy.
For a list of BlackRock's office addresses worldwide, see http://www.blackrock.com/corporate/en-us/about-us/contacts-locations.

© 2014 BlackRock, Inc. All rights reserved.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20141009/f7425ad6/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 2409 bytes
Desc: image001.jpg
URL: <http://iqug.org/pipermail/iqug/attachments/20141009/f7425ad6/attachment-0001.jpg>


More information about the IQUG mailing list