ORA-01580: error creating control backup file


RMAN> show all;
RMAN-00571: =============================================
 RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS 
 RMAN-00571: ============================================
 RMAN-03002: failure of show command at 11/08/2013 01:35:50
 RMAN-03014: implicit resync of recovery catalog failed
 RMAN-03009: failure of full resync command on default channel at 11/08/2013 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/2013 01:36:05
 RMAN-03014: implicit resync of recovery catalog failed
 RMAN-03009: failure of full resync command on default channel at 11/08/2013 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 2013
Copyright (c) 1982, 2013, 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.

2 comments

  1. Excellent post. Saved me a ton of headaches. Thank you.

  2. To never ill head 🙂

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

%d bloggers like this: