The sequence# in v_$archived_log is out of sequence
The server shut down because of a corrupted file. Once we got the server back up we had an issue with the database in that the sequence# in v_$archived_log was no longer sequenced. It should have been 755, 426, but it had started numbering at 1. I tried to reset the sequencing by running the following:
alter v_$archived_log
set sequence# = sequence# + 755426
where completion_time < to_date(‘03-NOV-2023 02:55:00', 'DD-MON-YYYY HH24:MI:SS')
and applied = 'NO'
and upper(name) = 'SDG';
But I get the error: ora-02030: can only select from fixed tables/views
Additionally before the corrupted file occurrence applied was YES, but now it is NO.
0