Data Backup and Recovery Discussions

SMO-13032: Cannot perform operation: Backup Restore. Root cause: SMO-11005

StSonny

NFS volumes on a .99.xx subnet. Therefore, they are only exported to the .99 addresses.
SMO or snapdrive tries to use the default subnet ( in this case 117.xx ) when a restore operation is attempted.
We do not want to add the .117 subnet to the export list on filer to do a database restore via smo.
Is there an option that will override this undesired behavior?

 

--[ INFO] SMO-13036: Starting operation Backup Restore on host testdb2.lnx.aci.corp.net
--[ INFO] SMO-13046: Operation GUID 8ae4f5e955a712f50155a712f8f40001 starting on Profile TSTFOOT3
--[ INFO] SMO-22001: Started adding the Backup Restore operation in history.
--[ INFO] SMO-07431: Saving starting state of the database: tstfoot3(OPEN).
--[ INFO] SMO-07431: Saving starting state of the database: tstfoot3(OPEN).
--[ INFO] SMO-07127: Locked database for SnapManager operations - created lock file "/orabase/orahomes/12.1.0.2.160119/dbs/.sm_lock_tstfoot3" on host testdb2.lnx.aci.corp.net.
--[ INFO] ORACLE-20000: Changing state for database instance tstfoot3 from OPEN to STARTED.
--[ INFO] SMO-07200: Beginning restore of database "TSTFOOT3".
--[ INFO] SD-00022: Querying for snapshot stlpsan02:/vol/testdb2_tstfoot3_oraarc_nfs:tstfoot3_20160630_194042_2_8ae4f5e955a3e5f50155a3e5faa90001_0.
--[ INFO] SD-00023: Finished querying for snapshot stlpsan02:/vol/testdb2_tstfoot3_oraarc_nfs:tstfoot3_20160630_194042_2_8ae4f5e955a3e5f50155a3e5faa90001_0.
--[ INFO] SD-00022: Querying for snapshot stlpsan02:/vol/testdb2_tstfoot3_oractl_nfs:tstfoot3_20160630_194042_2_8ae4f5e955a3e5f50155a3e5faa90001_0.
--[ INFO] SD-00023: Finished querying for snapshot stlpsan02:/vol/testdb2_tstfoot3_oractl_nfs:tstfoot3_20160630_194042_2_8ae4f5e955a3e5f50155a3e5faa90001_0.
--[ INFO] SD-00016: Discovering storage resources for /mnt/tstfoot3/oractl.
--[ INFO] SD-00017: Finished storage discovery for /mnt/tstfoot3/oractl.
--[ INFO] SD-00004: Beginning restore of filesystem(s) [/mnt/tstfoot3/oractl] from snapshot tstfoot3_20160630_194042_2_8ae4f5e955a3e5f50155a3e5faa90001_0.
--[ INFO] SD-00005: Finished restore of filesystem(s) [/mnt/tstfoot3/oractl] from snapshot tstfoot3_20160630_194042_2_8ae4f5e955a3e5f50155a3e5faa90001_0.
--[ INFO] PLAT-00001: Copying file "/mnt/tstfoot3/oractl/SMOBakCtl_1467333637285_1" to "/mnt/tstfoot3/oractl/control01.ctl".
--[ INFO] PLAT-00001: Copying file "/mnt/tstfoot3/oractl/SMOBakCtl_1467333637285_1" to "/mnt/tstfoot3/oractl/control02.ctl".
--[ INFO] ORACLE-20000: Changing state for database instance tstfoot3 from STARTED to MOUNTED.
--[ INFO] ORACLE-20009: Attempting to reconnect to instance tstfoot3 after shutdown/startup.
--[ INFO] ORACLE-20011: Reconnect to instance tstfoot3 successful.
--[ INFO] SD-00022: Querying for snapshot stlpsan02:/vol/testdb2_tstfoot3_oradata_nfs:tstfoot3_20160630_194021_1_8ae4f5e955a3e5f50155a3e5faa90001_0.
--[ INFO] SD-00023: Finished querying for snapshot stlpsan02:/vol/testdb2_tstfoot3_oradata_nfs:tstfoot3_20160630_194021_1_8ae4f5e955a3e5f50155a3e5faa90001_0.
--[ INFO] SD-00016: Discovering storage resources for /mnt/tstfoot3/oratemp.
--[ INFO] SD-00017: Finished storage discovery for /mnt/tstfoot3/oratemp.
--[ INFO] SD-00016: Discovering storage resources for /mnt/tstfoot3/oraarc.
--[ INFO] SD-00017: Finished storage discovery for /mnt/tstfoot3/oraarc.
--[ INFO] SD-00016: Discovering storage resources for /mnt/tstfoot3/oractl.
--[ INFO] SD-00017: Finished storage discovery for /mnt/tstfoot3/oractl.
--[ INFO] SD-00016: Discovering storage resources for /mnt/tstfoot3/oraredo.
--[ INFO] SD-00017: Finished storage discovery for /mnt/tstfoot3/oraredo.
--[ INFO] SD-00052: Beginning preview of volume restore of [stlpsan02:/vol/testdb2_tstfoot3_oradata_nfs] (with host-side resources [/mnt/tstfoot3/oradata]) from snapshots [[tstfoot3_20160630_194021_1_8ae4f5e955a3e5f50155a3e5faa90001_0]]
--[ INFO] SD-10030: Waiting for SnapDrive job (running)
--[ INFO] SD-10030: Waiting for SnapDrive job (running)
--[ INFO] SD-10030: Waiting for SnapDrive job (running)
--[ INFO] SD-10030: Waiting for SnapDrive job (running)
--[ INFO] SD-10030: Waiting for SnapDrive job (running)
--[ INFO] SD-10030: Waiting for SnapDrive job (completed)
--[ERROR] FLOW-11019: Failure in CalculateRestoreScope: SD-10028: SnapDrive Error (id:1859 code:100) The host's testdb2.lnx.aci.corp.net interfaces, bond0.117 are not allowed to access the path /vol/testdb2_tstfoot3_oradata_nfs on the storage system stlpsan02-nfs. To resolve this problem, please configure the export permission for path /vol/testdb2_tstfoot3_oradata_nfs on the storage system stlpsan02-nfs so that host testdb2.lnx.aci.corp.net can access the path.
--[ERROR] FLOW-11008: Operation failed: SD-10028: SnapDrive Error (id:1859 code:100) The host's testdb2.lnx.aci.corp.net interfaces, bond0.117 are not allowed to access the path /vol/testdb2_tstfoot3_oradata_nfs on the storage system stlpsan02-nfs. To resolve this problem, please configure the export permission for path /vol/testdb2_tstfoot3_oradata_nfs on the storage system stlpsan02-nfs so that host testdb2.lnx.aci.corp.net can access the path.
--[ERROR] SMO-11005: Error restoring Snapshot copy: FLOW-11019: Failure in CalculateRestoreScope: SD-10028: SnapDrive Error (id:1859 code:100) The host's testdb2.lnx.aci.corp.net interfaces, bond0.117 are not allowed to access the path /vol/testdb2_tstfoot3_oradata_nfs on the storage system stlpsan02-nfs. To resolve this problem, please configure the export permission for path /vol/testdb2_tstfoot3_oradata_nfs on the storage system stlpsan02-nfs so that host testdb2.lnx.aci.corp.net can access the path.
--[ERROR] SMO-13032: Cannot perform operation: Backup Restore. Root cause: SMO-11005: Error restoring Snapshot copy: FLOW-11019: Failure in CalculateRestoreScope: SD-10028: SnapDrive Error (id:1859 code:100) The host's testdb2.lnx.aci.corp.net interfaces, bond0.117 are not allowed to access the path /vol/testdb2_tstfoot3_oradata_nfs on the storage system stlpsan02-nfs. To resolve this problem, please configure the export permission for path /vol/testdb2_tstfoot3_oradata_nfs on the storage system stlpsan02-nfs so that host testdb2.lnx.aci.corp.net can access the path.
--[ INFO] SMO-07131: Unlocked database for SnapManager operations - removed lock file "/orabase/orahomes/12.1.0.2.160119/dbs/.sm_lock_tstfoot3" on host testdb2.lnx.aci.corp.net.
--[ INFO] SMO-07433: Returning the database to its initial state: tstfoot3(OPEN).
--[ INFO] ORACLE-20000: Changing state for database instance tstfoot3 from MOUNTED to OPEN.
--[ INFO] ORACLE-20032: Opening database tstfoot3 with READ WRITE NORESETLOGS option.
--[ WARN] SMO-07434: Could not return database to its original state. Error: ORACLE-20001: Error trying to change state to OPEN for database instance tstfoot3: ORACLE-10003: Error executing SQL "ALTER DATABASE OPEN READ WRITE NORESETLOGS" against Oracle database tstfoot3: ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

--[ INFO] SMO-13039: Successfully aborted operation: Backup Restore
--[ERROR] SMO-13048: Backup Restore Operation Status: FAILED
--[ INFO] SMO-22002: Successfully recorded the Backup Restore operation in history.
--[ INFO] SMO-14557: Sending E-Mail notification...
--[ INFO] SMO-14558: E-Mail notification sent successfully.
--[ INFO] SMO-13049: Elapsed Time: 0:04:34.727

0 REPLIES 0
Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public