Took over a new library ,alert Log frequent reporting log file switch (checkpoint incomplete) event

oracle A document explaining :

Waiting for a log switch because the session cannot wrap into the next log. Wrapping cannot be performed because the checkpoint for that log has not completed.

see redo Log information :

SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- -------- ---------------- ------------- ----------- ------------ -----------
YES INACTIVE // //
NO CURRENT //
YES INACTIVE // // SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
ONLINE D:\APP\ADMINISTRATOR\ORADATA\YB\REDO03.LOG NO
ONLINE D:\APP\ADMINISTRATOR\ORADATA\YB\REDO02.LOG NO
ONLINE D:\APP\ADMINISTRATOR\ORADATA\YB\REDO01.LOG NO SQL>

Check the switching frequency :

SQL> select completion_time from v$archived_log order by desc;

I found that when the system is busy , Logs switch several times a minute .

Solution :

Add a log group and adjust the log size to 100m

alter database add logfile group ('D:\APP\ADMINISTRATOR\ORADATA\YB\REDO04a.LOG ','D:\APP\ADMINISTRATOR\ORADATA\YB\REDO04b.LOG ') size 100M;

And then the other three groups redo Log adjustment : Delete existing log groups , Then rebuild ( To adjust the log group to inactive State before operation )

alter database drop logfile group ;
alter database add logfile group ('D:\APP\ADMINISTRATOR\ORADATA\YB\REDO03a.LOG ','D:\APP\ADMINISTRATOR\ORADATA\YB\REDO03b.LOG ') size 100M;
...

log file switch (checkpoint incomplete) More articles about

  1. log file switch (checkpoint incomplete) - It's easy to be misdiagnosed event

    In this paper, from  https://blogs.oracle.com/database4cn/log-file-switch-checkpoint-incomplete-%e5%ae%b9%e6%98%93%e ...

  2. ORACLE Events wait : log file parallel write

    log file parallel write The concept is introduced log file parallel write Event is LGWR Process specific wait events , It happened in LGWR Set the log buffer (log_buffer) Redo log in ...

  3. understand LGWR,Log File Sync Waits as well as Commit Performance problems of [ turn ]

    understand LGWR,Log File Sync Waits as well as Commit Performance problems of One . Summary : 1.  Commit and log filesync How it works 2.   Why? log file wait Too long 3. ...

  4. Script to Collect Log File Sync Diagnostic Information (lfsdiag.sql) ( file ID 1064487.1)

    the article from :http://m.blog.itpub.net/31393455/viewspace-2130875/ Script to Collect Log File Syn ...

  5. log file sync Waiting for superelevation case analysis

    Monitoring tools DPA Found an overseas one Oracle database server DB Commit Time Indicator alarm , Over the Red Alert line (40 Millisecond or so , Yellow alert yes 10 millisecond , The red alarm line is 20 millisecond ), As shown in the screenshot below , Generated the corresponding period of AWR ...

  6. Oracle Redo log files online (ONLINE LOG FILE)

    --========================================= -- Oracle  Redo log files online (ONLINE LOG FILE) --================== ...

  7. Linux/Unix shell monitor Oracle Alarm log (monitor alter log file)

    Use shell Script implementation to Oracle Database monitoring and management will be greatly simplified DBA The burden of work , Such as the common instance monitoring , Monitoring of monitoring , Monitoring of alarm log , And database backup ,AWR report Automatic mail, etc . This paper gives the Linu ...

  8. log file sync

    Recently, our application system has updated one app. I receive a email of complain the db server ch ...

  9. 1025InnoDB log file How suitable the setting is

    from  http://blog.csdn.net/langkeziju/article/details/51094289 Database stuff , Often one parameter involves N More knowledge . So to put it simply . Everybody knows inno ...

Random recommendation

  1. webapi modify tt The template adds... To the field JsonIgnore Features solve transformation json Circular quotation problem

    0. Problem description EF Generated model With navigation properties , be json Serialization will report a circular reference error , Try the following protected void Application_Start() { GlobalConfigurati ...

  2. Failed to execute goal org.codehaus.cargo:cargo-maven2-plugin:1.2.3:run (default-cli) on project Maven_WebTest: Execution default-cli of goal org.codehaus.cargo:cargo-maven2-plugin:1.2.3:run failed: C

    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/20 ...

  3. css3 Cool load animation variety

    Online examples :http://www.admin10000.com/document/3601.html Source code :https://github.com/tobiasahlin/SpinKit

  4. C# according to CPU+ Disk label to register software

    A lot of personal software needs to sell their own works to others, and can only be used by one computer , No computer can run its own software , So there is the control of software registration restrictions , Collected a help class for registering software , Share the record . Function is introduced :    according to CPU+ ...

  5. C# operation Excel ( Two )

    According to reading LTP.Net Knowledge base series 4 Office Operation function : One . Records are often used as follows (1)“ Host in your own program Office” It means on the form of our own application , It's like Office Application like that ...

  6. Garlic maker NOIP2017 Improve group simulation ( 5、 ... and )day2- The ants move

    Portal This problem can be maintained by line tree #include<cstdio> #include<cstdlib> #include<algorithm> #include< ...

  7. Mybatis Plug in principle analysis ( One )

    Let's first introduce Mybatis Plug in related classes , And has carried on the simple analysis to the source code . Mybatis Plug in related interfaces or classes are :Intercept.InterceptChain.Plugin and Invocation, this ...

  8. Python OS Common modules

    python Reading and writing . establish file the second : Directory operation - Additions and deletions Third : Judge The fourth one :PATH The fourth one :os.mknod create a file ( Not a directory ) import os os.chdir("/&quo ...

  9. 20175234 2018-2019-2 《Java Programming 》 Fourth week learning summary

    20175234 2018-2019-2 <Java Programming > Fourth week learning summary Summary of the learning content of the textbook The textbook has learned subclasses , The focus is on method rewriting . Object transformation and polymorphism , The idea of abstract oriented programming is emphasized . Study I ...

  10. EventBus Use ; Message delivery is EventBus;

    EventBus The message ( data ) It's a little bit like radio , Those who are interested in broadcasting data can take a look at :Android Data transfer , Use radio BroadcastReceiver: 1. add to build.gradle implemen ...