ORA-01124: cannot recover data file

Applies to:

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

Symptoms

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: ‘…’

Cause

RAC instances may be opened.

Solution

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 and 11g OCE and OCS, Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g and 11g. 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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s