- 07 Sep, 2023
- 0 Comments
- 54 Secs Read
ORA-01180
ORA-01180: can not create datafile 1 ORA-01110 RMAN-03002
Solution 1: Reset database to previous incarnation as follows :
RMAN> list incarnation of database; SQL> select INCARNATION#, RESETLOGS_TIME from v$database_incarnation order by RESETLOGS_TIME desc; 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;
Solution 2 :Reset FRA parameters and set log_archive_dest_1 parameters like following.
SQL> alter system reset db_recovery_file_dest scope=both; SQL> alter system reset db_recovery_file_dest_size scope=both; SQL> alter system set log_archive_dest_1='location=/u01/recovery_area' scope=both;