Re: disaster recover from RMAN backup

Can you look into the alert log, and the relevant trace files and paste the relevant snippets. Besides check ML *1067818.6*

I am testing a disaster recovery senario. RMAN backup was done with no
> > catalog. Below are what I did:
> >
> >
> >
> > 1. startup nomount
> >
> > 2. restore spfile from xxx
> >
> > 3. shutdown
> >
> > 4. startup (this time it picks up the restored spfile)
> >
> > 5. restore controlfile from xxx
> >
> > 6. alter database mount
> >
> > 7. restore database check readonly (I have 2 read only tablespaces)
> >
> > 8. recover database until logseq 5 (log seq 4 was the last archivelog
> > backed up by rman)
> >
> >
> >
> > everything worked fine until step 8, I got an error on step 8 until
> > follows:
> >
> >
> >
> > ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error
> > below
> >
> > ORA-01122: database file 9 failed verification check
> >
> > ORA-01110: data file 9: 'H:\xxx\xxx\xxx.dbf'
> >
> > ORA-01206: file is not part of this database - wrong database id
> >
> >
> >
> > file 9 is one of the READ ONLY tablespaces.
> >
> > Any comment on what's wrong in here?
> >
> >
> >
> > TIA,
> >
> > -Li
> >
> >
> >
> >
> >
> > This message contains information that may be privileged or confidential
> > and is the property of the Capgemini Group. It is intended only for the
> > person to whom it is addressed. If you are not the intended recipient, you
> > are not authorized to read, print, retain, copy, disseminate, distribute, or
> > use this message or any part thereof. If you receive this message in error,
> > please notify the sender immediately and delete all copies of this message.
> >
> >
> > This message contains information that may be privileged or
> > confidential and is the property of the Capgemini Group. It is intended only
> > for the person to whom it is addressed. If you are not the intended
> > recipient, you are not authorized to read, print, retain, copy, disseminate,
> > distribute, or use this message or any part thereof. If you receive this
> > message in error, please notify the sender immediately and delete all copies
> > of this message.
> >
> >
>

--
http://www.freelists.org/webpage/oracle-l