AWS Oracle RDS - Bunch of *Thread 1 advanced to log sequence xxxxxx (LGWR switch) *

0

Hi! I see a whole bunch of *Thread 1 advanced to log sequence xxxxxxx (LGWR switch) * in the Cloud Watch. May I ask somebody to explain what it means and what I can do within the realm of AWS Oracle RDS, please? I searched for this issue but all recommendations relate to standalone Oracle instances.

Many thanks in advance,

질문됨 2년 전829회 조회
1개 답변
1

Every Oracle database has a set of two or more online redo log files. The set of online redo log files is collectively known as the redo log for the database. The database log writer process (LGWR) writes redo records from the memory buffer to a redo log group until the log files in that group reach their storage size limit, or until you request a log switch operation. The LGWR process then writes to the next log group. The LGWR process performs this action in a circular fashion so that the oldest group is overwritten by the most recent redo records. This process is called a log switch and oracle logs this information in alert log with the above message. You can safely ignore it, unless you are seeing a log switch happening more that 3-4 times an hour. ( a general rule of thumb) If it does, then you need to add larger online redo logs and drop the existing ones.

AWS
답변함 2년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠