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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 16 Apr 2008 18:36:17 +0100
Message-ID: <7765c8970804161036n35c760e2sdc1274a2a6e66d13@mail.gmail.com>


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_at_gmail.com> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 16 2008 - 12:36:17 CDT

Original text of this message