ORA-01180

ORA-01180: Cannot create datafile 1

RMAN-03002: failure of restore command at 10/03/2012 10:40:06
ORA-01180: cannot create datafile 1
ORA-01110: data file 1: ‘C:\oracle1\oradata\system01.dbf’
After restoring the control file, RMAN restore of database fails with the above error. As the physical datafiles do not exist RMAN attempts to create the physical files but this is not allowed if the file belongs to the SYSTEM tablespace.

This problem can occur on any platform. In this case:
Check the Backup location set properly the rman is not finding the full backup so is not able to create datafile.               
It is also possible you have changed your incarnation by using “alter database open resetlogs” and the current incarnation only contains incremental level backups. There is no full backups in this incarnation.
 
Solution:
Catalog the proper location for full backup
RMAN> catalog start with ‘H:\oraback\Weekly_20121102_full_orcl3-1034.DB’;
If do not have valid full backup in current incarnation then Reset the database to the previous incarnation and run the restore and recovery again.


No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...