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.

Let’s try

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'

Restore controlfile

rman target /
RMAN> restore controlfile from 'D:\path\to\controlfile.bak'

Restore database

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'

Leave a Reply