Getting ORA-01180 error during database restoration
Having restore database from rman but got a ORA-01180 error, it happen often because your backup file source directory is different then original backup path.
Restore pfile and recreate all necessary directory eg: archive log, admin, a/b/c/udump, datafile… every directory you specified in the pfile
Copy your backup pfile to %ORACLE_HOME%\dbs\
sqlplus / as sysdba sqlplus> startup nomount pfile='%ORACLE_HOME%\dbs\initORAINST.ora'
rman target / RMAN> restore controlfile from 'D:\path\to\controlfile.bak'
RMAN> alter database mount; RMAN> restore database;
Then you got a similar message as below, because originally your backup path is somewhere different then your current backup file source path.
creating datafile fno=1 name=D:\ORADATA\ORAINST\SYSTEM01.DBF RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 02/18/2011 16:55:06 ORA-01180: can not create datafile 1 ORA-01110: data file 1: 'D:\ORADATA\ORAINST\SYSTEM01.DBF'
Try this to re-catalog your backup files then re-run the restore
rman> catalog start with 'D:\backup\source'