We are on Oracle. We also perform nightly cold backups since our database is small. I have attached a few files if anyone is interested: BTW I had to rename them as .txt so they could be attached
- masctl.txt - allows you to scale the pods (i.e. Bounce/Restart the application)
- maxstg.config - used to set environment variables specifically KUBECONFIG so you can login to the cluster using oc cli. It is sourced in the masclone bash script
- MAXSTG_REFRESH.txt - Post SQL Clone script - to update emails and such
- masclone -
- Source config
- Stop Manage Application -masctl
- Export MAXPROP, MAXPROPVALUE, MAXVARS, SERVERSESSION from target database using datapump to dump file
- Copy Database files from Cold Backup (i.e. Source Database) to Target Database - BTW I just hardcode the values in the script source host, source Oracle SID and backup Path
- Create the Control File for Target Database
- Import MAXPROP, MAXPROPVALUE, MAXVARS, SERVERSESSION from dump file to Target Database
- Run Post Clone SQL Script
- Restart Manage Application -masctl
Other notes:
- The reason for exporting and importing those tables is otherwise a reactivation of manage will be triggered.
- https://www.ibm.com/support/pages/how-resolve-crypto-and-cryptox-encryption-keys-mismatch-error-during-manage-activation I referred to this document to set MXE_SECURITY_CRYPTO_KEY, MXE_SECURITY_CRYPTOX_KEY, MXE_SECURITY_OLD_CRYPTO_KEY, MXE_SECURITY_OLD_CRYPTOX_KEY to avoid Crypto issues between Production and a test environment. Basically both environments are the same but you have to make it that way
- This does not clone or deal with the MongoDB for Maximo Application Suite. This is just manage.
Happy Cloning!
Eric