RMAN restore database fails ORA-01180: can not create datafile 1 (Doc ID 1573040.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Controlfile backup created after the  database backup completed has been restored.

Backup listing shows the database backup to be restored.

Attempt to restore database fails:

creating datafile file number=1 name=/u01/app/oracle/oradata/<sid>/system.294.815123359
released channel: dev_0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 07/06/2013 12:33:19
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '+DATA/<sid>/datafile/system.294.815123359'


A number of new incarnations are listed:


RMAN> list incarnation of database;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 <SID> 3575930408 CURRENT 1 28-SEP-11
2 2 <SID> 3575930408 ORPHAN 9704859728 11-MAY-13
3 3 <SID> 3575930408 ORPHAN 10086962444 26-MAY-13
5 5 <SID> 3575930408 ORPHAN 10088758979 28-JUN-13
4 4 <SID> 3575930408 ORPHAN 10088758980 05-JUL-13



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms