Fw: Best storage for snapshot controlfile on 11.2.0.2 RAC

From: Sreejith Nair <sreejithsna_at_gmail.com>
Date: Tue, 30 Aug 2011 22:24:02 +0530
Message-ID: <0997412963.999210242_at_gmail.com>

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_at_yahoo.com>
To: landstander668_at_gmail.com
> Cc: oracle-l_at_freelists.org

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.

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



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

Received on Tue Aug 30 2011 - 11:54:02 CDT