Moving from one Database Server to Another
We need to move our Environments from One Oracle Database Server to another. What is the best way to do a lift and shift from one Oracle Database Server to Another? Can I use the Migrate.sh script to define source and target databases and perform the move? Any other way of doing this.
I did come across the migration script while going through the same documentation. My question is can we use that script to replicate DB from once server to another?
easiest way is to use oracle import/export native tools.
We don't have the privilege to do that imp/exp(probably DBA can), so was looking at using the migrate script to achieve this.
Is it recommended for large Databases like Pega to use exp/imp? Any previous experiences? Can we just bring up a plain installation of Pega, do a consolidated RAP build and install on that base installation? Will that work?
I do not think we have preference one way or another. Both options should work.
Pros and Cons that I can see for each (feel free to provide your own takes - community members!)
Native tools
Pros: fast, easy and clean/complete. does not require a running prpc instance.
Cons: need database server access
Import RAP
Pros: no database server access needed.
Cons: need to make sure all the necessary data in the RAPs; manual steps. requiring a running prpc instance.
Please refer https://pdn.pega.com/documents/pega-72-platform-upgrade-guide