RE: disaster recover from RMAN backup

From: Richard J. Goulet <richard.goulet_at_capgemini.com>
Date: Wed, 13 Jun 2007 15:54:59 -0400
Message-ID: <C3EE2ADD31ACF64DAB1B236044A1968D90B2AB@miaexc01.kanbay.com>

Phooey. That might have explained it.

Dick Goulet / Capgemini
North America P&C / East Business Unit
Senior Oracle DBA / Hosting
Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com
<http://www.capgemini.com/>

Fax: 508.229.2019 / Email: richard.goulet_at_capgemini.com 45 Bartlett St. / Marlborough, MA 01752

Together: the Collaborative Business Experience

From: Li Li [mailto:litanli_at_gmail.com]
Sent: Wednesday, June 13, 2007 3:48 PM
To: Richard J. Goulet
Cc: oracle-l
Subject: Re: disaster recover from RMAN backup

no :(

On 6/13/07, Richard J. Goulet <richard.goulet_at_capgemini.com> wrote:

Was this datafile/tablespace transported from another database??

	Dick Goulet / Capgemini
	North America P&C / East Business Unit
	Senior Oracle DBA / Hosting
	Office: 508.573.1978 / Mobile: 508.742.5795 / www.capgemini.com


<http://www.capgemini.com/> 

	Fax: 508.229.2019 /  Email: richard.goulet_at_capgemini.com
	45 Bartlett St. / Marlborough, MA 01752 

	Together: the Collaborative Business Experience 
	______________________________________________________________

	 

________________________________

	From: oracle-l-bounce_at_freelists.org [mailto:

oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> ] On Behalf Of Li Li

	Sent: Wednesday, June 13, 2007 3: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:

startup nomount
restore spfile from xxx
shutdown
startup (this time it picks up the restored spfile)
restore controlfile from xxx
alter database mount
restore database check readonly (I have 2 read only tablespaces)
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.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 13 2007 - 14:54:59 CDT