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;
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;