topic Re: Very Very slow restore with SMO in Data Protection https://community.netapp.com/t5/Data-Protection/Very-Very-slow-restore-with-SMO/m-p/28473#M6250 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">hello</SPAN> <SPAN class="hps">mrobicho</SPAN></P><P><SPAN class="hps">Indeed</SPAN> <SPAN class="hps">mount points</SPAN> <SPAN class="hps">were with</SPAN> <SPAN class="hps atn">the "</SPAN>CIO", <SPAN class="hps">we proceeded to</SPAN> <SPAN class="hps">change the file</SPAN> <SPAN class="hps atn">"</SPAN>filesystems", dismount <SPAN class="hps">and mount </SPAN><SPAN class="hps">the</SPAN> <SPAN class="hps">mount points</SPAN></P><P><SPAN class="hps">Now</SPAN><SPAN class="hps">the</SPAN><SPAN class="hps">restore</SPAN><SPAN class="hps">has improved,</SPAN><SPAN class="hps">the transfer rate</SPAN><SPAN class="hps">is 1.5</SPAN><SPAN class="hps">minutes </SPAN><SPAN class="hps">the 1 </SPAN><SPAN class="hps">GB </SPAN><SPAN class="hps">of data. </SPAN></P><P><SPAN class="hps">We have won</SPAN> <SPAN class="hps">twice as long. !!</SPAN></P><P><SPAN class="hps">We have seen that</SPAN> <SPAN class="hps">done</SPAN> <SPAN class="hps">a lot of</SPAN> <SPAN class="hps">paging and</SPAN> <SPAN class="hps">do not know if</SPAN> <SPAN class="hps">there is any</SPAN> <SPAN class="hps">way to</SPAN> <SPAN class="hps">improve</SPAN> <SPAN class="hps">paging.</SPAN></P><P> <SPAN class="hps">thanks</SPAN></P></BODY></HTML> Fri, 07 Sep 2012 09:36:58 GMT pinrell 2012-09-07T09:36:58Z Very Very slow restore with SMO https://community.netapp.com/t5/Data-Protection/Very-Very-slow-restore-with-SMO/m-p/28458#M6248 <HTML><HEAD></HEAD><BODY><P><STRONG><SPAN class="hps">Hello</SPAN></STRONG></P><P></P><P><STRONG> <SPAN class="hps">I own a</SPAN> <SPAN class="hps">AIX 5.3</SPAN> TL9 <SPAN class="hps">with</SPAN> <SPAN class="hps">Java</SPAN> <SPAN class="hps">1.4.2</SPAN>, Oracle version 11g,&nbsp; <SPAN class="hps">Smo</SPAN> <SPAN class="hps">3.2 and SnapDrive 4.2,</SPAN> </STRONG></P><P><STRONG><SPAN class="hps"></SPAN></STRONG></P><P><STRONG><SPAN class="hps">I can say that</SPAN> <SPAN class="hps">the backups</SPAN> <SPAN class="hps">are done</SPAN> <SPAN class="hps">well</SPAN>, <SPAN class="hps">but</SPAN> <SPAN class="hps">we have made a</SPAN> <SPAN class="hps">FULL</SPAN> <SPAN class="hps">test</SPAN> <SPAN class="hps">Oracle</SPAN> <SPAN class="hps">Restore</SPAN> <SPAN class="hps">Control</SPAN> <SPAN class="hps">Files</SPAN> <SPAN class="hps">and now</SPAN> <SPAN class="hps">takes</SPAN> <SPAN class="hps">about 6 hours</SPAN>.</STRONG></P><P></P><P><STRONG> <SPAN class="hps">Anyone know what</SPAN> <SPAN class="hps">might be going</SPAN> <SPAN class="hps">to go</SPAN> <SPAN class="hps">so slow</SPAN> <SPAN class="hps">restoration.</SPAN></STRONG></P><P></P><P><STRONG> <SPAN class="hps">thanks</SPAN></STRONG></P><P><STRONG><SPAN class="hps"></SPAN></STRONG></P><P><STRONG><SPAN class="hps">Note:</SPAN></STRONG></P><P><STRONG><SPAN class="hps">Each copy</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">Data</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">taking about</SPAN> <SPAN class="hps">40 minutes and</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">only</SPAN> <SPAN class="hps">12 Gb</SPAN> <SPAN class="hps">each</SPAN> <SPAN class="hps">Data</SPAN></STRONG></P><P><STRONG><SPAN class="hps">_____________________________________________________________________________________</SPAN></STRONG></P><P>--[ INFO] SMO-13036: Starting operation Backup Restore on host saptest2</P><P>--[ INFO] SMO-13046: Operation GUID 402881ab399b23ea01399b23f49f0001 starting on Profile BCKT02</P><P>--[ INFO] SMO-07431: Saving starting state of the database: T02(SHUTDOWN).</P><P>--[ INFO] ORACLE-20000: Changing state for database instance T02 from SHUTDOWN to STARTED.</P><P>--[ INFO] SMO-07431: Saving starting state of the database: T02(SHUTDOWN).</P><P>--[ INFO] SMO-07127: Locked database for SnapManager operations - created lock file "/oracle/T02/11203/dbs/.sm_lock_T02" on host saptest2</P><P>--[ INFO] SMO-07200: Beginning restore of database "T02".</P><P>--[ INFO] SD-00022: Querying for snapshot NETAPP1:/vol/volSaptest02BinSas:smo_bckt02_t02_f_h_2_402881ab399abe8701399abe90040001_0.</P><P>--[ INFO] SD-00023: Finished querying for snapshot NETAPP1:/vol/volSaptest02BinSas:smo_bckt02_t02_f_h_2_402881ab399abe8701399abe90040001_0.</P><P>--[ INFO] SD-00022: Querying for snapshot NETAPP1:/vol/volSaptest02DafileSas:smo_bckt02_t02_f_h_2_402881ab399abe8701399abe90040001_0.</P><P>--[ INFO] SD-00023: Finished querying for snapshot NETAPP1:/vol/volSaptest02DafileSas:smo_bckt02_t02_f_h_2_402881ab399abe8701399abe90040001_0.</P><P>--[ INFO] SD-00022: Querying for snapshot NETAPP1:/vol/volSaptest02ArchiveSas:smo_bckt02_t02_f_h_2_402881ab399abe8701399abe90040001_0.</P><P>--[ INFO] SD-00023: Finished querying for snapshot NETAPP1:/vol/volSaptest02ArchiveSas:smo_bckt02_t02_f_h_2_402881ab399abe8701399abe90040001_0.</P><P>--[ INFO] SD-00022: Querying for snapshot NETAPP1:/vol/volSaptest02RedoSas:smo_bckt02_t02_f_h_2_402881ab399abe8701399abe90040001_0.</P><P>--[ INFO] SD-00023: Finished querying for snapshot NETAPP1:/vol/volSaptest02RedoSas:smo_bckt02_t02_f_h_2_402881ab399abe8701399abe90040001_0.</P><P>--[ INFO] SD-00016: Discovering storage resources for /oracle/T02.</P><P>--[ INFO] SD-00017: Finished storage discovery for /oracle/T02.</P><P>--[ INFO] SD-00016: Discovering storage resources for /oracle/T02/origlogA.</P><P>--[ INFO] SD-00017: Finished storage discovery for /oracle/T02/origlogA.</P><P>--[ INFO] SD-00040: Beginning to discover filesystem(s) upon host volume group saptest02redovg.</P><P>--[ INFO] SD-00041: Finished discovering filesystem(s) upon host volume group saptest02redovg.</P><P>--[ INFO] SD-00040: Beginning to discover filesystem(s) upon host volume group saptest02vg.</P><P>--[ INFO] SD-00041: Finished discovering filesystem(s) upon host volume group saptest02vg.</P><P>--[ INFO] SD-00040: Beginning to discover filesystem(s) upon host volume group saptest02binvg.</P><P>--[ INFO] SD-00041: Finished discovering filesystem(s) upon host volume group saptest02binvg.</P><P>--[ INFO] SD-00025: Beginning to connect filesystem(s) [/oracle/T02, /oracle/T02/origlogA, /oracle/T02/sapdata1] from snapshot smo_bckt02_t02_f_h_2_402881ab399abe8701399abe90040001_0.</P><P>--[ INFO] SD-00016: Discovering storage resources for /opt/Ontap/smo/mnt/-oracle-T02-20120906123503721_0.</P><P>--[ INFO] SD-00017: Finished storage discovery for /opt/Ontap/smo/mnt/-oracle-T02-20120906123503721_0.</P><P>--[ INFO] SD-00016: Discovering storage resources for /opt/Ontap/smo/mnt/-oracle-T02-origlogA-20120906123503710_0.</P><P>--[ INFO] SD-00017: Finished storage discovery for /opt/Ontap/smo/mnt/-oracle-T02-origlogA-20120906123503710_0.</P><P>--[ INFO] SD-00016: Discovering storage resources for /opt/Ontap/smo/mnt/-oracle-T02-sapdata1-20120906123503719_0.</P><P>--[ INFO] SD-00017: Finished storage discovery for /opt/Ontap/smo/mnt/-oracle-T02-sapdata1-20120906123503719_0.</P><P>--[ INFO] SD-00026: Finished connecting filesystem(s) [/oracle/T02, /oracle/T02/origlogA, /oracle/T02/sapdata1] from snapshot smo_bckt02_t02_f_h_2_402881ab399abe8701399abe90040001_0.</P><P>--[ INFO] PLAT-00001: Copying file "/opt/Ontap/smo/mnt/-oracle-T02-20120906123503721_0/saparch/cntrl/SMOBakCtl_1346920993479_2" to "/oracle/T02/saparch/cntrl/SMOBakCtl_1346920993479_2".</P><P>--[ INFO] PLAT-00001: Copying file "/opt/Ontap/smo/mnt/-oracle-T02-sapdata1-20120906123503719_0/system_1/cntrl/SMOBakCtl_1346920992408_0" to "/oracle/T02/sapdata1/system_1/cntrl/SMOBakCtl_1346920992408_0".</P><P>--[ INFO] PLAT-00001: Copying file "/opt/Ontap/smo/mnt/-oracle-T02-origlogA-20120906123503710_0/cntrl/SMOBakCtl_1346920992976_1" to "/oracle/T02/origlogA/cntrl/SMOBakCtl_1346920992976_1".</P><P>--[ INFO] SD-00016: Discovering storage resources for saptest02vg_0.</P><P>--[ INFO] SD-00017: Finished storage discovery for saptest02vg_0.</P><P>--[ INFO] SD-00016: Discovering storage resources for saptest02redo_0.</P><P>--[ INFO] SD-00017: Finished storage discovery for saptest02redo_0.</P><P>--[ INFO] SD-00016: Discovering storage resources for saptest02binv_0.</P><P>--[ INFO] SD-00017: Finished storage discovery for saptest02binv_0.</P><P>--[ INFO] SD-00037: Beginning to disconnect volume groups [saptest02redo_0, saptest02vg_0, saptest02binv_0].</P><P>--[ INFO] SD-00038: Finished disconnecting volume groups [saptest02redo_0, saptest02vg_0, saptest02binv_0].</P><P>--[ INFO] PLAT-00001: Copying file "/oracle/T02/saparch/cntrl/SMOBakCtl_1346920993479_2" to "/oracle/T02/saparch/cntrl/cntrlT02.dbf".</P><P>--[ INFO] PLAT-00001: Copying file "/oracle/T02/saparch/cntrl/SMOBakCtl_1346920993479_2" to "/oracle/T02/sapdata1/system_1/cntrl/cntrlT02.dbf".</P><P>--[ INFO] PLAT-00001: Copying file "/oracle/T02/saparch/cntrl/SMOBakCtl_1346920993479_2" to "/oracle/T02/origlogA/cntrl/cntrlT02.dbf".</P><P>--[ INFO] ORACLE-20000: Changing state for database instance T02 from STARTED to MOUNTED.</P><P>--[ INFO] ORACLE-20009: Attempting to reconnect to instance T02 after shutdown/startup.</P><P>--[ INFO] ORACLE-20011: Reconnect to instance T02 successful.</P><P>--[ INFO] SD-00022: Querying for snapshot NETAPP1:/vol/volSaptest02DafileSas:smo_bckt02_t02_f_h_1_402881ab399abe8701399abe90040001_0.</P><P>--[ INFO] SD-00023: Finished querying for snapshot NETAPP1:/vol/volSaptest02DafileSas:smo_bckt02_t02_f_h_1_402881ab399abe8701399abe90040001_0.</P><P>--[ INFO] SD-00016: Discovering storage resources for /oracle/T02/sapdata1.</P><P>--[ INFO] SD-00017: Finished storage discovery for /oracle/T02/sapdata1.</P><P>--[ INFO] SD-00016: Discovering storage resources for /oracle/T02/sapdata1.</P><P>--[ INFO] SD-00017: Finished storage discovery for /oracle/T02/sapdata1.</P><P>--[ INFO] SD-00016: Discovering storage resources for /oracle/T02/origlogB.</P><P>--[ INFO] SD-00017: Finished storage discovery for /oracle/T02/origlogB.</P><P>--[ INFO] SD-00016: Discovering storage resources for /oracle/T02/mirrlogA.</P><P>--[ INFO] SD-00017: Finished storage discovery for /oracle/T02/mirrlogA.</P><P>--[ INFO] SD-00016: Discovering storage resources for /oracle/T02.</P><P>--[ INFO] SD-00017: Finished storage discovery for /oracle/T02.</P><P>--[ INFO] SD-00016: Discovering storage resources for /oracle/T02/mirrlogB.</P><P>--[ INFO] SD-00017: Finished storage discovery for /oracle/T02/mirrlogB.</P><P>--[ INFO] SD-00016: Discovering storage resources for /oracle/T02/origlogA.</P><P>--[ INFO] SD-00017: Finished storage discovery for /oracle/T02/origlogA.</P><P>--[ INFO] SD-00040: Beginning to discover filesystem(s) upon host volume group saptest02redovg.</P><P>--[ INFO] SD-00041: Finished discovering filesystem(s) upon host volume group saptest02redovg.</P><P>--[ INFO] SD-00040: Beginning to discover filesystem(s) upon host volume group saptest02vg.</P><P>--[ INFO] SD-00041: Finished discovering filesystem(s) upon host volume group saptest02vg.</P><P>--[ INFO] SD-00040: Beginning to discover filesystem(s) upon host volume group saptest02binvg.</P><P>--[ INFO] SD-00041: Finished discovering filesystem(s) upon host volume group saptest02binvg.</P><P>--[ INFO] SD-00025: Beginning to connect filesystem(s) [/oracle/T02/sapdata1] from snapshot smo_bckt02_t02_f_h_1_402881ab399abe8701399abe90040001_0.</P><P>--[ INFO] SD-00016: Discovering storage resources for /opt/Ontap/smo/mnt/-oracle-T02-sapdata1-20120906124052655_1.</P><P>--[ INFO] SD-00017: Finished storage discovery for /opt/Ontap/smo/mnt/-oracle-T02-sapdata1-20120906124052655_1.</P><P>--[ INFO] SD-00026: Finished connecting filesystem(s) [/oracle/T02/sapdata1] from snapshot smo_bckt02_t02_f_h_1_402881ab399abe8701399abe90040001_0.</P><P>--[ INFO] PLAT-00001: Copying file "/opt/Ontap/smo/mnt/-oracle-T02-sapdata1-20120906124052655_1/p01_3/p01.data3" to "/oracle/T02/sapdata1/p01_3/p01.data3".</P><P>--[ INFO] PLAT-00001: Copying file "/opt/Ontap/smo/mnt/-oracle-T02-sapdata1-20120906124052655_1/p01_4/p01.data4" to "/oracle/T02/sapdata1/p01_4/p01.data4".</P><P>--[ INFO] PLAT-00001: Copying file "/opt/Ontap/smo/mnt/-oracle-T02-sapdata1-20120906124052655_1/p01_5/p01.data5" to "/oracle/T02/sapdata1/p01_5/p01.data5".</P><P>--[ INFO] PLAT-00001: Copying file "/opt/Ontap/smo/mnt/-oracle-T02-sapdata1-20120906124052655_1/p01_12/p01.data12" to "/oracle/T02/sapdata1/p01_12/p01.data12".</P><P>--[ INFO] PLAT-00001: Copying file "/opt/Ontap/smo/mnt/-oracle-T02-sapdata1-20120906124052655_1/p01_10/p01.data10" to "/oracle/T02/sapdata1/p01_10/p01.data10".</P><P>--[ INFO] PLAT-00001: Copying file "/opt/Ontap/smo/mnt/-oracle-T02-sapdata1-20120906124052655_1/p01_6/p01.data6" to "/oracle/T02/sapdata1/p01_6/p01.data6".</P><P>--[ INFO] PLAT-00001: Copying file "/opt/Ontap/smo/mnt/-oracle-T02-sapdata1-20120906124052655_1/p01_11/p01.data11" to "/oracle/T02/sapdata1/p01_11/p01.data11".</P><P>--[ INFO] PLAT-00001: Copying file "/opt/Ontap/smo/mnt/-oracle-T02-sapdata1-20120906124052655_1/p01_7/p01.data7" to "/oracle/T02/sapdata1/p01_7/p01.data7".</P><P></P><P></P><P></P><P><STRONG><SPAN class="hps">Each copy</SPAN> <SPAN class="hps">of</SPAN> <SPAN class="hps">Data</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">taking about</SPAN> <SPAN class="hps">40 minutes and</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">only</SPAN> <SPAN class="hps">12 Mb</SPAN> <SPAN class="hps">each</SPAN> <SPAN class="hps">Data</SPAN></STRONG></P></BODY></HTML> Thu, 05 Jun 2025 06:19:31 GMT https://community.netapp.com/t5/Data-Protection/Very-Very-slow-restore-with-SMO/m-p/28458#M6248 pinrell 2025-06-05T06:19:31Z Re: Very Very slow restore with SMO https://community.netapp.com/t5/Data-Protection/Very-Very-slow-restore-with-SMO/m-p/28464#M6249 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Basically, I've been on the same problem since yesterday. IHAC encountering the same problem. </P><P></P><P>The root cause seems to be with mount options. Data files are mounted with option "cio". When the SnapShot is connected (with this option) the copy is very slow (sequential access are slower).</P><P></P><P>I don't have any idea how get around it.</P><P></P><P>Regards,</P><P>Mathias</P></BODY></HTML> Thu, 06 Sep 2012 15:28:03 GMT https://community.netapp.com/t5/Data-Protection/Very-Very-slow-restore-with-SMO/m-p/28464#M6249 Mathias_Robichon 2012-09-06T15:28:03Z Re: Very Very slow restore with SMO https://community.netapp.com/t5/Data-Protection/Very-Very-slow-restore-with-SMO/m-p/28473#M6250 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">hello</SPAN> <SPAN class="hps">mrobicho</SPAN></P><P><SPAN class="hps">Indeed</SPAN> <SPAN class="hps">mount points</SPAN> <SPAN class="hps">were with</SPAN> <SPAN class="hps atn">the "</SPAN>CIO", <SPAN class="hps">we proceeded to</SPAN> <SPAN class="hps">change the file</SPAN> <SPAN class="hps atn">"</SPAN>filesystems", dismount <SPAN class="hps">and mount </SPAN><SPAN class="hps">the</SPAN> <SPAN class="hps">mount points</SPAN></P><P><SPAN class="hps">Now</SPAN><SPAN class="hps">the</SPAN><SPAN class="hps">restore</SPAN><SPAN class="hps">has improved,</SPAN><SPAN class="hps">the transfer rate</SPAN><SPAN class="hps">is 1.5</SPAN><SPAN class="hps">minutes </SPAN><SPAN class="hps">the 1 </SPAN><SPAN class="hps">GB </SPAN><SPAN class="hps">of data. </SPAN></P><P><SPAN class="hps">We have won</SPAN> <SPAN class="hps">twice as long. !!</SPAN></P><P><SPAN class="hps">We have seen that</SPAN> <SPAN class="hps">done</SPAN> <SPAN class="hps">a lot of</SPAN> <SPAN class="hps">paging and</SPAN> <SPAN class="hps">do not know if</SPAN> <SPAN class="hps">there is any</SPAN> <SPAN class="hps">way to</SPAN> <SPAN class="hps">improve</SPAN> <SPAN class="hps">paging.</SPAN></P><P> <SPAN class="hps">thanks</SPAN></P></BODY></HTML> Fri, 07 Sep 2012 09:36:58 GMT https://community.netapp.com/t5/Data-Protection/Very-Very-slow-restore-with-SMO/m-p/28473#M6250 pinrell 2012-09-07T09:36:58Z