Search

Loading...
Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself while at work and Welcome any body needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Monday, 5 November 2012

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: For that please check my other post: Resetting or Recovering the Database with old incarnation

0 comments:

Post a Comment