David did the db have an OPEN RESETLOGS operation in the mean time - or is this a clone RMAN DUPLICATE db? Either of these should give your error On 16/04/2008, David Lord <dlordster@xxxxxxxxx> wrote: > All, > > I'm running into a problem trying to recover a 9.2.0.8 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. > > Regards > David Lord > -- > //www.freelists.org/webpage/oracle-l > > > -- Niall Litchfield Oracle DBA http://www.orawin.info -- //www.freelists.org/webpage/oracle-l