Subscribe
Accepted Solution

SMO backup with verification fails

[ Edited ]

Hi!

I am running SMO v3.1 on RHEL5.6x64 for Oracle backup.

Normal full online backup completes without errors but when I run backup with verification I get following errors:

--[ INFO] SMO-13046: Operation GUID ff80808134620a890134620a8ea00001 starting on Profile MARIN
--[ INFO] SMO-07431: Saving starting state of the database: marin(OPEN).
--[ INFO] SMO-07431: Saving starting state of the database: marin(OPEN).
--[ INFO] SMO-07127: Locked database for SnapManager operations - created lock file "/u01/app/oracle/product/11.2.0/db_1/dbs/.sm_lock_marin.local" on host rhel5.local.
--[ INFO] ORACLE-20024: Spooling control file for database marin to trace as /tmp/SM_47540.
--[ INFO] ORACLE-20024: Spooling control file for database marin to trace as /tmp/SM_47541.
--[ INFO] ORACLE-20019: Placing database marin into online backup mode.
--[ INFO] SD-00016: Discovering storage resources for /marin_oradata.
--[ INFO] SD-00017: Finished storage discovery for /marin_oradata.
--[ INFO] SD-00001: Beginning snapshot with name smo_marin_marin_f_h_1_ff80808134620a890134620a8ea00001_0 for [/marin_oradata].
--[ INFO] SD-00002: Created snapshot with name smo_marin_marin_f_h_1_ff80808134620a890134620a8ea00001_0 for [/marin_oradata].
--[ INFO] SD-00022: Querying for snapshot fas3140b:/vol/marin_oradata:smo_marin_marin_f_h_1_ff80808134620a890134620a8ea00001_0.
--[ INFO] SD-00023: Finished querying for snapshot fas3140b:/vol/marin_oradata:smo_marin_marin_f_h_1_ff80808134620a890134620a8ea00001_0.
--[ INFO] ORACLE-20020: Taking database marin out of online backup mode.
--[ INFO] ORACLE-20025: Forcing archival of all online redo logs for database marin.
--[ INFO] ORACLE-20023: Backing up control file for database marin to /marin_oractl/oradata/marin/SMOBakCtl_1324494800816_0.
--[ INFO] ORACLE-20023: Backing up control file for database marin to /marin_oractl/oradata/marin/SMOBakCtl_1324494800974_1.
--[ INFO] SD-00016: Discovering storage resources for /marin_oractl.
--[ INFO] SD-00017: Finished storage discovery for /marin_oractl.
--[ INFO] SD-00016: Discovering storage resources for /marin_oralogs.
--[ INFO] SD-00017: Finished storage discovery for /marin_oralogs.
--[ INFO] SD-00001: Beginning snapshot with name smo_marin_marin_f_h_2_ff80808134620a890134620a8ea00001_0 for [/marin_oractl, /marin_oralogs].
--[ INFO] SD-00002: Created snapshot with name smo_marin_marin_f_h_2_ff80808134620a890134620a8ea00001_0 for [/marin_oractl, /marin_oralogs].
--[ INFO] SD-00022: Querying for snapshot fas3140b:/vol/marin_oractl:smo_marin_marin_f_h_2_ff80808134620a890134620a8ea00001_0.
--[ INFO] SD-00023: Finished querying for snapshot fas3140b:/vol/marin_oractl:smo_marin_marin_f_h_2_ff80808134620a890134620a8ea00001_0.
--[ INFO] SD-00022: Querying for snapshot fas3140b:/vol/marin_oralogs:smo_marin_marin_f_h_2_ff80808134620a890134620a8ea00001_0.
--[ INFO] SD-00023: Finished querying for snapshot fas3140b:/vol/marin_oralogs:smo_marin_marin_f_h_2_ff80808134620a890134620a8ea00001_0.
--[ INFO] SMO-07108: Deleting backup control file "/marin_oractl/oradata/marin/SMOBakCtl_1324494800816_0".
--[ INFO] SMO-07108: Deleting backup control file "/marin_oractl/oradata/marin/SMOBakCtl_1324494800974_1".
--[ WARN] SMO-02015: External table "SALES_TRANSACTIONS_EXT" in the database was not backed up as part of this backup operation (SnapManager does not backup external tables).
--[ INFO] SD-00025: Beginning to connect filesystem(s) [/marin_oradata] from snapshot smo_marin_marin_f_h_1_ff80808134620a890134620a8ea00001_0.
--[ERROR] FLOW-11019: Failure in ExecuteConnectionSteps: SD-00027: Error connecting filesystem(s) [/marin_oradata] from snapshot smo_marin_marin_f_h_1_ff80808134620a890134620a8ea00001_0: SD-10016: Error executing snapdrive command "/usr/sbin/snapdrive snap connect -fs /marin_oradata /opt/NetApp/smo/mnt/-marin_oradata-20111221201340511_0 -snapname fas3140b:/vol/marin_oradata:smo_marin_marin_f_h_1_ff80808134620a890134620a8ea00001_0 -autorename -noreserve -prefixfv SnapManager_20111221201340529":
connecting /marin_oradata:
LUN copy marin_oradata.lun_0 ... created
   (original: fas3140b:/vol/marin_oradata/marin_oradata.lun)

mapping new lun(s) ... done
discovering new lun(s) ... *failed*

Cleaning up ...
  - LUN fas3140b:/vol/marin_oradata/marin_oradata.lun_0 ... deleted
0001-476 Admin error: Unable to discover the device associated with fas3140b:/vol/marin_oradata/marin_oradata.lun_0.  If multipathing in use, there may be a possible multipathing configuration error.
Please verify the configuration and then retry.

--[ERROR] FLOW-11010: Operation transitioning to abort due to prior failure.
--[ INFO] SD-00016: Discovering storage resources for /opt/NetApp/smo/mnt/-marin_oradata-20111221201340511_0.
--[ INFO] SD-00016: Discovering storage resources for /opt/NetApp/smo/mnt/-marin_oractl-20111221201340517_0.
--[ INFO] SD-00016: Discovering storage resources for /opt/NetApp/smo/mnt/-marin_oralogs-20111221201340515_0.
--[ WARN] FLOW-11011: Operation aborted
--[ERROR] FLOW-11008: Operation failed: SD-00027: Error connecting filesystem(s) [/marin_oradata] from snapshot smo_marin_marin_f_h_1_ff80808134620a890134620a8ea00001_0: SD-10016: Error executing snapdrive command "/usr/sbin/snapdrive snap connect -fs /marin_oradata /opt/NetApp/smo/mnt/-marin_oradata-20111221201340511_0 -snapname fas3140b:/vol/marin_oradata:smo_marin_marin_f_h_1_ff80808134620a890134620a8ea00001_0 -autorename -noreserve -prefixfv SnapManager_20111221201340529":
connecting /marin_oradata:
LUN copy marin_oradata.lun_0 ... created
   (original: fas3140b:/vol/marin_oradata/marin_oradata.lun)

mapping new lun(s) ... done
discovering new lun(s) ... *failed*

Cleaning up ...
  - LUN fas3140b:/vol/marin_oradata/marin_oradata.lun_0 ... deleted
0001-476 Admin error: Unable to discover the device associated with fas3140b:/vol/marin_oradata/marin_oradata.lun_0.  If multipathing in use, there may be a possible multipathing configuration error.
Please verify the configuration and then retry.

--[ERROR] SMO-13032: Cannot perform operation: Backup Create.  Root cause: SMO-11007: Error cloning from snapshot: FLOW-11019: Failure in ExecuteConnectionSteps: SD-00027: Error connecting filesystem(s) [/marin_oradata] from snapshot smo_marin_marin_f_h_1_ff80808134620a890134620a8ea00001_0: SD-10016: Error executing snapdrive command "/usr/sbin/snapdrive snap connect -fs /marin_oradata /opt/NetApp/smo/mnt/-marin_oradata-20111221201340511_0 -snapname fas3140b:/vol/marin_oradata:smo_marin_marin_f_h_1_ff80808134620a890134620a8ea00001_0 -autorename -noreserve -prefixfv SnapManager_20111221201340529":
connecting /marin_oradata:
LUN copy marin_oradata.lun_0 ... created
   (original: fas3140b:/vol/marin_oradata/marin_oradata.lun)

mapping new lun(s) ... done
discovering new lun(s) ... *failed*

Cleaning up ...
  - LUN fas3140b:/vol/marin_oradata/marin_oradata.lun_0 ... deleted
0001-476 Admin error: Unable to discover the device associated with fas3140b:/vol/marin_oradata/marin_oradata.lun_0.  If multipathing in use, there may be a possible multipathing configuration error.
Please verify the configuration and then retry.

--[ INFO] SD-00013: Beginning deletion of snapshot(s) [fas3140b:/vol/marin_oralogs:smo_marin_marin_f_h_2_ff80808134620a890134620a8ea00001_0, fas3140b:/vol/marin_oractl:smo_marin_marin_f_h_2_ff80808134620a890134620a8ea00001_0].
--[ INFO] SD-00014: Deleted snapshot(s) [fas3140b:/vol/marin_oralogs:smo_marin_marin_f_h_2_ff80808134620a890134620a8ea00001_0, fas3140b:/vol/marin_oractl:smo_marin_marin_f_h_2_ff80808134620a890134620a8ea00001_0].
--[ INFO] SD-00013: Beginning deletion of snapshot(s) [fas3140b:/vol/marin_oradata:smo_marin_marin_f_h_1_ff80808134620a890134620a8ea00001_0].
--[ INFO] SD-00014: Deleted snapshot(s) [fas3140b:/vol/marin_oradata:smo_marin_marin_f_h_1_ff80808134620a890134620a8ea00001_0].
--[ INFO] SMO-07131: Unlocked database for SnapManager operations - removed lock file "/u01/app/oracle/product/11.2.0/db_1/dbs/.sm_lock_marin.local" on host rhel5.local.
--[ INFO] SMO-07433: Returning the database to its initial state: marin(OPEN).
--[ INFO] SMO-13039: Successfully aborted operation: Backup Create
--[ERROR] SMO-13048: Backup Create Operation Status: FAILED
--[ INFO] SMO-13049: Elapsed Time: 0:01:00.435

Any ideas?

Re: SMO backup with verification fails

I love myself for quick problem solving. Problem was in snapdrive config file. Default transport protocol parameter was not specified so snapdrive could not connect snapshot to RHEL.