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.
PEG
IN
Amazon Corp
US
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?
Pegasystems Inc.
US
easiest way is to use oracle import/export native tools.
Amazon Corp
US
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.
Amazon Corp
US
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?
Accepted Solution
Pegasystems Inc.
US
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.