ORA-01180 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 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.

 

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *