Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: A question on Block recovery

RE: A question on Block recovery

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 29 Aug 2007 12:44:11 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF270D34F973@AABO-EXCHANGE02.bos.il.pqe>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US