Temat: 11g i rozmiar archivelogów
Kamil Stawiarski:
A V$LOGFILE.STATUS?
Próbowałeś dodać nowe grupy? Zachowują się tak samo? Jak robiłeś migrację?
Nulle są.
Nie ja robiłem migrację ... ale zrobiłem do tej bazy standby i przy tej okazji zauważyłem nienaturalną wielkość i częstotliwość redologów.
Wed Apr 28 16:39:06 2010
Beginning log switch checkpoint up to RBA [0x1890.2.10], SCN: 7810419497022
Thread 1 advanced to log sequence 6288 (LGWR switch)
Current log# 3 seq# 6288 mem# 0: /u04/oradata/ORCL/redo03.log
Current log# 3 seq# 6288 mem# 1: /u01/oradata/ORCL/redo06.log
Wed Apr 28 16:39:07 2010
Archived Log entry 7005 added for thread 1 sequence 6287 ID 0xd973b433 dest 1:
Wed Apr 28 16:44:04 2010
Completed checkpoint up to RBA [0x1890.2.10], SCN: 7810419497022
Wed Apr 28 16:47:22 2010
Beginning log switch checkpoint up to RBA [0x1891.2.10], SCN: 7810419526728
Thread 1 advanced to log sequence 6289 (LGWR switch)
Current log# 1 seq# 6289 mem# 0: /u04/oradata/ORCL/redo01.log
Current log# 1 seq# 6289 mem# 1: /u01/oradata/ORCL/redo04.log
Wed Apr 28 16:47:22 2010
Archived Log entry 7007 added for thread 1 sequence 6288 ID 0xd973b433 dest 1:
Wed Apr 28 16:49:35 2010
Incremental checkpoint up to RBA [0x1890.4dac.0], current log tail at RBA [0x1891.20d9.0]
Wed Apr 28 16:51:23 2010
Beginning log switch checkpoint up to RBA [0x1892.2.10], SCN: 7810419554421
Thread 1 advanced to log sequence 6290 (LGWR switch)
Current log# 2 seq# 6290 mem# 0: /u04/oradata/ORCL/redo02.log
Current log# 2 seq# 6290 mem# 1: /u01/oradata/ORCL/redo05.log
Wed Apr 28 16:51:23 2010
Archived Log entry 7009 added for thread 1 sequence 6289 ID 0xd973b433 dest 1:
Wed Apr 28 16:52:14 2010
Thread 1 cannot allocate new log, sequence 6291
Checkpoint not complete
Current log# 2 seq# 6290 mem# 0: /u04/oradata/ORCL/redo02.log
Current log# 2 seq# 6290 mem# 1: /u01/oradata/ORCL/redo05.log
Wed Apr 28 16:52:14 2010
Completed checkpoint up to RBA [0x1891.2.10], SCN: 7810419526728
Beginning log switch checkpoint up to RBA [0x1893.2.10], SCN: 7810419578766
Thread 1 advanced to log sequence 6291 (LGWR switch)
Current log# 3 seq# 6291 mem# 0: /u04/oradata/ORCL/redo03.log
Current log# 3 seq# 6291 mem# 1: /u01/oradata/ORCL/redo06.log
Wed Apr 28 16:52:17 2010
Archived Log entry 7011 added for thread 1 sequence 6290 ID 0xd973b433 dest 1: