Re: Fw: Best storage for snapshot controlfile on 11.2.0.2 RAC

  • From: Anurag Verma <anuragdba@xxxxxxxxx>
  • To: sreejithsna@xxxxxxxxx
  • Date: Wed, 7 Sep 2011 12:48:51 -0700

Hi Sreejith,

What is the storage you are using for stroing autobackup ?

On ASM or shared filesystem ?

And are you using ODM ?

You may check the Metalink note: * 1308378.1*

**



On Tue, Aug 30, 2011 at 9:54 AM, Sreejith Nair <sreejithsna@xxxxxxxxx>wrote:

> Slightly old topic.
> We are frequently getting this error 'ORA-245 (control file backup
> operation failed)' after we upgraded our database to 11.2.0.2.
> Would be helpful if you can share if the solution mentioned in the below
> email worked for you.
>
> Cheers,
> Sreejith
>
> ------- Original message -------
> From: Yong Huang <yong321@xxxxxxxxx>
> To: landstander668@xxxxxxxxx
>
>> Cc: oracle-l@xxxxxxxxxxxxx
>>
> Sent: 21/7/'11,  21:55
>
> Thanks, Adric. I figured that was the easiest. I was afraid it was not
> supported even if it appears to work. I opened an SR and finally the
> analyst suggested the same. We put it in ASM today and will see if we
> still get intermittent ORA-245 (control file backup operation failed).
> How long ago did you put your snapshot controlfile in ASM? You never
> had the error ever since?
>
> Yong Huang
>
>  We're using ASM here, for the simple reason that it's the only form of
>> shared storage available in the relevant cluster.  It's pretty easy to
>> configure.
>> RMAN> configure snapshot controlfile name to
>> '+DISKGROUP/dbname/**controlfile/snapcf_dbname.f';
>>
> ..
>
>> According to Note 1268725.1 and Bug 10263733, on 11.2.0.2 RAC, the
>>> snapshot controlfile used during RMAN backup must be placed on shared
>>> storage.
>>>
>> --
> //www.freelists.org/**webpage/oracle-l<//www.freelists.org/webpage/oracle-l>
>
>
>
> --
> //www.freelists.org/**webpage/oracle-l<//www.freelists.org/webpage/oracle-l>
>
>
>


-- 

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


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


Other related posts: