ORA-27037

How to Resolve ORA-31640: unable to open dump file

by Ed Chen
July 25, 2023July 26, 2023

ORA-31640 Tried to import data into the database from a dump file, but it failed with ORA-31640. Linux [oracle@test ~]$ impdp system/password@orcl full=yes directory=BACKUP2 dumpfile=full.dmp… Read More »

How to Resolve ORA-00308: cannot open archived log

by Ed Chen
August 13, 2021June 26, 2023

ORA-00308 Found ORA-00308: cannot open archived log during performing a database point-in-time recovery (DBPITR) by RMAN. ORA-00308: cannot open archived log '/oradata/ORCL/ARCH/ORCL_1_294150.arc' ORA-27037: unable to… Read More »

How to Resolve ORA-01565: error in identifying file

by Ed Chen
January 9, 2021December 9, 2022

In this post, I'll describe two error patterns for ORA-01565. Missing SPFILE Multitenant DB A. ORA-01565 for Missing SPFILE To create a plain-text parameter file,… Read More »

What Makes Instance Shutdown Itself

by Ed Chen
November 6, 2019November 22, 2022

What makes a running instance shutdown itself could be a very complicated topic to talk about, because we have to know what instance was thinking.… Read More »

How to Resolve RMAN-06059: expected archived log not found

by Ed Chen
July 11, 2019December 10, 2022

RMAN-06059 RMAN-06059 means that the archived logs you expect to use are missing from where they should be. In my case, when I tried to… Read More »

How to Resolve ORA-19505: failed to identify file

by Ed Chen
March 11, 2017November 5, 2021
2 Comments

ORA-19505 There're two error patterns of ORA-19505 in this post. Cloning a PDB Duplicating a Database 1. Cloning a PDB Tried to clone a Pluggable… Read More »

JavaScript is not enabled. Please enable it and reload the page.