How To Maintain and/or Add Redo Logs [ID 602066.1]
In this Document
Goal
Solution
References
Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.3 - Release: 9.2 to 11.2Information in this document applies to any platform.
Goal
The purpose of this document is to demonstrate:
A. How to maintain and/or add redo logs.
B. How to determine the optimal size for redo logs
Solution
A. How to maintain and/or add redo logs.
1. Review information on existing redo logs.
FROM v$log a, v$logfile b
WHERE a.group#=b.group#
2. Add new groups
ALTER DATABASE ADD LOGFILE group 5 ('/log02A.dbf', '/log02B.dbf ') SIZE 512M;
ALTER DATABASE ADD LOGFILE group 6 ('/log03A.dbf', '/log03B.dbf ') SIZE 512M;
3. Check the status on all redo logs again.
FROM v$log a, v$logfile b
WHERE a.group#=b.group#
4. Drop the online redo log groups that are not needed. You must have the ALTER DATABASE system privilege.
a. An instance requires at least two groups of online redo log files, regardless of the number of members in the groups. (A group is one or more members.)
b. You can drop an online redo log group only if it is INACTIVE. If you need to drop the current group, first force a log switch to occur.
By using this command :
ALTER SYSTEM SWITCH LOGFILE;
c. Make sure an online redo log group is archived (if archiving is enabled) before dropping it. This can be determined by:
GROUP# ARC STATUS
--------- --- ----------------
1 YES ACTIVE
2 NO CURRENT
3 YES INACTIVE
4 YES UNUSED
5 YES UNUSED
6 YES UNUSED
d. Check that the group is inactive and archived before dropping it .
e. After dropping an online redo log group, make sure that the drop completed successfully, and then use the appropriate operating system command to delete the dropped online redo log files. For more information refer to Note 395062.1
B. How to determine the optimal size for redo logs
You can use the V$INSTANCE_RECOVERY view column OPTIMAL_LOGFILE_SIZE to determine the size of your online redo logs. This field shows the redo log file size in megabytes that is considered optimal based on the current setting of FAST_START_MTTR_TARGET. If this field consistently shows a value greater than the size of your smallest online log, then you should configure all your online logs
to be at least this size.
Note, however, that the redo log file size affects the MTTR. In some cases, you may be able to
refine your choice of the optimal FAST_START_MTTR_TARGET value by re-running the MTTR Advisor with your suggested optimal log file size.
You can also refer to this Note 1038851.6 - How to Estimate Size of Redo Logs
Please note that there is no column OPTIMAL_LOGFILE_SIZE in
V$INSTANCE_RECOVERY view in 9i. It only applies to 10g.
References
NOTE:395062.1 - How to Change The Location Of Redo Log FilesNOTE:1035935.6 - Example of How To Resize the Online Redo Logfiles
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-752742/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to Find Sessions Generating Lots of Redo or Archive logsSessionHive
- How to Add/Drop/Resize Redo Log with Physical Standby in place. [ID 473442.1]
- SQL: How to Find Sessions Generating Lots of Redo or Archive logsSQLSessionHive
- SQL: How to Find Sessions Generating Lots of Redo or Archive logs-167492.1SQLSessionHive
- How to maintain Oracle10g RecyclebinAIOracle
- Usage, Benefits and Limitations of Standby Redo Logs (SRL) [ID 219344.1]MIT
- How Can We Maintain Decanter Centrifuge for Mud Solids Control?AISolid
- 【操作】調整Online Redo Logs大小(Resizing Oracle Online Redo Logs)Oracle
- How Logs Work On MySQL With InnoDB TablesMySql
- Master Note: Troubleshooting Redo Logs and Archiving (文件 ID 1507157.1)AST
- how to add a hba adapter on redhatAPTRedhat
- SAP How to maintain missing enrties in TJ07 via customizingAI
- How can I add a site title refiner
- Master Note: Overview of Redo Logs and Archiving_1503091.1ASTView
- Centos/RHEL :How to add,delete and display LVM tagsCentOSdeleteLVM
- How to Add a New Disk new partition in centos7CentOS
- [Laragon Tutorial] How to add another PHP version (PHP 8.3.4)GoPHP
- Archived Redo Logs歸檔重做日誌介紹及其優點Hive
- Oracle OCP 1Z0-053 Q291(encrypted tablespace&redo logs)Oracle
- How to 計算當前redo日誌的使用率
- ASM Installation Logs Location. [ID 1349705.1]ASM
- Olsnodes Produces CPU Spikes With Many Logs [ID 729349.1]
- IDBObjectStore.add() 方法Object
- Maintain profile parameter dynamic with function.AIFunction
- Maintain Internet Transaction Server (ITS)AIServer
- 【nginx】invalid PID number ““ in “/usr/local/nginx/logs/nginx.pid“Nginx
- How To Kill Good IdeasGoIdea
- How to compile Invalid Object?CompileObject
- SAP Tcode for Maintain Tax Code - FTXPAI
- oracle9i(9204)dg(data guard)_adding and dropping online redo logs_物理_physicalOracle
- How to Prepare Storage for ASM (Doc ID 452924.1)ASM
- How to Troubleshoot Grid Infrastructure Startup IssuesASTStruct
- How to find the UDID for an iPhone/iPod touchiPhone
- How to Brainstorm New IdeasAIORMIdea
- How to tacktrace In Android for Java codeAndroidJava
- How to resolve : Authentication denied: Boot identity not validbootIDE
- how to use oidpasswd to admin your AS/OID account
- Using the Template Collection to Add a Template Column in WebDataGridWeb