SELECT *
FROM v$controlfile_record_section
WHERE TYPE = 'REDO LOG';
CHECK THE BELOW VALUES:
records_total
records_used
SELECT *
FROM v$controlfile_record_section
WHERE TYPE = 'REDO LOG';
CHECK THE BELOW VALUES:
records_total
records_used