In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared location

Hdr: 13780443 11.2.0.3 RDBMS 11.2.0.3 RMAN PRODID-5 PORTID-46
Abstract: CONTROLFILE BACKUP MUST RESIDE ON SHARED DEVICE WITH RAC DATABASE

PROBLEM:
--------
Controlfile backup, even using sql 'alter database backup controlfile...' 
must create a backup on a shared device, otherwise will return error:
ORA-245: control file backup operation failed
 
We should document this in RAC doc and/or sql language guide under "alter 
database" and/or RMAN reference under COPY.  
 
DIAGNOSTIC ANALYSIS:
--------------------
see the following, all closed as not a bug:
11676304 STBH: CREATE STANDBY CONTROLFILE ERRORS ORA-245: CONTROL FILE 
BACKUP OPERATION
13085539 ORA-245 OCCURS DURING RMAN COPY CORRENT CONTROLFILE.
12311429 ALTER DATABASE BACKUP CONTROLFILE FAILS WITH ORA-245
 
WORKAROUND:
-----------
write to a shared device.  
 
RELATED BUGS:
-------------
 
REPRODUCIBILITY:
----------------
 
TEST CASE:
----------
 
1. Check the snapshot controlfile location:
 RMAN> show snapshot controlfile name;
2. Configure the snapshot controlfile to a shared disk:
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '<shared_disk>/snapcf_<DBNAME>.f';
Or in case of ASM use
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+<DiskGroup>/snapcf_<DBNAME>.f';

About Sher khan

Senior Oracle DBA, Oracle 10g and 11g OCE and OCS, Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g and 11g. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Oracle backup & recovery. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s