[progress Communities] [progress Openedge Abl] Forum Post: Re: Openedge Database And Netapp...

Status
Not open for further replies.
R

Rohan

Guest
It is worth noting that you could also take your snap while the databases are down, instead of using proquiet. For reference below, "[NA:.......]" means various NetApp snapdrive and OS shell commands in script(s). The entire process amounts to more than 1000 lines of scripts, and it takes about 40mins for around 800GB. The time it takes is not closely tied to the data size though, but more proportional to the number of filesystems etc. The OpenEdge related parts of the process are below. ---- On the SOURCE: proquiet enable (and wait for confirm) [NA: snap here] Snap all filesystems which any database file is on. Note on Temporary Directory (-T): if you do not include these in the snap, the directories need to be re-created manually on the target if you do include these in the snap, they should be emptied on the target proquiet disable (and confirm) On the TARGET (the target could be a different system, or somewhere else on the same system) (Final backup of what you are about to delete - your choice!) Shutdown the target databases Remove the target databases [NA: Remove all target filesystems, filesystem mount points, logical volumes, volume groups, LUNs etc] [NA: Optional, delete old snap that you are no longer using] [NA: Connect to the latest snap] There will be db.lk files in place which belong to the source running instances - these need to be removed If your database paths have changed from the source, you will need to: Replace the db.st file (from the source) with another one with the correct details Run prostrct repair Clear out / create -T directories Start databases. ---- Your starting point will be to get your NetApp resource to install Snapdrive, then begin managing your filesystems for OpenEdge from the OS. For details on NetApp requirements, you will be much better served on the NetApp websites and forums.

Continue reading...
 
Status
Not open for further replies.
Top