ORA-01124: cannot recover data file


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.
Advertisements

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

%d bloggers like this: