Explanation:
In this situation, Oracle eventually won’t allow new records to be added to the database, and the entire database will go into a prolonged wait state until the redo log is cleared. So, something will happen, and Oracle will not switch to a new redo log automatically. However, the instance does not crash, either – it simply freezes and won’t allow changes to be made or new users to connect.
Reference:
Oracle 9i: Administrator’s Guide
Oracle 9i: Concepts

---