Sunday, July 13, 2014

ORA-00245: control file backup failed; target is likely on a local file system

1.RMAN error message "ORA-00245: control file backup failed; target is likely on a local file system"
[oracle@ol6-112-rac1 admin]$ rman catalog rman/rman123@crman  target sys/sys123@orcl1

Recovery Manager: Release 11.2.0.3.0 - Production on Sun Jul 13 14:38:22 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1374849049, not open)
connected to recovery catalog database

RMAN> resync catalog from db_unique_name orcl_in;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of resync from db_unique_name command on default channel at 07/13/2014 14:39:09
ORA-00245: control file backup failed; target is likely on a local file system

RMAN> show snapshot controlfile name;

RMAN configuration parameters for database with db_unique_name ORCL_IN are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/orcl/oracle/product/11.2.0.3/db_1/dbs/snapcf_orcl1.f'; # default


2.Configuring snapshot controlfile name to ASM storage
RMAN> configure snapshot controlfile name to '+DATA/orcl/snapcf_orcl.f';

new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/orcl/snapcf_orcl.f';
new RMAN configuration parameters are successfully stored

RMAN> show snapshot controlfile name ;

RMAN configuration parameters for database with db_unique_name ORCL_IN are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/orcl/snapcf_orcl.f';

RMAN> resync catalog from db_unique_name 'orcl_in';

No comments: