RE: rac recovery of single datafile question

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 9 Jun 2009 15:48:53 -0400
Message-ID: <D1DC33E67722D54A93F05F702C99E2A903E93922_at_usahm208.amer.corp.eds.com>

In the past on earlier versions of RAC we have performed recovery with both nodes and instances started. In fact since the archive log destination was not a shared directory we ran recovery using both nodes and when prompted for a redo log would enter the file name on the other instance and recovery would run there till it needed a file on the first instance again.  

Given the option I would run recovery on one node with the other instances shutdown or at least restricted.

• Mark D Powell -- Phone (313) 592-5148

  ---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of TESTAJ3_at_nationwide.com

	Sent: Tuesday, June 09, 2009 2:07 PM
	To: oracle-l_at_freelists.org
	Subject: rac recovery of single datafile question
	
	

	I dont think the version matter here but we're doing both

11.1.0.7 and 10.2.0.4         

        If i lose a datafile like part of tablespace users, single datafile and want to restore it and do recovery(complete) can i just take the datafile offline leaving all 3 nodes(of 3 nodes) up and running and do the restore, it appears we're getting ORA-19573 issue about enqueue lock not able to be obtained. I'm thinking we don't need to bring down all of the nodes and bring one up in single instance mode to do this, or am i out in left field here?         

        thanks, joe         

---

	Joe Testa, Oracle Certified Professional 


	(Work) 614-677-1668

	(Cell) 614-312-6715

	
	Interested in helping out your marriage?
	Ask me about "Weekend to Remember"
	Dec 11-13, 2009 here in Columbus.
	

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

Received on Tue Jun 09 2009 - 14:48:53 CDT