Just want to give you all an update in case you run into the same problem.
The problem here is the database was created by RMAN duplicate, so the dbid
for the read only files are still the original dbid.
On 6/13/07, Li Li <litanli_at_gmail.com> wrote:
>
> Hi, List,
>
> 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
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 14 2007 - 16:18:51 CDT
