Re: Error recovering a database with a read-only tablespace
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: dlordster@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Apr 2008 18:36:17 +0100
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
Other related posts:
