RE: disaster recover from RMAN backup

Just a thought. Have you checked permissions on file 9? Can Oracle
read/write to it?
 
 
 


   _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Li Li
Sent: Wednesday, June 13, 2007 2:11 PM
To: oracle-l
Subject: disaster recover from RMAN backup


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
 
 


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.15/847 - Release Date: 6/12/2007
9:42 PM



No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.472 / Virus Database: 269.8.15/847 - Release Date: 6/12/2007
9:42 PM

Other related posts: