RE: A question on Block recovery

See here:

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta0 10.htm#sthref210  

Scroll down to "Restrictions and Usage Notes". Looks like file does NOT have to be offline.  

--

Mark J. Bobak
Senior Database Administrator, System & Product Technologies ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak_at_il.proquest.com <mailto:mark.bobak_at_il.proquest.com> www.proquest.com <http://www.proquest.com> www.csa.com <http://www.csa.com>

ProQuest...Start here.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Anurag Verma Sent: Wednesday, August 29, 2007 11:54 AM To: ORACLE-L
Subject: A question on Block recovery  

Hi All,    

When we do the block recovery to fix block corruption, do the affected datafile need to be taken OFFLINE?  

Or will the datafile be unavailable to the users during the block recovery?    

My database is in 10g RAC (10.2.0.3.0) on a 4 Node RAC n Solaris 9 with Netapp filers and Oracle Clusterware as clustering solution.        

Thanks,
--

Anurag Verma,
Database Administrator
ERCOT(Electric Reliability Council of Texas), Texas 76574

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 29 2007 - 11:44:11 CDT