Q
Problem solve Get help with specific problems with your technologies, process and projects.

Backup command suddenly failing

I am running the following command and continually getting the errors ORA-19504 and ORA-27038. This has worked for months and now does not. There is adequate space and I can write files as Oracle to the location configured. Please advise.

I am running the following command and continually getting this error.
RMAN > backup database plus archivelog;
channel ORA_DISK_1: starting piece 2 at 08-SEP-06
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/08/2006 06:11:45
ORA-19504: failed to create file "/roraback/oracle/orcl/test/orcl_u%.bak"
ORA-27038: skgfrcre: file exists
 
RMAN > show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; 
# default CONFIGURE BACKUP OPTIMIZATION OFF; 
# default CONFIGURE DEFAULT DEVICE TYPE TO DISK; 
# default CONFIGURE CONTROLFILE AUTOBACKUP ON; 
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; 
# default CONFIGURE DEVICE TYPE DISK PARALLELISM 1; 
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; 
# default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; 
# default CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   
'/roraback/oracle/orcl/test/orcl_u%.bak' MAXPIECESIZE 500 M;
RMAN configuration has no stored or default parameters 
CONFIGURE MAXSETSIZE TO UNLIMITED; 
# default CONFIGURE SNAPSHOT CONTROLFILE NAME TO 
'/opt/oracle/product/9.2.0/dbs/snapcf_orcl.f'; # default
This has worked for months and now does not. There is adequate space and I can write files as Oracle to the location configured. Please advise.
The following errors point to the problem:
ORA-19504: failed to create file "/roraback/oracle/orcl/test/orcl_u%.bak"
ORA-27038: skgfrcre: file exists
In the above, you are trying to create a file, but that file already exists on disk and RMAN will not write over it, hence the error. It looks like a simple typo in your configuration. You typed "u%" when you probably meant "%u". Change the CONFIGURE CHANNEL command and it should work correctly.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close