Re: disaster recover from RMAN backup

  • From: "Pedro Espinoza" <raindoctor@xxxxxxxxx>
  • To: litanli@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 13 Jun 2007 23:18:30 -0400

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

Other related posts: