Re: A question on Block recovery

From: fairlie rego <fairlie_r_at_yahoo.com>
Date: Thu, 30 Aug 2007 08:42:18 +1000 (EST)
Message-ID: <458614.62285.qm@web31913.mail.mud.yahoo.com>

Anurag,    

  You do not have to take the file OFFLINE. Here is an example    

  http://el-caro.blogspot.com/search?q=block+corruption    

  Thanks
  Fairlie

Anurag Verma <anuragdba_at_gmail.com> wrote:     

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

          Fairlie Rego
Senior Oracle Consultant
  http://el-caro.blogspot.com/
  M: +61 402 792 405            

---

Feel safe with award winning spam protection on Yahoo!7 Mail. Find out more.
--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 29 2007 - 17:42:18 CDT