topic Re: Snap Creator & Snapmirror with multiple volumes and Oracle. in Data Protection

Snap Creator & Snapmirror with multiple volumes and Oracle.

SHEETZDBA — Thu, 05 Jun 2025 05:34:27 GMT

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?

Re: Snap Creator & Snapmirror with multiple volumes and Oracle.

sivar — Wed, 11 Jun 2014 14:55:29 GMT

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

Re: Snap Creator & Snapmirror with multiple volumes and Oracle.

SHEETZDBA — Wed, 11 Jun 2014 15:36:26 GMT

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.

Controller	Volume	Access Time	Snapshot Copy Name	Location	Dependency
dcdrarrayb	srmtest_redoB_vol	Wed Jun 11 11:15:43 GMT-400 2014	dcdrarrayb(1574383744)_srmtest_redoB_vol.3	Secondary(SnapMirror)
dcdrarrayb	srmtest_temp_vol	Wed Jun 11 11:15:43 GMT-400 2014	dcdrarrayb(1574383744)_srmtest_temp_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
dc3210a	srmtest_temp_vol	Wed Jun 11 11:15:43 GMT-400 2014	dcdrarrayb(1574383744)_srmtest_temp_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)
dcdrarrayb	srmtest_data_vol	Wed Jun 11 11:15:40 GMT-400 2014	dcdrarrayb(1574383744)_srmtest_data_vol.3	Secondary(SnapMirror)
dcdrarrayb	srmtest_redoA_vol	Wed Jun 11 11:15:40 GMT-400 2014	dcdrarrayb(1574383744)_srmtest_redoA_vol.3	Secondary(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
dc3210a	srmtest_redoA_vol	Wed Jun 11 11:15:40 GMT-400 2014	dcdrarrayb(1574383744)_srmtest_redoA_vol.3	Primary	snapmirror
dc3210a	srmtest_recovery_vol	Wed Jun 11 11:15:40 GMT-400 2014	dcdrarrayb(1574383744)_srmtest_recovery_vol.3	Primary	snapmirror
dc3210a	srmtest_data_vol	Wed Jun 11 11:15:40 GMT-400 2014	dcdrarrayb(1574383744)_srmtest_data_vol.3	Primary	snapmirror
dcdrarrayb	srmtest_recovery_vol	Wed Jun 11 11:15:13 GMT-400 2014	srmtest_dr-DR_SITE_POLICY_20140611101500	Secondary(SnapMirror)
dcdrarrayb	srmtest_data_vol	Wed Jun 11 11:15:13 GMT-400 2014	srmtest_dr-DR_SITE_POLICY_20140611101500	Secondary(SnapMirror)
dcdrarraybq	srmtest_redoA_vol	Wed Jun 11 11:15:13 GMT-400 2014	srmtest_dr-DR_SITE_POLICY_20140611101500	Secondary(SnapMirror)
dcdrarrayb	srmtest_redoB_vol	Wed Jun 11 11:15:13 GMT-400 2014	srmtest_dr-DR_SITE_POLICY_20140611101500	Secondary(SnapMirror)
dcdrarrayb	srmoracletest_vol	Wed Jun 11 11:15:13 GMT-400 2014	srmtest_dr-DR_SITE_POLICY_20140611101500	Secondary(SnapMirror)
dcdrarrayb	srmtest_temp_vol	Wed Jun 11 11:15:13 GMT-400 2014	srmtest_dr-DR_SITE_POLICY_20140611101500	Secondary(SnapMirror)
dc3210a	srmoracletest_vol	Wed Jun 11 11:15:13 GMT-400 2014	srmtest_dr-DR_SITE_POLICY_20140611101500	Primary
dc3210a	srmtest_redoA_vol	Wed Jun 11 11:15:13 GMT-400 2014	srmtest_dr-DR_SITE_POLICY_20140611101500	Primary
dc3210a	srmtest_redoB_vol	Wed Jun 11 11:15:13 GMT-400 2014	srmtest_dr-DR_SITE_POLICY_20140611101500	Primary
dc3210a	srmtest_recovery_vol	Wed Jun 11 11:15:13 GMT-400 2014	srmtest_dr-DR_SITE_POLICY_20140611101500	Primary
dc3210a	srmtest_temp_vol	Wed Jun 11 11:15:13 GMT-400 2014	srmtest_dr-DR_SITE_POLICY_20140611101500	Primary
dc3210a	srmtest_data_vol	Wed Jun 11 11:15:13 GMT-400 2014	srmtest_dr-DR_SITE_POLICY_20140611101500	Primary

Re: Snap Creator & Snapmirror with multiple volumes and Oracle.

sivar — Wed, 11 Jun 2014 16:25:16 GMT

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