Re: Error recovering a database with a read-only tablespace

From: <>
Date: Wed, 16 Apr 2008 12:26:39 -0400
Message-ID: <>

David, datafile 1 is the system tablespace datafile, I've not seen that error.

An off the wall question did the database have a patchset and/or upgrade done to it since the backup was taken? It almost appears as if the header in the datafile is either corrupt or did not get converted during an upgrade process.

just throwing out some ideas.

Thanks, Joe

You can have it: Fast, Right or Cheap, pick 2 of the 3. Fast + Right is Expensive
Fast + Cheap will be incorrect.
Right + Cheap will take a while.

"David Lord" <>  

Sent by:

04/16/2008 11:54 AM
Please respond to

"David Lord" <>
oracle-l <>

Error recovering a database with a read-only tablespace


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 - 11:26:39 CDT

Original text of this message