cannot execute COPY during recovery DBI::db=HASH(0x5032e88)->disconnect invalidates...error

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

http://www.ora2pg.com/

GNU General Public License v3.0

1.02k stars 343 forks source link

cannot execute COPY during recovery DBI::db=HASH(0x5032e88)->disconnect invalidates...error #1566

Closed goskang closed 1 year ago

goskang commented 1 year ago

Hi, While trying to run ora2pg we encounter the following errors and the data was not migrated. (Oracle to PostgreSQL)

This is the error.

ora2pg_error

We need some Expert advise.

darold commented 1 year ago

The PG database has probably crashed and it is in recovery, not an ora2Pg issue.