ORA-00245 Error

Today when I was executing a archive backup after of full refresh (by OGG) I get the next error;

 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 04/10/2019 09:26:58
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 04/10/2019 09:26:58
ORA-00245: control file backup failed; in Oracle RAC, target might not be on shared storage

The same is generated in the first sentence of the RMAN script (resyn catalog). The problem is that snap CF backup is in a DG, which is not permited. It must be out of DG. In this case ACFS or local disk (ZFS) is possible.

Like first action I performed a specified backup like show below;

 

SQL> alter database backup controlfile to ‘/prod/backup/CONTROLFILE/snapcf_nube.f’ reuse;

 
The second action is make this change permanent. From RMAN you can use;

 

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;

CONFIGURE SNAPSHOT CONTROLFILE NAME clear;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘/prod/backup/CONTROLFILE/snapcf_nube.f’;

 
HTH – Antonio NAVARRO

Advertisements

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s