DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, January 5, 2017

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

No comments: