Error recovering a database with a read-only tablespace
- From: "David Lord" <dlordster@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 16 Apr 2008 16:54:27 +0100
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
Other related posts:
