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'; # defaultThis 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.
ORA-19504: failed to create file "/roraback/oracle/orcl/test/orcl_u%.bak" ORA-27038: skgfrcre: file existsIn 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
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading