Data Backup and Recovery

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

StSonny
2,208 Views

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
Public