<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic SAP Oracle Refresh on HP-UX in ONTAP Discussions</title>
    <link>https://community.netapp.com/t5/ONTAP-Discussions/SAP-Oracle-Refresh-on-HP-UX/m-p/144107#M32492</link>
    <description>&lt;P&gt;We are now refershing our SAP ERP (PRD ==&amp;gt; QAS) running on HP-UX with oracle database using the following method&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;SAP version: SAP ERP 6.0 EHP8 (3 landscape + 2 sandbox)&lt;/P&gt;
&lt;P&gt;Current: FAS Ontap 7-mode, FCP, SAS disk, SD flash.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;1) Hot backup using snapshot for PRD&lt;/P&gt;
&lt;P&gt;2) Remove old clone if any&lt;/P&gt;
&lt;P&gt;3) Clone it to a new set of temp vol/qtree/lun in NetApp&lt;/P&gt;
&lt;P&gt;3) Map the temp vol/qtree/lun to new igroup in NetApp&lt;/P&gt;
&lt;P&gt;4) Present new igroup and mount into QAS on separate mount point /tmp/oracle/....&lt;/P&gt;
&lt;P&gt;5) Run the cp script in QAS and overwrite the oracle datafile, control file, logs and etc&lt;/P&gt;
&lt;P&gt;6) Recover database in QAS&lt;/P&gt;
&lt;P&gt;7) Post-refresh steps in QAS&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Are there anyway that we can replace the step below?&lt;/P&gt;
&lt;P&gt;Note: We don't use Snapmanager for HP-UX and also Oncommand Workflow Automator&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;5)&amp;nbsp;&lt;SPAN&gt;Run the cp script in QAS and overwrite the oracle datafile, control file, logs and etc&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Could we do the following or any better way to do so?&lt;/P&gt;
&lt;P&gt;1) Shutdown QAS, umount exisint mount point to the LUNs presented from NetApp&lt;/P&gt;
&lt;P&gt;1.1) Do we need to remove the map LUNs as well ??&lt;/P&gt;
&lt;P&gt;2) Snapshot (backup) and clone from PRD vol/qtree/lun to existing QAS vol/qtree/lun in Netapp. Overwriting it.&lt;/P&gt;
&lt;P&gt;3) Remapping the igroup LUNs&amp;nbsp; correctly in NetApp&lt;/P&gt;
&lt;P&gt;4)&amp;nbsp;&lt;SPAN&gt;Present new igroup, discover and mount into QAS&amp;nbsp;on original SAP mount point&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;6) Recover database in QAS&lt;/P&gt;
&lt;P&gt;7) Post-refresh steps in QAS&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 04 Jun 2025 13:12:04 GMT</pubDate>
    <dc:creator>penangmis</dc:creator>
    <dc:date>2025-06-04T13:12:04Z</dc:date>
    <item>
      <title>SAP Oracle Refresh on HP-UX</title>
      <link>https://community.netapp.com/t5/ONTAP-Discussions/SAP-Oracle-Refresh-on-HP-UX/m-p/144107#M32492</link>
      <description>&lt;P&gt;We are now refershing our SAP ERP (PRD ==&amp;gt; QAS) running on HP-UX with oracle database using the following method&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;SAP version: SAP ERP 6.0 EHP8 (3 landscape + 2 sandbox)&lt;/P&gt;
&lt;P&gt;Current: FAS Ontap 7-mode, FCP, SAS disk, SD flash.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;1) Hot backup using snapshot for PRD&lt;/P&gt;
&lt;P&gt;2) Remove old clone if any&lt;/P&gt;
&lt;P&gt;3) Clone it to a new set of temp vol/qtree/lun in NetApp&lt;/P&gt;
&lt;P&gt;3) Map the temp vol/qtree/lun to new igroup in NetApp&lt;/P&gt;
&lt;P&gt;4) Present new igroup and mount into QAS on separate mount point /tmp/oracle/....&lt;/P&gt;
&lt;P&gt;5) Run the cp script in QAS and overwrite the oracle datafile, control file, logs and etc&lt;/P&gt;
&lt;P&gt;6) Recover database in QAS&lt;/P&gt;
&lt;P&gt;7) Post-refresh steps in QAS&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Are there anyway that we can replace the step below?&lt;/P&gt;
&lt;P&gt;Note: We don't use Snapmanager for HP-UX and also Oncommand Workflow Automator&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;5)&amp;nbsp;&lt;SPAN&gt;Run the cp script in QAS and overwrite the oracle datafile, control file, logs and etc&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Could we do the following or any better way to do so?&lt;/P&gt;
&lt;P&gt;1) Shutdown QAS, umount exisint mount point to the LUNs presented from NetApp&lt;/P&gt;
&lt;P&gt;1.1) Do we need to remove the map LUNs as well ??&lt;/P&gt;
&lt;P&gt;2) Snapshot (backup) and clone from PRD vol/qtree/lun to existing QAS vol/qtree/lun in Netapp. Overwriting it.&lt;/P&gt;
&lt;P&gt;3) Remapping the igroup LUNs&amp;nbsp; correctly in NetApp&lt;/P&gt;
&lt;P&gt;4)&amp;nbsp;&lt;SPAN&gt;Present new igroup, discover and mount into QAS&amp;nbsp;on original SAP mount point&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;6) Recover database in QAS&lt;/P&gt;
&lt;P&gt;7) Post-refresh steps in QAS&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 04 Jun 2025 13:12:04 GMT</pubDate>
      <guid>https://community.netapp.com/t5/ONTAP-Discussions/SAP-Oracle-Refresh-on-HP-UX/m-p/144107#M32492</guid>
      <dc:creator>penangmis</dc:creator>
      <dc:date>2025-06-04T13:12:04Z</dc:date>
    </item>
  </channel>
</rss>

