Thread 1 cannot allocate new log,Checkpoint not complete
alert 日誌中有這個錯誤
Thread 1 cannot allocate new log, sequence 319708
Checkpoint not complete
檢視下，當前資料庫的每組日誌大小為50M，每天切換300次左右。
對此，ORACLE給出的提示：
This message indicates that Oracle wants to reuse a redo log file, but the current checkpoint position is still in that log.
In this case, Oracle must wait until the checkpoint position passes that log.
Because the incremental checkpoint target never lags the current log tail by more than 90% of the smallest log file size,
this situation may be encountered if DBWR writes too slowly, or if a log switch happens before the log is completely full,
or if log file sizes are too small. When the database waits on checkpoints,redo generation is stopped until the log switch is done.
ORACLE給出的建議：
Add additional log group
Increase size of redo logs
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as sys@SG8 AS SYSDBA
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
1 1 319964 52428800 1 YES INACTIVE 3864251677 1/24/2014 7
2 1 319965 52428800 1 NO CURRENT 3864256297 1/24/2014 8
3 1 319963 52428800 1 YES INACTIVE 3864240823 1/24/2014 7
SQL> select bytes/1024/1024 from v$log;
BYTES/1024/1024
---------------
50
50
50
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
3 ONLINE D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO03.LOG NO
2 ONLINE D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO02.LOG NO
1 ONLINE D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO01.LOG NO
SQL> alter database add logfile group 4 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO04.LOG' size 100m;--這組日誌加小了，一會兒刪掉。
Database altered
SQL> alter database add logfile group 5 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO05.LOG' size 300m;
Database altered
SQL> alter database add logfile group 6 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO06.LOG' size 300m;
Database altered
SQL> alter database add logfile group 7 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO07.LOG' size 300m;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
1 1 319964 52428800 1 YES INACTIVE 3864251677 1/24/2014 7
2 1 319965 52428800 1 NO CURRENT 3864256297 1/24/2014 8
3 1 319963 52428800 1 YES INACTIVE 3864240823 1/24/2014 7
4 1 0 104857600 1 YES UNUSED 0
5 1 0 314572800 1 YES UNUSED 0
6 1 0 314572800 1 YES UNUSED 0
7 1 0 314572800 1 YES UNUSED 0
7 rows selected
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
1 1 319964 52428800 1 YES INACTIVE 3864251677 1/24/2014 7
2 1 319965 52428800 1 YES ACTIVE 3864256297 1/24/2014 8
3 1 319963 52428800 1 YES INACTIVE 3864240823 1/24/2014 7
4 1 319966 104857600 1 YES ACTIVE 3864260234 1/24/2014 8
5 1 319967 314572800 1 YES ACTIVE 3864260236 1/24/2014 8
6 1 319968 314572800 1 YES ACTIVE 3864260239 1/24/2014 8
7 1 319969 314572800 1 NO CURRENT 3864260241 1/24/2014 8
7 rows selected
SQL> alter database drop logfile group 1;
Database altered
SQL> alter database drop logfile group 3;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319965 52428800 1 YES ACTIVE 3864256297 1/24/2014 8
4 1 319966 104857600 1 YES ACTIVE 3864260234 1/24/2014 8
5 1 319967 314572800 1 YES ACTIVE 3864260236 1/24/2014 8
6 1 319968 314572800 1 YES ACTIVE 3864260239 1/24/2014 8
7 1 319969 314572800 1 NO CURRENT 3864260241 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319970 52428800 1 NO CURRENT 3864260514 1/24/2014 8
4 1 319966 104857600 1 YES INACTIVE 3864260234 1/24/2014 8
5 1 319967 314572800 1 YES INACTIVE 3864260236 1/24/2014 8
6 1 319968 314572800 1 YES INACTIVE 3864260239 1/24/2014 8
7 1 319969 314572800 1 YES ACTIVE 3864260241 1/24/2014 8
SQL> alter database drop logfile group 4;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319970 52428800 1 NO CURRENT 3864260514 1/24/2014 8
5 1 319967 314572800 1 YES INACTIVE 3864260236 1/24/2014 8
6 1 319968 314572800 1 YES INACTIVE 3864260239 1/24/2014 8
7 1 319969 314572800 1 YES ACTIVE 3864260241 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319970 52428800 1 YES ACTIVE 3864260514 1/24/2014 8
5 1 319971 314572800 1 NO CURRENT 3864261051 1/24/2014 8
6 1 319968 314572800 1 YES INACTIVE 3864260239 1/24/2014 8
7 1 319969 314572800 1 YES ACTIVE 3864260241 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319970 52428800 1 YES ACTIVE 3864260514 1/24/2014 8
5 1 319971 314572800 1 YES ACTIVE 3864261051 1/24/2014 8
6 1 319972 314572800 1 NO CURRENT 3864261053 1/24/2014 8
7 1 319969 314572800 1 YES ACTIVE 3864260241 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319970 52428800 1 YES ACTIVE 3864260514 1/24/2014 8
5 1 319971 314572800 1 YES ACTIVE 3864261051 1/24/2014 8
6 1 319972 314572800 1 YES ACTIVE 3864261053 1/24/2014 8
7 1 319973 314572800 1 NO CURRENT 3864261132 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319974 52428800 1 NO CURRENT 3864261156 1/24/2014 8
5 1 319971 314572800 1 YES ACTIVE 3864261051 1/24/2014 8
6 1 319972 314572800 1 YES ACTIVE 3864261053 1/24/2014 8
7 1 319973 314572800 1 YES ACTIVE 3864261132 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319974 52428800 1 YES ACTIVE 3864261156 1/24/2014 8
5 1 319975 314572800 1 NO CURRENT 3864261164 1/24/2014 8
6 1 319972 314572800 1 YES ACTIVE 3864261053 1/24/2014 8
7 1 319973 314572800 1 YES ACTIVE 3864261132 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319974 52428800 1 YES ACTIVE 3864261156 1/24/2014 8
5 1 319975 314572800 1 YES ACTIVE 3864261164 1/24/2014 8
6 1 319976 314572800 1 NO CURRENT 3864261181 1/24/2014 8
7 1 319973 314572800 1 YES ACTIVE 3864261132 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319974 52428800 1 YES INACTIVE 3864261156 1/24/2014 8
5 1 319975 314572800 1 YES ACTIVE 3864261164 1/24/2014 8
6 1 319976 314572800 1 YES ACTIVE 3864261181 1/24/2014 8
7 1 319977 314572800 1 NO CURRENT 3864261244 1/24/2014 8
SQL> alter database drop logfile group 2;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
5 1 319975 314572800 1 YES ACTIVE 3864261164 1/24/2014 8
6 1 319976 314572800 1 YES ACTIVE 3864261181 1/24/2014 8
7 1 319977 314572800 1 NO CURRENT 3864261244 1/24/2014 8
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
5 ONLINE D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO05.LOG NO
6 ONLINE D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO06.LOG NO
7 ONLINE D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO07.LOG NO
SQL> select bytes/1024/1024 from v$log;
BYTES/1024/1024
---------------
300
300
300
Thread 1 cannot allocate new log, sequence 319708
Checkpoint not complete
檢視下，當前資料庫的每組日誌大小為50M，每天切換300次左右。
對此，ORACLE給出的提示：
This message indicates that Oracle wants to reuse a redo log file, but the current checkpoint position is still in that log.
In this case, Oracle must wait until the checkpoint position passes that log.
Because the incremental checkpoint target never lags the current log tail by more than 90% of the smallest log file size,
this situation may be encountered if DBWR writes too slowly, or if a log switch happens before the log is completely full,
or if log file sizes are too small. When the database waits on checkpoints,redo generation is stopped until the log switch is done.
ORACLE給出的建議：
Add additional log group
Increase size of redo logs
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as sys@SG8 AS SYSDBA
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
1 1 319964 52428800 1 YES INACTIVE 3864251677 1/24/2014 7
2 1 319965 52428800 1 NO CURRENT 3864256297 1/24/2014 8
3 1 319963 52428800 1 YES INACTIVE 3864240823 1/24/2014 7
SQL> select bytes/1024/1024 from v$log;
BYTES/1024/1024
---------------
50
50
50
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
3 ONLINE D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO03.LOG NO
2 ONLINE D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO02.LOG NO
1 ONLINE D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO01.LOG NO
SQL> alter database add logfile group 4 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO04.LOG' size 100m;--這組日誌加小了，一會兒刪掉。
Database altered
SQL> alter database add logfile group 5 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO05.LOG' size 300m;
Database altered
SQL> alter database add logfile group 6 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO06.LOG' size 300m;
Database altered
SQL> alter database add logfile group 7 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO07.LOG' size 300m;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
1 1 319964 52428800 1 YES INACTIVE 3864251677 1/24/2014 7
2 1 319965 52428800 1 NO CURRENT 3864256297 1/24/2014 8
3 1 319963 52428800 1 YES INACTIVE 3864240823 1/24/2014 7
4 1 0 104857600 1 YES UNUSED 0
5 1 0 314572800 1 YES UNUSED 0
6 1 0 314572800 1 YES UNUSED 0
7 1 0 314572800 1 YES UNUSED 0
7 rows selected
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
1 1 319964 52428800 1 YES INACTIVE 3864251677 1/24/2014 7
2 1 319965 52428800 1 YES ACTIVE 3864256297 1/24/2014 8
3 1 319963 52428800 1 YES INACTIVE 3864240823 1/24/2014 7
4 1 319966 104857600 1 YES ACTIVE 3864260234 1/24/2014 8
5 1 319967 314572800 1 YES ACTIVE 3864260236 1/24/2014 8
6 1 319968 314572800 1 YES ACTIVE 3864260239 1/24/2014 8
7 1 319969 314572800 1 NO CURRENT 3864260241 1/24/2014 8
7 rows selected
SQL> alter database drop logfile group 1;
Database altered
SQL> alter database drop logfile group 3;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319965 52428800 1 YES ACTIVE 3864256297 1/24/2014 8
4 1 319966 104857600 1 YES ACTIVE 3864260234 1/24/2014 8
5 1 319967 314572800 1 YES ACTIVE 3864260236 1/24/2014 8
6 1 319968 314572800 1 YES ACTIVE 3864260239 1/24/2014 8
7 1 319969 314572800 1 NO CURRENT 3864260241 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319970 52428800 1 NO CURRENT 3864260514 1/24/2014 8
4 1 319966 104857600 1 YES INACTIVE 3864260234 1/24/2014 8
5 1 319967 314572800 1 YES INACTIVE 3864260236 1/24/2014 8
6 1 319968 314572800 1 YES INACTIVE 3864260239 1/24/2014 8
7 1 319969 314572800 1 YES ACTIVE 3864260241 1/24/2014 8
SQL> alter database drop logfile group 4;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319970 52428800 1 NO CURRENT 3864260514 1/24/2014 8
5 1 319967 314572800 1 YES INACTIVE 3864260236 1/24/2014 8
6 1 319968 314572800 1 YES INACTIVE 3864260239 1/24/2014 8
7 1 319969 314572800 1 YES ACTIVE 3864260241 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319970 52428800 1 YES ACTIVE 3864260514 1/24/2014 8
5 1 319971 314572800 1 NO CURRENT 3864261051 1/24/2014 8
6 1 319968 314572800 1 YES INACTIVE 3864260239 1/24/2014 8
7 1 319969 314572800 1 YES ACTIVE 3864260241 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319970 52428800 1 YES ACTIVE 3864260514 1/24/2014 8
5 1 319971 314572800 1 YES ACTIVE 3864261051 1/24/2014 8
6 1 319972 314572800 1 NO CURRENT 3864261053 1/24/2014 8
7 1 319969 314572800 1 YES ACTIVE 3864260241 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319970 52428800 1 YES ACTIVE 3864260514 1/24/2014 8
5 1 319971 314572800 1 YES ACTIVE 3864261051 1/24/2014 8
6 1 319972 314572800 1 YES ACTIVE 3864261053 1/24/2014 8
7 1 319973 314572800 1 NO CURRENT 3864261132 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319974 52428800 1 NO CURRENT 3864261156 1/24/2014 8
5 1 319971 314572800 1 YES ACTIVE 3864261051 1/24/2014 8
6 1 319972 314572800 1 YES ACTIVE 3864261053 1/24/2014 8
7 1 319973 314572800 1 YES ACTIVE 3864261132 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319974 52428800 1 YES ACTIVE 3864261156 1/24/2014 8
5 1 319975 314572800 1 NO CURRENT 3864261164 1/24/2014 8
6 1 319972 314572800 1 YES ACTIVE 3864261053 1/24/2014 8
7 1 319973 314572800 1 YES ACTIVE 3864261132 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319974 52428800 1 YES ACTIVE 3864261156 1/24/2014 8
5 1 319975 314572800 1 YES ACTIVE 3864261164 1/24/2014 8
6 1 319976 314572800 1 NO CURRENT 3864261181 1/24/2014 8
7 1 319973 314572800 1 YES ACTIVE 3864261132 1/24/2014 8
SQL> alter system switch logfile;
System altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
2 1 319974 52428800 1 YES INACTIVE 3864261156 1/24/2014 8
5 1 319975 314572800 1 YES ACTIVE 3864261164 1/24/2014 8
6 1 319976 314572800 1 YES ACTIVE 3864261181 1/24/2014 8
7 1 319977 314572800 1 NO CURRENT 3864261244 1/24/2014 8
SQL> alter database drop logfile group 2;
Database altered
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- -----------
5 1 319975 314572800 1 YES ACTIVE 3864261164 1/24/2014 8
6 1 319976 314572800 1 YES ACTIVE 3864261181 1/24/2014 8
7 1 319977 314572800 1 NO CURRENT 3864261244 1/24/2014 8
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
5 ONLINE D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO05.LOG NO
6 ONLINE D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO06.LOG NO
7 ONLINE D:\ORACLE\PRODUCT\10.2.0\ORADATA\AGENCY\REDO07.LOG NO
SQL> select bytes/1024/1024 from v$log;
BYTES/1024/1024
---------------
300
300
300
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26084062/viewspace-1074850/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Thread 1 cannot allocate new log Private strand flush not complete 警告thread
- Thread 1 cannot allocate new logthread
- Thread 1 cannot allocate new log, sequence NNN 錯誤thread
- 【ASK_ORACLE】檢查點錯誤“Cannot allocate new log”和“Checkpoint not complete”Oracle
- Thread 1 cannot allocate new log 的處理辦法thread
- 【轉】cannot allocate new log
- cannot allocate new log 的解決方法
- Manual Log Switching Causing Cannot Allocate New Log in Alert Log_435887.1
- Cannot complete applications logonAPPGo
- fork failed - Cannot allocate memoryAI
- Checkpoint not complete 日誌檔案問題
- Redis 寫磁碟出錯 Cannot allocate memoryRedis
- redis 寫磁碟出錯Cannot allocate memoryRedis
- alert日誌報checkpoint not complete解決思路
- Ubuntu Cannot allocate memory 錯誤解決方案Ubuntu
- redis : Can't save in background: fork: Cannot allocate memoryRedis
- 常見的Checkpoint not complete問題分析解決
- VM warning: INFO: OS::commit_memory Cannot allocate memoryMIT
- redolog threadthread
- new Thread與執行緒建立thread執行緒
- PostgreSQL xlog格式之checkpointSQL
- Oracle log_checkpoint_interval和Oracle
- 解決Can not allocate log問題的方法
- new Child();new Child(1);
- MySQL中的redo log和checkpointMySql
- RedoLog Checkpoint 和 SCN關係
- ORA-00322: log 3 of thread 1 is not current copythread
- ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DESTHive
- 關於log file switch and checkpoint機制
- log file switch (checkpoint incomplete)等待事件事件
- 【等待事件】log file switch (checkpoint incomplete)事件
- Oracle DG 出現 RFS[6]: No standby redo logfiles created for thread 1Oraclethread
- ORA-00392: log 15 of thread 1 is being cleared, operation not allowedthread
- a type "complete deletion of data target contents process cannot follow process" Excute Infopacakge
- ora-01034 ora-27121 Cannot allocate memory錯誤解決
- 為啥呼叫new Thread().start()方法會呼叫run()方法？thread
- ORA-01618: redo thread 2 is not enabled - cannot mountthread
- ORA-00312: online log 5 thread 1:誤刪standby log 日誌組thread