From time to time our backups were failing on the ORA-00245 error
In the alert log on the first node: ORA-00245: control file backup failed; target is likely on a local file system
In the alert log on the second node: ORA-27037: unable to obtain file statusNo such file or directory.
When checking the problem, I came accros the 1472171.1 note. When i have checked the name of the snapshot controlfile I saw, that we have 2 entries set:
RMAN> show snapshot controlfile name;
starting full resync of recovery catalog
full resync complete
RMAN configuration parameters for database with db_unique_name PFLX are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/PFLX/snapcf_pflx.f';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/pflx/snapcf_pflx.f';
I have set the name again, and the second entry was removed:
RMAN> configure SNAPSHOT CONTROLFILE NAME TO '+FRA/pflx/snapcf_pflx.f';
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/PFLX/snapcf_pflx.f';
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/pflx/snapcf_pflx.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/pflx/snapcf_pflx.f';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
Check the configuration again:
RMAN> show snapshot controlfile name;
RMAN configuration parameters for database with db_unique_name PFLX are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/pflx/snapcf_pflx.f';
In the alert log on the second node: ORA-27037: unable to obtain file statusNo such file or directory.
When checking the problem, I came accros the 1472171.1 note. When i have checked the name of the snapshot controlfile I saw, that we have 2 entries set:
RMAN> show snapshot controlfile name;
starting full resync of recovery catalog
full resync complete
RMAN configuration parameters for database with db_unique_name PFLX are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/PFLX/snapcf_pflx.f';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/pflx/snapcf_pflx.f';
I have set the name again, and the second entry was removed:
RMAN> configure SNAPSHOT CONTROLFILE NAME TO '+FRA/pflx/snapcf_pflx.f';
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/PFLX/snapcf_pflx.f';
old RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/pflx/snapcf_pflx.f';
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/pflx/snapcf_pflx.f';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
Check the configuration again:
RMAN> show snapshot controlfile name;
RMAN configuration parameters for database with db_unique_name PFLX are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/pflx/snapcf_pflx.f';