Hello,
on Windows Server 2012R2 with Oracle Dabase 11gR2 and on Windows Server 2019 with Oracle Database 19c online redo logs have not updated several days (modified time has not change), despite the fact the database is OPEN and many DML changes followed with COMMITs were performed.
Oracle documentation to 11g (https://docs.oracle.com/cd/E11882_01/server.112/e25494/onlineredo.htm#ADMIN11303) and 19c (https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-the-redo-log.html#GUID-4625A35C-EF8A-4A9E-8D19-829C1A665A34) says "Whenever a transaction is committed, LGWR writes the transaction redo records from the redo log buffer of the SGA to a redo log file, and assigns a system change number (SCN) to identify the redo records for each committed transaction."
However update times often freeze on time the database was bounced. Members of all groups hold the same update time for serveral days or weeks despite many commited transactions. One group is marked as CURRENT, the other as INACTIVE - this corresponds with documentation. However online logs on are not modified as database documentation describes.
It brings a question if instant recovery can be performed correctly if online redologs do not seem to change despite of commited transactions.
This does not happen on Linux and Unix database servers.
Could anyone explain it, please?
Regards
Leos