RMAN-11003: failure during parse/execution of SQL statement: alter database create standby controlfile as ” ORA-00245: control file backup failed; target is likely on a local file system

Cause:

This is down to the snapshot controlfile being on a local disk and it needs to be on a shared disk for all of the cluster in our case we need to put it on ASM diskgroup

Solution:
To fix the issue we need to configure the SNAPSHOT CONTROLFILE to the  ASM diskgroup in RMAN, this is done as follows:
RMAN> configure snapshot controlfile name to ‘+ORA_DATA/snapcf_PRODDB1.f’;
new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO ‘+ORA_DATA/snapcf_PRODDB1.f’;
new RMAN configuration parameters are successfully stored
  • January 5, 2017 | 16 views
  • Comments