Posted by: Pavel Ermakov | November 8, 2011

ORA-01580: error creating control backup file

Hi
I have faced off with some issue: accidently I’ve configured snapshot controlfile name to wrong directory, after that I can’t clear this option in RMAN.

RMAN> show all;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of show command at 11/08/2011 01:35:50
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 11/08/2011 01:35:50
ORA-01580: error creating control backup file /u01/snapcf_ggdb1.f
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 13: Permission denied
Additional information: 1

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME CLEAR;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 11/08/2011 01:36:05
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 11/08/2011 01:36:05
ORA-01580: error creating control backup file /u01/snapcf_ggdb1.f
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 13: Permission denied
Additional information: 1

Solution: log in to the database as sysdba:

oracle@host: sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on Tue Nov 8 01:33:32 2011

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
Data Mining and Real Application Testing options

sys@db1> EXECUTE SYS.DBMS_BACKUP_RESTORE.CFILESETSNAPSHOTNAME('/u01/app/oracle/product/11.2/db/dbs/snapcf_db1.f');

PL/SQL procedure successfully completed.

Regards,
Pavel.

Advertisements

Responses

  1. Thanks for the tip! The ‘EXECUTE SYS.DBMS_BACKUP_RESTORE.CFILESETSNAPSHOTNAME’ was the solution!

  2. Many thanks!

    Antonio

  3. Thanks a lot !!!!


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 )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: