ONTAP Discussions

SAP Oracle Refresh on HP-UX

penangmis
1,289 Views

We are now refershing our SAP ERP (PRD ==> QAS) running on HP-UX with oracle database using the following method

 

SAP version: SAP ERP 6.0 EHP8 (3 landscape + 2 sandbox)

Current: FAS Ontap 7-mode, FCP, SAS disk, SD flash.

 

1) Hot backup using snapshot for PRD

2) Remove old clone if any

3) Clone it to a new set of temp vol/qtree/lun in NetApp

3) Map the temp vol/qtree/lun to new igroup in NetApp

4) Present new igroup and mount into QAS on separate mount point /tmp/oracle/....

5) Run the cp script in QAS and overwrite the oracle datafile, control file, logs and etc

6) Recover database in QAS

7) Post-refresh steps in QAS

 

Are there anyway that we can replace the step below?

Note: We don't use Snapmanager for HP-UX and also Oncommand Workflow Automator

 

5) Run the cp script in QAS and overwrite the oracle datafile, control file, logs and etc

 

Could we do the following or any better way to do so?

1) Shutdown QAS, umount exisint mount point to the LUNs presented from NetApp

1.1) Do we need to remove the map LUNs as well ??

2) Snapshot (backup) and clone from PRD vol/qtree/lun to existing QAS vol/qtree/lun in Netapp. Overwriting it.

3) Remapping the igroup LUNs  correctly in NetApp

4) Present new igroup, discover and mount into QAS on original SAP mount point

6) Recover database in QAS

7) Post-refresh steps in QAS

 

0 REPLIES 0
Public