Several snapshot for one SMSAP backup

[cjeff]

IHAC is using SMSAP, he found for one backup, there were several snapshots, he wants to know why?

21% (21%)    7% ( 7%)  Oct 20 20:13  smsap_naawcn101_cn1_p_h_3_8ac383e52bc985a8012bc985ad9b0001_0

21% ( 0%)    7% ( 0%)  Oct 20 20:12  smsap_naawcn101_cn1_p_h_2_8ac383e52bc985a8012bc985ad9b0001_0

21% ( 0%)    7% ( 0%)  Oct 20 20:04  smsap_naawcn101_cn1_p_h_1_8ac383e52bc985a8012bc985ad9b0001_0

21% ( 0%)    7% ( 0%)  Oct 20 20:02  smsap_naawcn101_cn1_f_h_2_8ac383e52bc98356012bc9835d610001_0 (snapvault)

21% ( 0%)    7% ( 0%)  Oct 20 20:01  smsap_naawcn101_cn1_f_h_1_8ac383e52bc98356012bc9835d610001_0

Anybody knows what are those p_h_* and f_h_* mean?

Thanks,

Jeff

[nithyana]

These snapshots belong to 1 full backup

21% ( 0%)    7% ( 0%)  Oct 20 20:02  smsap_naawcn101_cn1_f_h_2_8ac383e52bc98356012bc9835d610001_0 (snapvault)

21% ( 0%)    7% ( 0%)  Oct 20 20:01  smsap_naawcn101_cn1_f_h_1_8ac383e52bc98356012bc9835d610001_0

and the following belong to 1 partial backup

21% (21%)    7% ( 7%)  Oct 20 20:13  smsap_naawcn101_cn1_p_h_3_8ac383e52bc985a8012bc985ad9b0001_0

21% ( 0%)    7% ( 0%)  Oct 20 20:12  smsap_naawcn101_cn1_p_h_2_8ac383e52bc985a8012bc985ad9b0001_0

21% ( 0%)    7% ( 0%)  Oct 20 20:04  smsap_naawcn101_cn1_p_h_1_8ac383e52bc985a8012bc985ad9b0001_0

Snapshot is taken at volume level and hence number of snapshots will be same as number of volumes (number of volumes that constitutes the db)

f -> full backup

p -> partial backup

h -> hot or online backup

Thanks,

Nithyananthan S

[craigs]

Jeff and Nithyanathan,

During the backup, SnapDrive will attempt to quiesce the file systems and LUNs to acheive a consistent state for the snapshot.  In the event that it is not able to do this within the timeout period, SnapDrive will then create individual snapshots on the volumes.  This is why you see three snapshots for the same volume.  The "p" refers to partial, as it is a partial backup of the database.  The "f" is for full.

This is quite possible a result of your storage layout, however, without the details regarding the layout and configuration of your system, it's impossible to tell.  It's important that the best practices are followed when laying out the storage for your SAP environments on NetApp.  Please review TR-3533 SAP with Oracle on UNIX and FCP and NetApp Storage. This document discusses how to properly configure storage to support SMSAP.  Another excellent resource is TR-3823 Best Practices for SnapManager 3.0 for SAP.

Regards,

Craig

[cjeff]

Craig,

After checking with the customer, those SnapShots would be generated within one SMSAP backup.

Why in one backup, some snapshots are marked as full and some are marked as partial?

I attach one of SMSAP backup log file.

Thanks,
Jeff

[vrishali]

I'm on leave from 30th Oct to 12th Nov. Please contact my manager

Senthil (senthilk@netapp.com) for anything urgent.

Thanks,

Vrishali

[jakub_wartak]

This happens because you have invalid storage layout, (e.g.. LUNs with various Oracle files in the same volume) which is forcing SMSAP to create several snapshots for the same volume.

You can verify that by selecting the hot-backup in SMSAP GUI , selecting "override" mode (to force so called "fast restore via snapshots") and then doing restore. It is going to probably to fail rendering your SAP enviorniment useless, but you might have chance to do the default SMSAP restore, but then it is going to be long (AKA file-based copy restore).

-Jakub.

[vrishali]

I'm on leave from 30th Oct to 12th Nov. Please contact my manager

Senthil (senthilk@netapp.com) for anything urgent.

Thanks,

Vrishali

[cjeff]

Customer is using brbackup and brarchive to do the backup.

For the f_h_* related snapshots, in the TR3823, SnapManger for SAP 3.0 Best Practices, on page 25, there is the explanation about those two snapshots.

The following example shows two Snapshot copy names created for the datafiles volume and the control files volume. The second Snapshot copy listed has “_f_h_1_“ in the middle of its name. The "1" indicates that it is the first Snapshot copy created in the backup set. The first Snapshot copy listed is the most recent and has a "2," which means it is the second Snapshot copy created. The "1" Snapshot copy includes the datafiles; the "2" Snapshot copy includes the control files. Because the control file Snapshot copy must be created after the datafile Snapshot copy, two Snapshot copies are required.

Those three p_h_* snapshots should be generated by brarchive, but why there are 3 snapshots? Anybody knows that?

Thanks,

Jeff

[vrishali]

I'm on leave from 30th Oct to 12th Nov. Please contact my manager

Senthil (senthilk@netapp.com) for anything urgent.

Thanks,

Vrishali

[craigs]

Jeff,

I can't say exactly why there were three snapshots created.  I think Jakub is correct that the storage layout may not be in line with best practices, which can make it difficult for SDU to quiesce the file systems within the window necessary to create a consistent backup.  As a result, it defaults to doing partial backups of the volume and quiescing only a portion of the file systems each time.

Please review the documents I mentioned in an earlier reply to see if your storage layout could be the culprit.

Craig

[vrishali]

I'm on leave from 30th Oct to 12th Nov. Please contact my manager

Senthil (senthilk@netapp.com) for anything urgent.

Thanks,

Vrishali

[cjeff]

Craig,

This is a SAN booted Windows, below is the result from sdcli.

LUN Path: naana002:/vol/cn101_sanboot_fc/win_fc_cn101sanboot/cn101_sanboot
         Storage System:         naana002
         Storage System Path:    /vol/cn101_sanboot_fc/win_fc_cn101sanboot/cn101_sanboot
         Mount points:           C:\
LUN Path: naana002:/vol/cn101_mirrlogs_fc/win_fc_cn103mirrlogs/cn101_mirrlogs
         Storage System:         naana002
         Storage System Path:    /vol/cn101_mirrlogs_fc/win_fc_cn103mirrlogs/cn101_mirrlogs
         Mount points:           E:\
LUN Path: naana002:/vol/cn101_swap_fc/win_fc_cn101swap/cn101_swap
         Storage System:         naana002
         Storage System Path:    /vol/cn101_swap_fc/win_fc_cn101swap/cn101_swap
         Mount points:           S:\
LUN Path: naana002:/vol/cn101_archive_fc/win_fc_cn103archive/cn101_archive
         Storage System:         naana002
         Storage System Path:    /vol/cn101_archive_fc/win_fc_cn103archive/cn101_archive
         Mount points:           F:\
LUN Path: naana012:/vol/cn101_sapexe_fc/win_fc_cn103sapexe/cn101_sapexe
         Storage System:         naana012
         Storage System Path:    /vol/cn101_sapexe_fc/win_fc_cn103sapexe/cn101_sapexe
         Mount points:           G:\
LUN Path: naana012:/vol/cn101_oractrl_fc/win_fc_cn103oractrl/cn101_oractrl
         Storage System:         naana012
         Storage System Path:    /vol/cn101_oractrl_fc/win_fc_cn103oractrl/cn101_oractrl
         Mount points:           I:\
LUN Path: naana012:/vol/cn101_redologs_fc/win_fc_cn103redologs/cn101_redologs
         Storage System:         naana012
         Storage System Path:    /vol/cn101_redologs_fc/win_fc_cn103redologs/cn101_redologs
         Mount points:           D:\
LUN Path: naana012:/vol/cn101_sapdata_fc/win_fc_cn103sapdata/cn101_sapdata
         Storage System:         naana012
         Storage System Path:    /vol/cn101_sapdata_fc/win_fc_cn103sapdata/cn101_sapdata
         Mount points:           H:\
LUN Path: naana012:/vol/cn101_share_fc/win_fc_cn1share/cn1_share1
         Storage System:         naana012
         Storage System Path:    /vol/cn101_share_fc/win_fc_cn1share/cn1_share1
         Mount points:           Z:\

Could you help me to check whether they are in line with the best practices?

Thanks,

Jeff

[vrishali]

I'm on leave from 30th Oct to 12th Nov. Please contact my manager

Senthil (senthilk@netapp.com) for anything urgent.

Thanks,

Vrishali

[craigs]

Jeff,

Sorry for the delay returning this message.

Please review the configuration in our best practices for SAP on Windows with Oracle and NetApp. We use fewer flexvols than in your configuration.

Also, have you changed the SAP standard configuration to remove the control file from sapdata1?  This will cause some problems and cause multiple snapshots of the sapdata volume if you have not.

Craig