v$controlfile_record_section.RECORDS_USED
Hello!
In alert.log I see message
GAP - thread 1 sequence 538-538
DBID ............ branch ...................
FAL[client]: All defined FAL servers have been attempted.
------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that's sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
------------------------------------------------------------
My actions:
- crosscheck archivelog all;
- delete noprompt expired archivelog all;
- increasing CONTROL_FILE_KEEP_TIME (standby site), but no information in alert.log about expanding of controlfile section.
Can You please explain why the value of v$controlfile_record_section.RECORDS_USED did't decrease ?
(Oracle database 11.2.0.4.0)