Starting from 11.2.0.2.0,the snapshot control file must be shared by all nodes of a RAC database, and must be saved in a shared location.
In the case, you keep RMAN default persistent parameter, you may receive the error:
ORA-00245: control file backup operation failed
Which makes your backup job failing.
I just come across this issue in one of our test environment, the MOS document IDs: 1263621.1 and 1268725.1 explain the issue.
So, if you are getting this error, in your alert log files and in your trace files:
Alert log file content: 2011-07-01 00:11:53.650000 +02:00 Errors in file /opt/app/oracle/diag/rdbms/cmsdb/cmsdb1/trace/cmsdb1_ora_15751.trc: ORA-00245: control file backup operation failed Trace File content: Starting control autobackup *** 2011-07-01 00:11:53.650 ORA-00245: control file backup operation failed Got error: 245 Autobackup failed with following error ORA-00245: control file backup operation failed
In my case I am using ASM to manage the storage.
This is my current configuration of RMAN persistent settings:
rman target / show all; CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_db1.f'; # default
To fix the issue,I did the following:
rman target / Recovery Manager: Release 11.2.0.2.0 - Production on Tue Jul 5 10:00:33 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: CMSDB (DBID=1390673463) RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FLASH/SNCFORCL.ORA'; using target database control file instead of recovery catalog new RMAN configuration parameters: CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FLASH/SNCFORCL.ORA'; new RMAN configuration parameters are successfully stored RMAN>
Hope it helps,
Wissem
Blog's RSS Feed
Loading ...
Just the scripts I posted above
[...] RAC 11gR2 ORA-00245: control file backup operation failed [...]
I really enjoyed your blog and find your notes are very helpful. I have a question here. I have a two RAC nodes primary and two RAC nodes as standby, both in 1120301 version on linux redhat 5. How do we use oracle restart? I found in oracle docs, it said oracle restart is for standalone server. and For Oracle Real Application Clusters (Oracle RAC) environments, the functionality to automatically restart components is provided by Oracle Clusterware. But I could not find any oracle official documents for that. Can you help me? Thanks in advance.
Hi Jenny, I really don’t understand your question, I believe you are asking of how to use Oracle restart to automatic restart things when server reboots or a failure happens? if so, then you should add the component as a local or cluster resource to the oracle restart via the “crsctl” command, check my articles you will found many of them explaining how to do it …
thanks,
Wissem
Thanks.
Dear Jenny,
I also have a similar setup like yours, 11203 RAC on RHEL 5.
As per your question, how to use Oracle Restart. The answer is no need. Try to restart your server, the Oracle HAS (High Availaviilty Service) component will start the asm , database, and listener automatically for you in that server.
HTH,
Regards,
Mahesh.
Dear Jenny,
I also have a similar setup like yours, 11203 RAC on RHEL 5.
As per your question, how to use Oracle Restart. The answer is no need. Try to restart your server, the Oracle HAS (High Availability Service) component will start the asm , database, and listener automatically for you in that server.
HTH,
Regards,
Mahesh.