Hi Team,
We are planning to perform a data migration from Oracle to PostgreSQL using Ora2Pg.
The main goal is to retain the latest 3 months of active data in Oracle and migrate all older data to PostgreSQL for backup and archival purposes.
I’m looking for a detailed reference or document that covers the following:
- Step-by-step migration and archival process from Oracle to PostgreSQL
- Ora2Pg configuration for selective data export (older than 3 months)
- Validation and verification approach post-migration
- PostgreSQL server sizing and configuration guidelines for archived data
- Any best practices, tuning parameters, or automation methods (shell/cron/Ansible) for ongoing archival
If anyone has performed a similar migration or can share documentation, templates, or suggestions, it would be greatly appreciated.
Thanks & Regards,
Vignesh D