Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL

От

Avinash Kumar

Тема

Дата

20 апреля 2020 г. в 15:38:45

Msg-id

CAN0TujfDsNKRN_PqOcM-_ar3Pb_JhvDes79i62cFu2aUb5Fhjw@mail.gmail.com

обсуждение

Ответ на

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL (Scott Ribe)

Список

pgsql-admin

Дерево обсуждения

Exporting TBs of data in Oracle schema/database into CSV format tomigrate into PostgreSQL Prashant Kulkarni <ppk10.prashant@gmail.com> 20 апреля 2020 г. в 11:53:18

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL manish yadav <manishy174@yahoo.co.in> 20 апреля 2020 г. в 14:56:58

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL pinker <pinker@onet.eu> 21 апреля 2020 г. в 10:43:21

RE: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL <soumik.bhattacharjee@kpn.com> 20 апреля 2020 г. в 11:58:42

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL "Peter M. Groen" <peter@osdev.nl> 21 апреля 2020 г. в 08:27:55

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Thomas Kellerer <shammat@gmx.net> 20 апреля 2020 г. в 13:27:55

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Pepe TD Vo <pepevo@yahoo.com> 20 апреля 2020 г. в 14:02:53

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL "Jonah H. Harris" <jonah.harris@gmail.com> 24 апреля 2020 г. в 16:57:18

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Pepe TD Vo <pepevo@yahoo.com> 24 апреля 2020 г. в 18:11:21

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Laurenz Albe <laurenz.albe@cybertec.at> 20 апреля 2020 г. в 14:39:39

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Avinash Kumar <avinash.vallarapu@gmail.com> 20 апреля 2020 г. в 14:59:40

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Laurenz Albe <laurenz.albe@cybertec.at> 20 апреля 2020 г. в 15:11:58

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Pepe TD Vo <pepevo@yahoo.com> 24 апреля 2020 г. в 13:28:25

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Laurenz Albe <laurenz.albe@cybertec.at> 24 апреля 2020 г. в 13:31:21

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Avinash Kumar <avinash.vallarapu@gmail.com> 24 апреля 2020 г. в 13:35:13

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Laurenz Albe <laurenz.albe@cybertec.at> 24 апреля 2020 г. в 14:50:30

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Avinash Kumar <avinash.vallarapu@gmail.com> 20 апреля 2020 г. в 15:26:14

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Scott Ribe <scott_ribe@elevated-dev.com> 20 апреля 2020 г. в 15:30:54

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Avinash Kumar <avinash.vallarapu@gmail.com> 20 апреля 2020 г. в 15:38:45

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Marlene Villanueva <villanuevamarlene906@gmail.com> 20 апреля 2020 г. в 15:45:35

Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL Ron <ronljohnsonjr@gmail.com> 20 апреля 2020 г. в 12:58:40

Hi,

On Mon, Apr 20, 2020 at 12:31 PM Scott Ribe <scott_ribe@elevated-dev.com> wrote:

So, the big question is: how much downtime can you afford on the current Oracle DB?

Yes, you should investigate the most efficient way to transfer data, but with TBs it will still be significant time. If you can afford the down time, great--kill all other connections to Oracle and go for it. If not, that's more complicated since you'll have to figure out a way to track and apply changes that happen during the copy...

If downtime is a concern, then, start a transaction on PG, using isolation level - REPEATABLE READ, get the SCN number from Oracle and copy the existing data from each table (table by table) using FDW for the initial data load. And then, if you have Oracle GG license, start the replicat from that SCN so that the data gets to sync eventually.
And then, when all the tables are in Sync, go ahead and switch your Apps. If we dont have GG license, we need to look for some other extensions or Kafka or something else that could do this job. Remember, migration is always challenging when lots of data is involved, and there never exists a direct magic.

Regards,
Avinash Vallarapu

+1-902-221-5976

В списке pgsql-admin по дате отправления

Предыдущее

От: Scott Ribe

Дата: 20 апреля 2020 г. в 15:30:54

Сообщение: Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL

Следующее

От: Marlene Villanueva

Дата: 20 апреля 2020 г. в 15:45:35

Сообщение: Re: Exporting TBs of data in Oracle schema/database into CSV formatto migrate into PostgreSQL