SMSAP 3.3P1 cloning to a different AIX Host with same Oracle SID

[sohail_hasan]

SMSAP 3.3P1

AIX 6.1 TL8

Snapdrive 5.2.1

When trying to clone Oracle DB to a different AIX host using secondary protected backup, we receive the following error:

--[ INFO] SMSAP-13036: Starting operation Clone Create on host clonebwp

--[ INFO] SMSAP-13046: Operation GUID 8a9f84fe44f5af720144f5af774a0001 starting on Profile BWPNAP1DV1

--[ INFO] SMSAP-04137: Auto-generated label "clone_BWP_20140324130200PDT" for clone.

--[ INFO] SMSAP-04030: Validating uniqueness of new SID "BWP".

--[ INFO] SMSAP-04040: Using ORACLE_HOME of "/oracle/BWP/112_64" from clonespec for clone.

--[ INFO] SMSAP-04042: Using Oracle OS account "orabwp" from clonespec for clone.

--[ INFO] SMSAP-04044: Using Oracle OS group "dba" from clonespec for clone.

--[ INFO] SMSAP-07127: Locked database for SnapManager operations - created lock file "/oracle/BWP/112_64/dbs/.sm_lock_BWP" on host clonebwp.

--[ INFO] DS-10001: Connecting mountpoints [/oracle/BWP/sapdata5, /oracle/BWP/sapdata6, /oracle/BWP/sapdata1, /oracle/BWP/sapdata2, /oracle/BWP/sapdata4, /oracle/BWP/sapdata7, /oracle/BWP/sapdata3] from snapshot smsap_1_8a9f84f944f261b80144f261bdd70001_0 in copy 320 of backup 1395636110 of dataset smsap_bwpnap1d_bwp.

--[ERROR] FLOW-11019: Failure in ExecuteConnectionSteps: SD-10028: SnapDrive Error (id:2618 code:102) Snapdrive could not import /dev/data_bwp_vg_0: Device not found in CuDv class while setting ODM attribute

--[ERROR] FLOW-11010: Operation transitioning to abort due to prior failure.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata5_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata6_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata1_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata2_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata4_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata7_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata3_BWP.

--[ WARN] FLOW-11011: Operation aborted

--[ERROR] FLOW-11008: Operation failed: SD-10028: SnapDrive Error (id:2618 code:102) Snapdrive could not import /dev/data_bwp_vg_0: Device not found in CuDv class while setting ODM attribute

--[ERROR] SMSAP-13032: Cannot perform operation: Clone Create.  Root cause: SMSAP-11007: Error cloning from Snapshot copy: FLOW-11019: Failure in ExecuteConnectionSteps: SD-10028: SnapDrive Error (id:2618 code:102) Snapdrive could not import /dev/data_bwp_vg_0: Device not found in CuDv class while setting ODM attribute

--[ INFO] SMSAP-07131: Unlocked database for SnapManager operations - removed lock file "/oracle/BWP/112_64/dbs/.sm_lock_BWP" on host clonebwp.

--[ INFO] SMSAP-13039: Successfully aborted operation: Clone Create

--[ERROR] SMSAP-13048: Clone Create Operation Status: FAILED

--[ INFO] SMSAP-13049: Elapsed Time: 0:01:45.160

Is there a basic mistake that we are doing or someone has received this error before, any help would be highly appreciated.

[himanshp]

Hello Sohail,

It looks like you are hitting an AIX issue related to concurrent volume groups.

Please look at http://support.netapp.com/NOW/cgi-bin/bol?Type=Detail&Display=770067  for more details on the issue.

Thanks,

Himanshu

[sohail_hasan]

Hi Himanshu,

Thanks for your reply. I checked on the AIX systems, since we are running AIX 6.1 the following APAR apply to us and it seems to be installed:

IV41209

root@bwpnap1d:/:# instfix -ik IV41209

    All filesets for IV41209 were found.

Regards,

Sohail

[himanshp]

Sohail,

Have you set the value of the configuration variable 'use-recreatevg-workaround' to 'on' in the SnapDrive configuration file and restarted SDU daemon.

Regards,

Himanshu

[sohail_hasan]

Himanshu,

I cannot find this parameter in the snapdrive.conf file , how to set this parameter.

Regards,

Sohail

[himanshp]

Sohail,

Please add this variable to snapdrive.conf, restart the daemon and then try operation again.

use-recreatevg-workaround="on"

Thanks,

Himanshu

[sohail_hasan]

Himanshu,

I added the parameter on both source and target aix system, source system is on the primary NSeries and the target system is on Snapvaulted NSeries but both systems have igroups defined on both storage boxes. restarted SDU and now receiving this:

--[ INFO] SMSAP-13036: Starting operation Clone Create on host clonebwp

--[ INFO] SMSAP-13046: Operation GUID 8a9f84fe44fecf130144fecf18e80001 starting on Profile BWPNAP1DV1

--[ INFO] SMSAP-04137: Auto-generated label "clone_BWP_20140326073308PDT" for clone.

--[ INFO] SMSAP-04030: Validating uniqueness of new SID "BWP".

--[ INFO] SMSAP-04040: Using ORACLE_HOME of "/oracle/BWP/112_64" from clonespec for clone.

--[ INFO] SMSAP-04042: Using Oracle OS account "orabwp" from clonespec for clone.

--[ INFO] SMSAP-04044: Using Oracle OS group "dba" from clonespec for clone.

--[ INFO] SMSAP-07127: Locked database for SnapManager operations - created lock file "/oracle/BWP/112_64/dbs/.sm_lock_BWP" on host clonebwp.

--[ INFO] DS-10001: Connecting mountpoints [/oracle/BWP/sapdata7, /oracle/BWP/sapdata3, /oracle/BWP/sapdata4, /oracle/BWP/sapdata2, /oracle/BWP/sapdata5, /oracle/BWP/sapdata6, /oracle/BWP/sapdata1] from snapshot smsap_1_8a9f84f944f261b80144f261bdd70001_0 in copy 320 of backup 1395636110 of dataset smsap_bwpnap1d_bwp.

--[ERROR] FLOW-11019: Failure in ExecuteConnectionSteps: SD-10028: SnapDrive Error (id:2618 code:102) mount failed: mount: /dev/SAPDATA1_BWP__0 on /oracle/BWP/sapdata1_BWP Cannot mount guarded filesystem. The filesystem is potentially mounted on another node. .

--[ERROR] FLOW-11010: Operation transitioning to abort due to prior failure.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata7_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata3_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata4_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata2_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata5_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata6_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata1_BWP.

--[ WARN] FLOW-11011: Operation aborted

--[ERROR] FLOW-11008: Operation failed: SD-10028: SnapDrive Error (id:2618 code:102) mount failed: mount: /dev/SAPDATA1_BWP__0 on /oracle/BWP/sapdata1_BWP Cannot mount guarded filesystem. The filesystem is potentially mounted on another node. .

--[ERROR] SMSAP-13032: Cannot perform operation: Clone Create.  Root cause: SMSAP-11007: Error cloning from Snapshot copy: FLOW-11019: Failure in ExecuteConnectionSteps: SD-10028: SnapDrive Error (id:2618 code:102) mount failed: mount: /dev/SAPDATA1_BWP__0 on /oracle/BWP/sapdata1_BWP Cannot mount guarded filesystem. The filesystem is potentially mounted on another node. .

--[ INFO] SMSAP-07131: Unlocked database for SnapManager operations - removed lock file "/oracle/BWP/112_64/dbs/.sm_lock_BWP" on host clonebwp.

--[ INFO] SMSAP-13039: Successfully aborted operation: Clone Create

--[ERROR] SMSAP-13048: Clone Create Operation Status: FAILED

--[ INFO] SMSAP-13049: Elapsed Time: 0:01:52.198

[himanshp]

Sohail,

Can you set below variable to "on" in snapdrive.conf for mountguard support on AIX  and restart the daemon on both hosts.

enable-mountguard-support="on"

-Himanshu

[sohail_hasan]

Thanks Himanshu, hope its not going to cause any effects to the source clone production system. Can I do it safely.

Sohail

[sohail_hasan]

I got this now:

--[ INFO] SMSAP-13036: Starting operation Clone Create on host clonebwp

--[ INFO] SMSAP-13046: Operation GUID 8a9f84fe45006c6d0145006c72a10001 starting on Profile BWPNAP1DV1

--[ INFO] SMSAP-04137: Auto-generated label "clone_BWP_20140326150438PDT" for clone.

--[ INFO] SMSAP-04030: Validating uniqueness of new SID "BWP".

--[ INFO] SMSAP-04040: Using ORACLE_HOME of "/oracle/BWP/112_64" from clonespec for clone.

--[ INFO] SMSAP-04042: Using Oracle OS account "orabwp" from clonespec for clone.

--[ INFO] SMSAP-04044: Using Oracle OS group "dba" from clonespec for clone.

--[ INFO] SMSAP-07127: Locked database for SnapManager operations - created lock file "/oracle/BWP/112_64/dbs/.sm_lock_BWP" on host clonebwp.

--[ INFO] DS-10001: Connecting mountpoints [/oracle/BWP/sapdata7, /oracle/BWP/sapdata3, /oracle/BWP/sapdata4, /oracle/BWP/sapdata2, /oracle/BWP/sapdata5, /oracle/BWP/sapdata6, /oracle/BWP/sapdata1] from snapshot smsap_1_8a9f84f945004f6d0145004f72cd0001_0 in copy 334 of backup 1395869776 of dataset smsap_bwpnap1d_bwp.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata7_BWP.

--[ INFO] SD-00017: Finished storage discovery for /oracle/BWP/sapdata7_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata3_BWP.

--[ INFO] SD-00017: Finished storage discovery for /oracle/BWP/sapdata3_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata4_BWP.

--[ INFO] SD-00017: Finished storage discovery for /oracle/BWP/sapdata4_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata2_BWP.

--[ INFO] SD-00017: Finished storage discovery for /oracle/BWP/sapdata2_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata5_BWP.

--[ INFO] SD-00017: Finished storage discovery for /oracle/BWP/sapdata5_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata6_BWP.

--[ INFO] SD-00017: Finished storage discovery for /oracle/BWP/sapdata6_BWP.

--[ INFO] SD-00016: Discovering storage resources for /oracle/BWP/sapdata1_BWP.

--[ INFO] SD-00017: Finished storage discovery for /oracle/BWP/sapdata1_BWP.

--[ INFO] DS-10002: Connected mountpoints [/oracle/BWP/sapdata7, /oracle/BWP/sapdata3, /oracle/BWP/sapdata4, /oracle/BWP/sapdata2, /oracle/BWP/sapdata5, /oracle/BWP/sapdata6, /oracle/BWP/sapdata1] at [/oracle/BWP/sapdata4_BWP, /oracle/BWP/sapdata3_BWP, /oracle/BWP/sapdata7_BWP, /oracle/BWP/sapdata1_BWP, /oracle/BWP/sapdata6_BWP, /oracle/BWP/sapdata5_BWP, /oracle/BWP/sapdata2_BWP].

--[ INFO] ORACLE-00502: Adding entry for database BWP in /etc/oratab.

--[ INFO] SMSAP-07300: Beginning clone of database "BWP" to SID "BWP" on host "clonebwp".

--[ INFO] SMSAP-07302: Generating parameter file for "BWP" at "/oracle/BWP/112_64/dbs/initBWP.ora".

--[ INFO] SMSAP-07303: Generating password file for "BWP" at "/oracle/BWP/112_64/dbs/orapwBWP".

--[ INFO] SMSAP-07304: Starting up database "BWP" in NOMOUNT mode.

--[ INFO] SMSAP-07305: Generating control files for database "BWP".

--[ INFO] SMSAP-07312: Create Control File - Database: BWP.

--[ INFO] SMSAP-07313: Create Control File - Redolog: /oracle/BWP/sapdata4_BWP/redo_2_1.log.

--[ INFO] SMSAP-07313: Create Control File - Redolog: /oracle/BWP/sapdata4_BWP/redo_4_1.log.

--[ INFO] SMSAP-07313: Create Control File - Redolog: /oracle/BWP/sapdata4_BWP/redo_4_0.log.

--[ INFO] SMSAP-07313: Create Control File - Redolog: /oracle/BWP/sapdata4_BWP/redo_2_0.log.

--[ INFO] SMSAP-07313: Create Control File - Redolog: /oracle/BWP/sapdata4_BWP/redo_3_0.log.

--[ INFO] SMSAP-07313: Create Control File - Redolog: /oracle/BWP/sapdata4_BWP/redo_1_1.log.

--[ INFO] SMSAP-07313: Create Control File - Redolog: /oracle/BWP/sapdata4_BWP/redo_1_0.log.

--[ INFO] SMSAP-07313: Create Control File - Redolog: /oracle/BWP/sapdata4_BWP/redo_3_1.log.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp701_1/bwp701.data1.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_45/bwp.data45.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_1/bwp.data1.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_41/bwp.data41.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata1_BWP/system_4/system.data4.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_67/bwp.data67.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_69/bwp.data69.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_19/bwp.data19.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_26/bwp.data26.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata6_BWP/bwpods_6/bwpods.data6.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata7_BWP/bwpods_2/bwpods.data2.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata6_BWP/bwpods_12/bwpods.data12.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_2/bwp.data2.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_18/bwp.data18.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_9/bwp.data9.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_53/bwp.data53.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_56/bwp.data56.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_48/bwp.data48.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_30/bwp.data30.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata3_BWP/bwp640_3/bwp640.data3.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_24/bwp.data24.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_35/bwp.data35.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_15/bwp.data15.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_6/bwp.data6.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_38/bwp.data38.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata3_BWP/bwp_57/bwp.data57.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_33/bwp.data33.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_10/bwp.data10.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_32/bwp.data32.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_5/bwp.data5.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_31/bwp.data31.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata7_BWP/bwpods_16/bwpods.data16.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata3_BWP/bwp_58/bwp.data58.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata6_BWP/bwpods_9/bwpods.data9.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_20/bwp.data20.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata3_BWP/undo_2/undo.data2.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata1_BWP/system_2/system.data2.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_39/bwp.data39.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_44/bwp.data44.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata7_BWP/bwpdim_1/bwpdim.data1.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata1_BWP/system_1/system.data1.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata7_BWP/bwpfact_1/bwpfact.data1.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata7_BWP/bwpods_22/bwpods.data22.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata1_BWP/bwpods_21/bwpods.data21.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata1_BWP/bwpods_17/bwpods.data17.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_61/bwp.data61.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp701_3/bwp701.data3.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata1_BWP/system_3/system.data3.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_66/bwp.data66.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata3_BWP/bwp640_4/bwp640.data4.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_47/bwp.data47.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_60/bwp.data60.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata1_BWP/bwpods_18/bwpods.data18.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_68/bwp.data68.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata7_BWP/bwp_73/bwp.data73.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_50/bwp.data50.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata7_BWP/bwpfact_2/bwpfact.data2.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata3_BWP/system_3/sysaux03.dbf.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_42/bwp.data42.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_36/bwp.data36.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_22/bwp.data22.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_29/bwp.data29.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_28/bwp.data28.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_3/bwp.data3.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_71/bwp.data71.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_27/bwp.data27.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata1_BWP/system_1/sysaux01.dbf.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_16/bwp.data16.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_63/bwp.data63.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp701_4/bwp701.data4.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata7_BWP/bwpods_11/bwpods.data11.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_14/bwp.data14.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp701_2/bwp701.data2.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata6_BWP/bwpods_5/bwpods.data5.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_34/bwp.data34.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata7_BWP/bwpods_1/bwpods.data1.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_46/bwp.data46.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_40/bwp.data40.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata7_BWP/bwpods_20/bwpods.data20.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_51/bwp.data51.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_59/bwp.data59.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata1_BWP/undo_1/undo.data1.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata1_BWP/bwpods_13/bwpods.data13.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_11/bwp.data11.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_52/bwp.data52.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_25/bwp.data25.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_4/bwp.data4.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata7_BWP/bwpods_15/bwpods.data15.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata6_BWP/bwpods_8/bwpods.data8.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata6_BWP/bwpods_7/bwpods.data7.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_8/bwp.data8.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata7_BWP/bwpdim_2/bwpdim.data2.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_23/bwp.data23.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata1_BWP/bwpods_10/bwpods.data10.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata3_BWP/bwp_55/bwp.data55.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwpusr_1/bwpusr.data1.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_37/bwp.data37.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata3_BWP/bwp640_2/bwp640.data2.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata6_BWP/bwpods_14/bwpods.data14.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata3_BWP/bwp_54/bwp.data54.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_62/bwp.data62.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata1_BWP/system_2/sysaux02.dbf.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata6_BWP/bwp_72/bwp.data72.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_64/bwp.data64.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_43/bwp.data43.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_13/bwp.data13.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata7_BWP/bwpods_4/bwpods.data4.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_12/bwp.data12.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_17/bwp.data17.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata5_BWP/bwp_65/bwp.data65.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata3_BWP/bwp640_1/bwp640.data1.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_7/bwp.data7.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata4_BWP/bwp_21/bwp.data21.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata6_BWP/bwp_70/bwp.data70.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata6_BWP/bwpods_19/bwpods.data19.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata7_BWP/bwpods_3/bwpods.data3.

--[ INFO] SMSAP-07314: Create Control File - Datafile: /oracle/BWP/sapdata2_BWP/bwp_49/bwp.data49.

--[ INFO] SMSAP-07306: Generating server parameter file for database "BWP" at Oracle default location.

--[ INFO] SMSAP-07337: Recovering database clone "BWP" to a consistent point using archived logs from the backup.

--[ INFO] SMSAP-04082: Recovering cloned database

--[ INFO] SMSAP-03054: Mounting backup F_H_20140326143254PDT on host clonebwp to feed archivelogs.

--[ INFO] DS-10001: Connecting mountpoints [/oracle/BWP/oraarch] from snapshot smsap_2_8a9f84f945004f6d0145004f72cd0001_0 in copy 334 of backup 1395869776 of dataset smsap_bwpnap1d_bwp.

--[ INFO] SD-00016: Discovering storage resources for /opt/Ontap/smsap/mnt/-oracle-BWP-oraarch-20140326150724495_0.

--[ INFO] SD-00017: Finished storage discovery for /opt/Ontap/smsap/mnt/-oracle-BWP-oraarch-20140326150724495_0.

--[ INFO] DS-10002: Connected mountpoints [/oracle/BWP/oraarch] at [/opt/Ontap/smsap/mnt/-oracle-BWP-oraarch-20140326150724495_0].

--[ INFO] SMSAP-03061: Perform recovery using backup F_H_20140326143254PDT

--[ INFO] SMSAP-03081: Perform recovery using all connected backups F_H_20140326143254PDT

--[ INFO] SMSAP-03055: Disconnecting backup F_H_20140326143254PDT.

--[ INFO] SD-00016: Discovering storage resources for archlog_bwp_v_0.

--[ INFO] SD-00017: Finished storage discovery for archlog_bwp_v_0.

--[ INFO] SD-00037: Beginning to disconnect volume groups [archlog_bwp_v_0].

--[ INFO] SD-00038: Finished disconnecting volume groups [archlog_bwp_v_0].

--[ERROR] SMSAP-04083: Error Recovering cloned database

--[ INFO] SMSAP-07320: Opening database "BWP" with RESETLOGS option.

--[ERROR] SMSAP-13032: Cannot perform operation: Clone Create.  Root cause: ORACLE-00001: Error executing SQL: [ALTER DATABASE OPEN RESETLOGS;].  The command returned: ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/oracle/BWP/sapdata1_BWP/system_1/system.data1'

--[ INFO] SD-00016: Discovering storage resources for archlog_bwp_v_0.

--[ERROR] FLOW-11019: Failure in Disconnect: SD-00018: Error discovering storage for archlog_bwp_v_0: SD-10016: Error executing snapdrive command "/usr/sbin/snapdrive storage show -vg archlog_bwp_v_0": /dev/archlog_bwp_v_0 -- not found, additional information not available

0001-185 Command error: storage show failed: no NETAPP devices to show or add the host to the trusted hosts (options trusted.hosts) and enable SSL on the storage system or retry after changing snapdrive.conf to use http for storage system communication and restarting snapdrive daemon..

--[ERROR] FLOW-11008: Operation failed: SD-00018: Error discovering storage for archlog_bwp_v_0: SD-10016: Error executing snapdrive command "/usr/sbin/snapdrive storage show -vg archlog_bwp_v_0": /dev/archlog_bwp_v_0 -- not found, additional information not available

0001-185 Command error: storage show failed: no NETAPP devices to show or add the host to the trusted hosts (options trusted.hosts) and enable SSL on the storage system or retry after changing snapdrive.conf to use http for storage system communication and restarting snapdrive daemon..

--[ERROR] SMSAP-08002: Error while aborting operation: SMSAP-11008: Error destroying cloned storage: FLOW-11019: Failure in Disconnect: SD-00018: Error discovering storage for archlog_bwp_v_0: SD-10016: Error executing snapdrive command "/usr/sbin/snapdrive storage show -vg archlog_bwp_v_0": /dev/archlog_bwp_v_0 -- not found, additional information not available

0001-185 Command error: storage show failed: no NETAPP devices to show or add the host to the trusted hosts (options trusted.hosts) and enable SSL on the storage system or retry after changing snapdrive.conf to use http for storage system communication and restarting snapdrive daemon..

--[ INFO] SMSAP-07316: Shutting down database "BWP".

--[ INFO] SMSAP-07317: Deleting file "/oracle/BWP/112_64/dbs/initBWP.ora".

--[ INFO] SMSAP-07317: Deleting file "/oracle/BWP/saptrace/audit/BWP".

--[ INFO] SMSAP-07317: Deleting file "/oracle/BWP/sapdata4_BWP/archive_logs".

--[ INFO] SMSAP-07317: Deleting file "/oracle/BWP/112_64/dbs/orapwBWP".

--[ INFO] SMSAP-07317: Deleting file "/oracle/BWP/112_64/dbs/lkBWP".

--[ INFO] SMSAP-07317: Deleting file "/oracle/BWP/112_64/dbs/hc_BWP.dat".

--[ INFO] SMSAP-07317: Deleting file "/oracle/BWP/sapdata4_BWP/control01.ctl".

--[ INFO] SMSAP-07317: Deleting file "/oracle/BWP/112_64/dbs/spfileBWP.ora".

--[ INFO] ORACLE-00503: Removing entry for database BWP from /etc/oratab.

--[ INFO] SD-00016: Discovering storage resources for data_bwp_vg_0.

--[ INFO] SD-00017: Finished storage discovery for data_bwp_vg_0.

--[ INFO] SD-00037: Beginning to disconnect volume groups [data_bwp_vg_0].

--[ INFO] SD-00038: Finished disconnecting volume groups [data_bwp_vg_0].

--[ INFO] SMSAP-07131: Unlocked database for SnapManager operations - removed lock file "/oracle/BWP/112_64/dbs/.sm_lock_BWP" on host clonebwp.

--[ INFO] SMSAP-13039: Successfully aborted operation: Clone Create

--[ERROR] SMSAP-13048: Clone Create Operation Status: FAILED

--[ INFO] SMSAP-13049: Elapsed Time: 0:05:06.350

[himanshp]

Hello Sohail,

Looks like a bug to me. Clone fails at the time of performing the recovery through volume group "archlog_bwp_v_0" which SnapDrive is unable to discover.

This requires a dump to analyze further.

Meanwhile also request you to open a support case with NetApp.

Thanks,

Himanshu

[sohail_hasan]

Himanshu,

Thanks for the follow up, the case is already open but the progress is very slow. I am just curious if this configuration is run by any other and how they are not facing the same issue.

Regards,

Sohail

[akwasi]

Can you provide the Netapp Case number?

[sohail_hasan]

2004882026

[grahn]

Hi Sohail…I spoke with the support engineer working this case. He is currently engaged and discussing with the IBM rep that the case is coming from. Not sure if that is directly with you or not.

This issue is not something that we should be troubleshooting on the community site because of the technical issues and requirements. At this point, please work with the support engineer that has been assigned to your case.

Please let me know if you have any questions!

Thanks!

Freddy

[sohail_hasan]

It is directly coming from me through IBM support. I am already working with IBM support, the reason for asking here was so that if someone has observed this issue before and to get a timely resolution.

[grahn]

Yep completely understand! Just trying to minimize the confusion and keeping everything in the support case.

Thanks again!

Freddy

Sent from my iPhone

[sohail_hasan · Accepted solution]

The issue got resolved with help from Netapp support, basically we need to add a +parameter value of "local_listener" when we need to clone to a different host:

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=clonexyz)(PORT=1521)))