1. In startup Linux, Oracle reports the following error:
ORA-27102: out of memory Linux-X86_64
Error: 28: No space left on device
2. Check the alter log to report:
Checkpoint not complete
Current log #3 seq #514388 mem #0:/opt/oracle/product/10.2.0/oradata/orcl/redo03.log
Thread 1 advanced to log sequence 514389
Current log #2 seq #514389 mem #0:/opt/oracle/product/10.2.0/oradata/orcl/redo02.log
Wed Feb 13 21:36:22 2013
Thread 1 advanced to log sequence 514390
Current log #1 seq #514390 mem #0:/opt/oracle/product/10.2.0/oradata/orcl/redo01.log
3. Check the redo log size:
SQL> select bytes/1024/1024 from v $ log;
BYTES/1024/1024
---------------
50
50
50
4. After adding and modifying the redo log size by referring to the redo log size of other provinces:
SQL> select bytes/1024/1024 from v $ log;
BYTES/1024/1024
---------------
500
500
500
500
500
5. Check that the system does not report the Checkpoint not complete error again in the alter log. The system is normal.