ORA-01180: can not create datafile 1 ORA-01110 RMAN-03002 Error Solution During RMAN Restore Operation

Hi,

When I try to create Test database from Production via RMAN Restore, I got ” ORA-01180: can not create datafile 1 ORA-01110 RMAN-03002 ” errors.

Details of error are like following.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/25/2019 14:10:39
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/u01/oraprod/system01.dbf'

Recovery Manager complete.

This problem is related with Incarnation of database.

To solve this problem, reset database to previous incarnation like following.

List incarnation on both sqlplus and RMAN like following.

RMAN> list incarnation of database;


SQL> select INCARNATION#, RESETLOGS_TIME from v$database_incarnation order by RESETLOGS_TIME desc;

INCARNATION# RESETLOGS
------------ ---------
2 24-JUN-19
1 14-JUN-13

SQL>

Then reset database incarnation like following.

RMAN> reset database to incarnation 1;

using target database control file instead of recovery catalog
database reset to incarnation 1

RMAN>

After reset operation, list incarnation again, it will change.

RMAN> list incarnation of database;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       DEVECI     229957177        CURRENT 1          14-JUN-13
2       2       DEVECI     229957177        ORPHAN  5993590971744 24-JUN-19

RMAN>

Second solution is using log_archive_dest_1 parameter instead of FRA ( fast recovery area ).

Reset FRA parameters and set log_archive_dest_1 parameters like following.

SQL> alter system reset db_recovery_file_dest scope=both;

System altered.


SQL> alter system reset db_recovery_file_dest_size scope=both;

System altered.


SQL> alter system set log_archive_dest_1='location=/u01/recovery_area'  scope=both;

System altered.

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/