ORA-01124: cannot recover data file

Applies to:

Oracle Server – Enterprise Edition – Version: to – Release: 9.2 to 11.2
Information in this document applies to any platform.


RMAN recovery fails with an ORA-01124 error:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 00/00/0000 00:00:00
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until time …
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 1 – file is in use or recovery
ORA-01110: data file 1: ‘…’


RAC instances may be opened.


If this is a RAC database and you are performing a database restore and recover, make sure all instances are closed except for the instance used for restore and recover which will be in mount status.


About Sher khan

Senior Oracle DBA, Oracle 10g , Oracle 11g OCE ,Oracle 12C and Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g , 11g and 12C. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in rman. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s