Backup Fails ORA-27038 Creating Automatic Controlfile Backup
(Doc ID 382989.1)
Last updated on FEBRUARY 03, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
RMAN backup as copy command fails:
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/02/2006 18:50:34
ORA-19504: failed to create file "/tmp/system01.fbf"
ORA-27038: created file already exists
Additional information: 1
The failing command is: backup as copy datafile 1 to '/tmp/system00.dbf';
Or incase ASM is used :
RMAN> run {
allocate channel ch1 device type disk;
backup as copy datafile 1 format '+DATA/psrs01a/datafile/system_01.dbf' TAG 'INC_UPDATE';
release channel ch1;
}
2> 3> 4> 5>
allocated channel: ch1
channel ch1: SID=290 instance=PSRS01A2 device type=DISK
Starting backup at 10-JAN-13
channel ch1: starting datafile copy
input datafile file number=00001 name=+FRA/psrs01a/datafile/system.2266.796994323
output file name=+DATA/psrs01a/datafile/system_01.dbf tag=INC_UPDATE RECID=18500 STAMP=804358919
channel ch1: datafile copy complete, elapsed time: 00:00:07
channel ch1: starting datafile copy
copying current control file
RMAN-03009: failure of backup command on ch1 channel at 01/10/2013 17:02:03
ORA-01580: error creating control backup file +DATA/psrs01a/datafile/system_01.dbf
ORA-17502: ksfdcre:4 Failed to create file +DATA/psrs01a/datafile/system_01.dbf
ORA-15005: name "psrs01a/datafile/system_01.dbf" is already used by an existing alias
continuing other job steps, job failed will not be re-run
channel ch1: starting full datafile backup set
channel ch1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ch1: starting piece 1 at 10-JAN-13
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 01/10/2013 17:02:04
ORA-19504: failed to create file "+DATA/psrs01a/datafile/system_01.dbf"
ORA-17502: ksfdcre:4 Failed to create file +DATA/psrs01a/datafile/system_01.dbf
ORA-15005: name "psrs01a/datafile/system_01.dbf" is already used by an existing alias
allocate channel ch1 device type disk;
backup as copy datafile 1 format '+DATA/psrs01a/datafile/system_01.dbf' TAG 'INC_UPDATE';
release channel ch1;
}
2> 3> 4> 5>
allocated channel: ch1
channel ch1: SID=290 instance=PSRS01A2 device type=DISK
Starting backup at 10-JAN-13
channel ch1: starting datafile copy
input datafile file number=00001 name=+FRA/psrs01a/datafile/system.2266.796994323
output file name=+DATA/psrs01a/datafile/system_01.dbf tag=INC_UPDATE RECID=18500 STAMP=804358919
channel ch1: datafile copy complete, elapsed time: 00:00:07
channel ch1: starting datafile copy
copying current control file
RMAN-03009: failure of backup command on ch1 channel at 01/10/2013 17:02:03
ORA-01580: error creating control backup file +DATA/psrs01a/datafile/system_01.dbf
ORA-17502: ksfdcre:4 Failed to create file +DATA/psrs01a/datafile/system_01.dbf
ORA-15005: name "psrs01a/datafile/system_01.dbf" is already used by an existing alias
continuing other job steps, job failed will not be re-run
channel ch1: starting full datafile backup set
channel ch1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ch1: starting piece 1 at 10-JAN-13
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch1 channel at 01/10/2013 17:02:04
ORA-19504: failed to create file "+DATA/psrs01a/datafile/system_01.dbf"
ORA-17502: ksfdcre:4 Failed to create file +DATA/psrs01a/datafile/system_01.dbf
ORA-15005: name "psrs01a/datafile/system_01.dbf" is already used by an existing alias
.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |