Due to inconsistent state of the datafile, i was not able to open the database without recover of archivelogs apply
RMAN> alter database open resetlogs; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of sql statement command at 07/28/2021 23:55:21 ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1: '/apps01/oradata/orcl19xsystem01.dbf'
After recover of the database, i was able to open the database
RMAN> recover database; Starting recover at 28-JUL-21 using channel ORA_DISK_1 starting media recovery archived log for thread 1 with sequence 152 is already on disk as file /data01/ORCL19X/archivelog/2021_07_28/o1_mf_1_152_jj2w0xl1_.arc archived log for thread 1 with sequence 153 is already on disk as file /apps01/oradata/orcl19xredo03.log archived log file name=/data01/ORCL19X/archivelog/2021_07_28/o1_mf_1_152_jj2w0xl1_.arc thread=1 sequence=152 archived log file name=/apps01/oradata/orcl19xredo03.log thread=1 sequence=153 media recovery complete, elapsed time: 00:00:03 Finished recover at 28-JUL-21
Open the database
RMAN> alter database open resetlogs; Statement processed