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
