Data Backup and Recovery

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data Backup and Recovery

Ask a Question

Snap Creator & Snapmirror with multiple volumes and Oracle.

SHEETZDBA
‎2014-06-11 07:49 AM
3,047 Views

I have an Oracle database on Red Hat, with the following volumes.

Data, Recovery, RedoA, RedoB, Temp, OperatingSystem

It's setup that way to work with Snap Manager for Oracle, which does work fine. I'm experimenting with snap creator and snapmirror to replicate to my DR netapp site.

I configured snap creator with snapmirror, and the oracle plugin, and was able to do the following:

1) Quiesce the oracle database by putting it in hot backup mode.

2) Create volume snapshots using consistency groups. All the volumes have a snapshot created at exactly the same time.

3) SnapMirror creates the snapshots on my DR netapp array.

Now the question. When SnapMirror is invoked, it also creates it's own snapshots of my volumes on the Primary and on DR array.

These snapshots are not using consistency groups, and I'm not sure if oracle is in hot backup mode while they occur.

Is there any way to prevent SnapMirror from creating this second set of snapshots?

0 Kudos
View By:
3 REPLIES 3

sivar
NetApp
‎2014-06-11 07:55 AM
3,047 Views

SnapMirror always keeps 2 snapshots (and rolls it automatically after each update).  -- you can't prevent these snapshots being created and updated.

Could you please provide a snapshot list output and ask specifically which snapshots you are worried about?

Thanks,

Siva Ramanathan

0 Kudos

SHEETZDBA
‎2014-06-11 08:36 AM
In response to sivar
3,047 Views

Here's an example.

dc3210a is the primary, dcdrarrayb is the secondary

I have a policy and a schedule created, and you can see those snapshots. They're followed by the snapshots snapmirror creates with "1574383744" in the name.

What I am tinkering with is using vmware site recovery manager with all of this.

ControllerVolumeAccess TimeSnapshot Copy NameLocationDependency
dcdrarraybsrmtest_redoB_volWed Jun 11 11:15:43 GMT-400 2014dcdrarrayb(1574383744)_srmtest_redoB_vol.3Secondary(SnapMirror)
dcdrarraybsrmtest_temp_volWed Jun 11 11:15:43 GMT-400 2014dcdrarrayb(1574383744)_srmtest_temp_vol.3Secondary(SnapMirror)
dc3210asrmtest_redoB_volWed Jun 11 11:15:43 GMT-400 2014dcdrarrayb(1574383744)_srmtest_redoB_vol.3Primarysnapmirror
dc3210asrmtest_temp_volWed Jun 11 11:15:43 GMT-400 2014dcdrarrayb(1574383744)_srmtest_temp_vol.3Primarysnapmirror
dcdrarraybsrmtest_recovery_volWed Jun 11 11:15:40 GMT-400 2014dcdrarrayb(1574383744)_srmtest_recovery_vol.3Secondary(SnapMirror)
dcdrarraybsrmtest_data_volWed Jun 11 11:15:40 GMT-400 2014dcdrarrayb(1574383744)_srmtest_data_vol.3Secondary(SnapMirror)
dcdrarraybsrmtest_redoA_volWed Jun 11 11:15:40 GMT-400 2014dcdrarrayb(1574383744)_srmtest_redoA_vol.3Secondary(SnapMirror)
dcdrarraybsrmoracletest_volWed Jun 11 11:15:40 GMT-400 2014dcdrarrayb(1574383744)_srmoracletest_vol.3Secondary(SnapMirror)
dc3210asrmoracletest_volWed Jun 11 11:15:40 GMT-400 2014dcdrarrayb(1574383744)_srmoracletest_vol.3Primarysnapmirror
dc3210asrmtest_redoA_volWed Jun 11 11:15:40 GMT-400 2014dcdrarrayb(1574383744)_srmtest_redoA_vol.3Primarysnapmirror
dc3210asrmtest_recovery_volWed Jun 11 11:15:40 GMT-400 2014dcdrarrayb(1574383744)_srmtest_recovery_vol.3Primarysnapmirror
dc3210asrmtest_data_volWed Jun 11 11:15:40 GMT-400 2014dcdrarrayb(1574383744)_srmtest_data_vol.3Primarysnapmirror
dcdrarraybsrmtest_recovery_volWed Jun 11 11:15:13 GMT-400 2014srmtest_dr-DR_SITE_POLICY_20140611101500Secondary(SnapMirror)
dcdrarraybsrmtest_data_volWed Jun 11 11:15:13 GMT-400 2014srmtest_dr-DR_SITE_POLICY_20140611101500Secondary(SnapMirror)
dcdrarraybqsrmtest_redoA_volWed Jun 11 11:15:13 GMT-400 2014srmtest_dr-DR_SITE_POLICY_20140611101500Secondary(SnapMirror)
dcdrarraybsrmtest_redoB_volWed Jun 11 11:15:13 GMT-400 2014srmtest_dr-DR_SITE_POLICY_20140611101500Secondary(SnapMirror)
dcdrarraybsrmoracletest_volWed Jun 11 11:15:13 GMT-400 2014srmtest_dr-DR_SITE_POLICY_20140611101500Secondary(SnapMirror)
dcdrarraybsrmtest_temp_volWed Jun 11 11:15:13 GMT-400 2014srmtest_dr-DR_SITE_POLICY_20140611101500Secondary(SnapMirror)
dc3210asrmoracletest_volWed Jun 11 11:15:13 GMT-400 2014srmtest_dr-DR_SITE_POLICY_20140611101500Primary
dc3210asrmtest_redoA_volWed Jun 11 11:15:13 GMT-400 2014srmtest_dr-DR_SITE_POLICY_20140611101500Primary
dc3210asrmtest_redoB_volWed Jun 11 11:15:13 GMT-400 2014srmtest_dr-DR_SITE_POLICY_20140611101500Primary
dc3210asrmtest_recovery_volWed Jun 11 11:15:13 GMT-400 2014srmtest_dr-DR_SITE_POLICY_20140611101500Primary
dc3210asrmtest_temp_volWed Jun 11 11:15:13 GMT-400 2014srmtest_dr-DR_SITE_POLICY_20140611101500Primary
dc3210asrmtest_data_volWed Jun 11 11:15:13 GMT-400 2014srmtest_dr-DR_SITE_POLICY_20140611101500Primary
0 Kudos

sivar
NetApp
‎2014-06-11 09:25 AM
In response to SHEETZDBA
3,047 Views

You can't avoid these snapshots.

These are SnapMirror created common snapshot copy. (same snapshot copy on primary and secondary) - this will be created during snapmirror initialize or update.

These snapshot copies are needed to resynchronize after a break.

This is outside of Snap Creator's control and is maintained by cDOT.

dcdrarrayb    srmtest_redoB_vol    Wed Jun 11 11:15:43 GMT-400 2014    dcdrarrayb(1574383744)_srmtest_redoB_vol.3    Secondary(SnapMirror)

dc3210a        srmtest_redoB_vol    Wed Jun 11 11:15:43 GMT-400 2014    dcdrarrayb(1574383744)_srmtest_redoB_vol.3    Primary    snapmirror

dcdrarrayb    srmtest_temp_vol    Wed Jun 11 11:15:43 GMT-400 2014    dcdrarrayb(1574383744)_srmtest_temp_vol.3    Secondary(SnapMirror)

dc3210a        srmtest_temp_vol    Wed Jun 11 11:15:43 GMT-400 2014    dcdrarrayb(1574383744)_srmtest_temp_vol.3    Primary    snapmirror

dcdrarrayb    srmtest_redoA_vol    Wed Jun 11 11:15:40 GMT-400 2014    dcdrarrayb(1574383744)_srmtest_redoA_vol.3    Secondary(SnapMirror)

dc3210a        srmtest_redoA_vol    Wed Jun 11 11:15:40 GMT-400 2014    dcdrarrayb(1574383744)_srmtest_redoA_vol.3    Primary    snapmirror

dcdrarrayb    srmtest_data_vol    Wed Jun 11 11:15:40 GMT-400 2014    dcdrarrayb(1574383744)_srmtest_data_vol.3    Secondary(SnapMirror)

dc3210a        srmtest_data_vol    Wed Jun 11 11:15:40 GMT-400 2014    dcdrarrayb(1574383744)_srmtest_data_vol.3    Primary    snapmirror

dcdrarrayb    srmoracletest_vol    Wed Jun 11 11:15:40 GMT-400 2014    dcdrarrayb(1574383744)_srmoracletest_vol.3    Secondary(SnapMirror)

dc3210a        srmoracletest_vol    Wed Jun 11 11:15:40 GMT-400 2014    dcdrarrayb(1574383744)_srmoracletest_vol.3    Primary    snapmirror

dcdrarrayb    srmtest_recovery_vol    Wed Jun 11 11:15:40 GMT-400 2014    dcdrarrayb(1574383744)_srmtest_recovery_vol.3    Secondary(SnapMirror)

dc3210a        srmtest_recovery_vol    Wed Jun 11 11:15:40 GMT-400 2014    dcdrarrayb(1574383744)_srmtest_recovery_vol.3    Primary    snapmirror

0 Kudos
All Community Forums
Public