rac recovery of single datafile question

From: <TESTAJ3_at_nationwide.com>
Date: Tue, 9 Jun 2009 14:07:02 -0400
Message-ID: <OF4356CA8B.8FAC7554-ON852575D0.00634D9A-852575D0.00638558_at_lnotes-gw.ent.nwie.net>

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

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.

Received on Tue Jun 09 2009 - 13:07:02 CDT

Original text of this message