Oracle10g 50M的online redo 歸檔為什麼都小於50M ?
Subject: Archive logs are created with smaller, uneven size than the original redo logs. Why?
Doc ID: Note:388627.1 Type: HOWTO
Last Revision Date: 02-JUN-2007 Status: MODERATED
In this Document
Goal
Solution
References[@more@]http://www.itpub.net/viewthread.php?tid=921121&extra=&highlight=%2Btolywang&page=2
--------------------------------------------------------------------------------
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.
Applies to:
Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.1
Information in this document applies to any platform.
Goal
Archive logs are created with smaller, uneven size than the original redo logs.
Commands like:
ALTER SYSTEM SWITCH LOGFILE
or
ALTER SYSTEM ARCHIVE LOG ...
are not used to generate archive or switch the logfile. As well, there is no ARCHIVE_LAG_TARGET parameter set.
What else could cause such a behaviour?
Solution
According to:
Bug 5450861 : ARCHIVE LOGS ARE GENERATED WITH A SMALLER SIZE THAN THE REDO LOG FILES
the explanation for this situation has 2 main reasons:
1. the archive logs do not have to be even in size. This was decided a very long time ago, when blank padding the archive logs has stopped, for a very good reason - in order to save disk space.
2. the log switch does not occur when a redo log file is 100% full. There is an internal algorythm that determines the log switch moment. This has also a very good reason - doing the log switch at the last moment could incur performance problems (for various reasons, out of the scope of this note).
As a result, after the log switch occurs the archivers are copying only the actual information from the redo log files. Since the redo logs are not 100% full after the log switch and the archive logs are not blank padded after the copy operation has finished, this results in uneven, smaller files than the original redo log files.
This is very conspicuous for very small redo log files (smaller than 10 MB); as such, the 2.5 MB archive logs generated from 5 MB redo logs are very visible.
Just note that at this moment, the default redo log files are 100 MB in size. If the resulting archive log files would be between 98 and 100 MB nobody would notice.
The main concern that one should have for the archive log files is an eventual corruption. This can be very easily checked by trying a test recovery. When this is ok, the uneven archive log size should be of no concern, as it's expected.
References
Bug 5450861 - ARCHIVE LOGS ARE GENERATED WITH A SMALLER SIZE THAN THE REDO LOG FILES
Doc ID: Note:388627.1 Type: HOWTO
Last Revision Date: 02-JUN-2007 Status: MODERATED
In this Document
Goal
Solution
References[@more@]http://www.itpub.net/viewthread.php?tid=921121&extra=&highlight=%2Btolywang&page=2
--------------------------------------------------------------------------------
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.
Applies to:
Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.1
Information in this document applies to any platform.
Goal
Archive logs are created with smaller, uneven size than the original redo logs.
Commands like:
ALTER SYSTEM SWITCH LOGFILE
or
ALTER SYSTEM ARCHIVE LOG ...
are not used to generate archive or switch the logfile. As well, there is no ARCHIVE_LAG_TARGET parameter set.
What else could cause such a behaviour?
Solution
According to:
Bug 5450861 : ARCHIVE LOGS ARE GENERATED WITH A SMALLER SIZE THAN THE REDO LOG FILES
the explanation for this situation has 2 main reasons:
1. the archive logs do not have to be even in size. This was decided a very long time ago, when blank padding the archive logs has stopped, for a very good reason - in order to save disk space.
2. the log switch does not occur when a redo log file is 100% full. There is an internal algorythm that determines the log switch moment. This has also a very good reason - doing the log switch at the last moment could incur performance problems (for various reasons, out of the scope of this note).
As a result, after the log switch occurs the archivers are copying only the actual information from the redo log files. Since the redo logs are not 100% full after the log switch and the archive logs are not blank padded after the copy operation has finished, this results in uneven, smaller files than the original redo log files.
This is very conspicuous for very small redo log files (smaller than 10 MB); as such, the 2.5 MB archive logs generated from 5 MB redo logs are very visible.
Just note that at this moment, the default redo log files are 100 MB in size. If the resulting archive log files would be between 98 and 100 MB nobody would notice.
The main concern that one should have for the archive log files is an eventual corruption. This can be very easily checked by trying a test recovery. When this is ok, the uneven archive log size should be of no concern, as it's expected.
References
Bug 5450861 - ARCHIVE LOGS ARE GENERATED WITH A SMALLER SIZE THAN THE REDO LOG FILES
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-998726/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle10g 50M的online redo 歸檔為什麼都小於50M ?Oracle
- ocssd.log filesize >50MCSS
- 網路頻寬50M其實單位是bit
- 為什麼我的歸檔檔案比我設定的線上日誌的大小要小?
- 為什麼說iPhone迴歸小屏沒有意義?iPhone
- 修改online redo日誌檔案大小
- 真沒想到,一個才區區50M的小遊戲居然能如此深刻?遊戲
- 更改oracle10g的歸檔模式和歸檔路徑Oracle模式
- oracle10g 歸檔模式和非歸檔模式的轉換Oracle模式
- imp資料的時候,50M的LOG,每十四秒切換一次,正常嗎?
- 教你如何成為Oracle 10g OCP - 第十三章補充:RMAN為什麼不備份online redoOracle 10g
- 為什麼做AI的都選Python?AIPython
- 為什麼都放棄了LangChain?LangChain
- 每天產生REDO歸檔日誌量
- 為什麼 API 監控對於任何業務來說都重要?API
- 為什麼API監控對於任何業務來說都重要?API
- oracle10g data guard(dg)__Adding or Dropping Online Redo Log FilesOracle
- Online Redo Log 結構
- Oracle10G歸檔模式應用Oracle模式
- Oracle10g歸檔引數研究Oracle
- 【操作】調整Online Redo Logs大小(Resizing Oracle Online Redo Logs)Oracle
- rman備份後為什麼要同時備份歸檔日誌
- 什麼是java?為什麼大家都學習java技術?Java
- 谷歌為什麼必須迴歸中國谷歌
- 關於redo的幾個小知識點
- 非歸檔模式改為歸檔模式模式
- 為什麼抄FGO的都沒有好下場?Go
- 為什麼人人都該懂點LLVMLVM
- 程式設計師為什麼都穿得那麼醜程式設計師
- 關於Online Redo Log Contents的一句話不理解。
- Linux中什麼是打包?與歸檔有什麼區別?Linux
- Oracle的redo到底記錄了什麼Oracle
- 為什麼在vue中寫的css都沒法生效VueCSS
- Oracle10g RAC下啟用歸檔模式Oracle模式
- 常見問題--oracle10g歸檔模式Oracle模式
- online redo file讀書筆記筆記
- 為什麼每個人都討厭GO語言?Go
- online redo log 操作 -- 更改RAC資料庫日誌檔案大小資料庫