My Oracle Support Banner

ODA:Controlfile Autobackup Fails With ORA-245 (Doc ID 2285135.1)

Last updated on JANUARY 28, 2024

Applies to:

Oracle Database Appliance Software - Version to [Release 12.1]
Information in this document applies to any platform.


 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> 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.





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.