Error recovering a database with a read-only tablespace

From: David Lord <>
Date: Wed, 16 Apr 2008 16:54:27 +0100
Message-ID: <>


I'm running into a problem trying to recover a test database with a read only tablespace ASSETS_21 from an RMAN backup.

The restore runs fine and appears to restore the ASSETS_21.dbf datafile (number 13 for the superstitious amongst you):

   RMAN> restore database check readonly force;

   restoring datafile 00013 to /data/oradata/ESDCWTST/ASSETS_21.dbf

   Finished restore at 16-APR-08

But when I do the recovery, I get the following error:

   RMAN> recover database check readonly;

   could not read file header for datafile 13 error reason 9

   RMAN-03002: failure of recover command at 04/16/2008 16:02:16    RMAN-06094: datafile 1 must be restored

And when I try it from sqlplus I get:

   SQL> recover database until cancel using backup controlfile;

   ORA-00283: recovery session canceled due to errors
   ORA-01110: data file 13: '/data/oradata/ESDCWTST/ASSETS_21.dbf'
   ORA-01122: database file 13 failed verification check
   ORA-01110: data file 13: '/data/oradata/ESDCWTST/ASSETS_21.dbf'
   ORA-01206: file is not part of this database - wrong database id

Has anybody come across this before, or know what to do? I'm probably going to end up cloning a new copy from the live database, but it would be nice to know what the problem was.

David Lord

Received on Wed Apr 16 2008 - 10:54:27 CDT

Original text of this message