Hello
Does a redo log switch always invokes checkpoint process?
I have a test database on which nothing is running, but when i switch the redo log file, then it takes a while to make the status of redo log file from ACTIVE to INACTIVE.
But when i do alter system checkpoint; , the status changes immediately from ACTIVE to INACTIVE.
This gives me a feeling that on redo log switch, its not mandatory for checkpoint to happen.
DB version is 11.2.0.1
Kindly comment.