Environment: 50+ databases running on 11gR2 (mix of RAC & standalone), OS: Solaris 10
Task: Need to sync almost all of these dbs on a regular basis from PROD, according to different releases, in order for the developers to develop/test & verify their codes and then later QA can do regression & performance testing too.
a. what are our best & fastest options to achieve this task, currently using data pump export/import, but would like to know, is there any better option/practice that is going on out there?
b. due to the size of PROD, have to do a lot of work manually to reduce these new replica db sizes, because don't want & not needed too, that much storage @dev & QA, obviously, do share if you haven any better/expert idea to achieve this task, in a better manner.
c. also got to encrypt some data, and this is also done manually, that's the reason these sync ups took a lot of time.
On my last assignment, we used to do syncing of our dbs using LVM Snapshot/Virt-Manager, but it was Linux and using virtual machines and all was file system snap/copy & replication process and it was very fast too.
Is there any thing like LVM Snapshot on Solaris OS ... any idea/guidance will highly be appreciated?
Please advice/guide, what are our best & appropriate options.
Thanks a lot in advance, in sharing your expert thoughts, suggestions and advices.