Re: Error recovering a database with a read-only tablespace
- From: "David Lord" <dlordster@xxxxxxxxx>
- To: "Riyaj Shamsudeen" <riyaj.shamsudeen@xxxxxxxxx>
- Date: Thu, 17 Apr 2008 09:06:57 +0100
Riyaj,
Thanks for your reply. I am trying to do an incomplete recovery of
the database to a full backup I took a few days ago. Its in
noarchivelog mode and I don't want to go past the backup.
The first restore I tried (via enterprise manager - yes I know, I
_have_ to press all the buttons) was straightforward and without the
check readonly option and it said it was ignoring the read only
datafile:
RMAN> run {
2> restore database;
3> recover database noredo;
4> }
...
datafile 13 not processed because file is read-only
...
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/15/2008 15:35:19
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
I have tried to take the tablespace offline, but it doesn't let me
because the database is not open.
Regards
David Lord
On 16/04/2008, Riyaj Shamsudeen <riyaj.shamsudeen@xxxxxxxxx> wrote:
> Hi David
>
> I am really not sure what you are trying to do. Can you please clarify?
> If the tablespaces are in read only state at time of recovery, then they
> don't participate in recovery. rman recover database command takes care of
> that. I don't think 'check readonly' option is quite applicable here.
> In sqlplus, you could make those datafiles associated with read only
> tablespaces offline [ or offline drop, don't remember which one ] and
> recover the database, open resetlogs. Then you could just make read only
> tablespace onlline.
>
> Cheers
> Riyaj Shamsudeen
> The Pythian Group
> www.pythian.com
>
> On Wed, Apr 16, 2008 at 10:54 AM, 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
> >
> >
> >
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
