Oracle / PLSQL: ORA-01234 Error Message

Learn the cause and how to resolve the ORA-01234 error message in Oracle.

Description

When you encounter an ORA-01234 error, the following error message will appear:

• ORA-01234: cannot end backup of file name - file is in use or recovery

Cause

You tried to end an online backup of a file, but the file is being used.

Resolution

The option(s) to resolve this Oracle error are:

Option #1

If there is an instance of Oracle running that has the file open, you can try ending the online backup by executing the ALTER TABLESPACE command.

Option #2

Otherwise, if a recovery or rename operation is active on this file, you'll have to wait until these operations have been completed. Then you can try again.