ODA:Controlfile Autobackup Fails With ORA-245
(Doc ID 2285135.1)
Last updated on JANUARY 28, 2024
Applies to:
Oracle Database Appliance Software - Version 12.1.2.1 to 12.1.2.10 [Release 12.1]Information in this document applies to any platform.
Symptoms
Controlfile autobackup fails with ora-0245 when SNAPSHOT CONTROLFILE NAME is configured to store in ASM diskgroup
###
RMAN RMAN-00571: ===========================================================
[2017.05.16 22:46:03] RMAN RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
[2017.05.16 22:46:03] RMAN RMAN-00571: ===========================================================
[2017.05.16 22:46:03] RMAN RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/16/2017 22:46:03
[2017.05.16 22:46:03] RMAN ORA-00245: control file backup failed; in Oracle RAC, the destination may not be in shared storage
[2017.05.16 22:46:03] RMAN Recovery Manager complete.
###
RMAN RMAN-00571: ===========================================================
[2017.05.16 22:46:03] RMAN RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
[2017.05.16 22:46:03] RMAN RMAN-00571: ===========================================================
[2017.05.16 22:46:03] RMAN RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/16/2017 22:46:03
[2017.05.16 22:46:03] RMAN ORA-00245: control file backup failed; in Oracle RAC, the destination may not be in shared storage
[2017.05.16 22:46:03] RMAN Recovery Manager complete.
###
RMAN> show snapshot controlfile name;
RMAN configuration parameters for database with db_unique_name <DB_NAME> are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/<DB_NAME>/snapcf_<DB_NAME>.f'; <<<<< controlfile autoback destination is on ASM DG.
RMAN configuration parameters for database with db_unique_name <DB_NAME> are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/<DB_NAME>/snapcf_<DB_NAME>.f'; <<<<< controlfile autoback destination is on ASM DG.
Changes
None
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |