My Oracle Support Banner

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

Last updated on JULY 31, 2019

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=/<PATH>/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: '<PATH>/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

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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.