Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> disaster recover from RMAN backup

disaster recover from RMAN backup

From: Li Li <litanli_at_gmail.com>
Date: Wed, 13 Jun 2007 14:11:07 -0500
Message-ID: <5f35c2320706131211t7b37b8a9t40c6ad856f5b7add@mail.gmail.com>


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 Wed Jun 13 2007 - 14:11:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US