ORA-01194: file 1 needs more recovery to be consistent

[ _allow_resetlogs_corruption ]

===Problem ====

contents of Memory Script:

{

   Alter clone database open resetlogs;

}

executing Memory Script

 RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 08/25/2021 18:25:45

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

RMAN-06136: Oracle error from auxiliary database: ORA-01152: file 3 was not restored from a sufficiently old backup

ORA-01110: data file 3: '/u03/oradata/TESTCDB/sslcdb/datafile/sysaux.291.1050880731'

or

SQL> alter database open resetlogs;

alter database open resetlogs

ERROR at line 1:

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/u01/app/oracle/oradata/RTS_NEW/system_new.dbf'

====== Solution =============================

Change “_allow_resetlogs_corruption” parameter to TRUE and undo_management parameter to MANUAL:

SQL> ALTER SYSTEM SET "_allow_resetlogs_corruption"= TRUE SCOPE = SPFILE;

SQL> ALTER SYSTEM SET undo_management=MANUAL SCOPE = SPFILE;

SQL> STARTUP MOUNT

SQL> alter database open resetlogs;

Database altered.

--------------------------------------------------

SQL> shutdown immediate

SQL> startup

-------------------------------------------------

SQL> ALTER SYSTEM SET "_allow_resetlogs_corruption"= FALSE SCOPE = SPFILE;