Data Backup and Recovery

SMO backup with verification fails

raskovicm
5,102 Views

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?

1 ACCEPTED SOLUTION

raskovicm
5,102 Views

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.

View solution in original post

1 REPLY 1

raskovicm
5,103 Views

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.

Public