hi am in oracle database 19c in oracle linux i got this issue after there was power failure
startup
ORACLE instance started.
Total System Global Area 2449472408 bytes
Fixed Size 8899480 bytes
Variable Size 637534208 bytes
Database Buffers 1795162112 bytes
Redo Buffers 7876608 bytes
Database mounted.
ORA-00742: Log read detects lost write in thread 1 sequence 270 block 226330
ORA-00312: online log 3 thread 1:
'/u01/app/oracle/fast_recovery_area/dbname/onlinelog/o1_mf_3_kgb5x7o8_.log'
ORA-00312: online log 3 thread 1:
'/u01/app/oracle/oradata/dbname/onlinelog/o1_mf_3_kgb5x7b9_.log'
recover database until cancel;
ORA-00279: change 49556642 generated at 12/04/2022 23:08:57 needed for thread 1
ORA-00289: suggestion :
/u01/app/oracle/fast_recovery_area/dbname/archivelog/2022_12_05/o1_mf_1_270_%u_.ar
c
ORA-00280: change 49556642 for thread 1 is in sequence #270
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}