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. > >