Shulou(Shulou.com)05/31 Report--

This article is about how Oracle maintains online redo log. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Maintain online redo log Oracle Database-Enterprise Edition-Version 11.2.0.4 to 11.2.0.4 1. First check the size of the current redo log: [oracle@oracle ~] $sqlplus / as sysdbaOracle Database 10g Enterprise Edition Release 10.2.0.1.0-64bit Production SQL > select group#, bytes, status from v$log GROUP# BYTES STATUS- 1 52428800 CURRENT 2 52428800 INACTIVE 3 52428800 INACTIVE current redo log is 50m Now it expands to 100m 2. View all online day group members SQL > select group#, member from v$logfile GROUP# MEMBER- 3 / oracle/oradata / orcl/redo03.log 2 / oracle/oradata/orcl/redo02.log 1 / oracle/oradata/orcl/redo01.log 3. Newly added redolog SQL > alter database add logfile group 4'/ oracle/oradata/orcl/log4PROD.dbf' size 100m of group# size 100m in 4-5-6 SQL > alter database add logfile group 5'/ oracle/oradata/orcl/log5PROD.dbf' size 100M; SQL > alter database add logfile group 6'/ oracle/oradata/orcl/log6PROD.dbf' size 100m; 4. Query the status of all current redo log: SQL > select group#, status from v$log GROUP# STATUS--1 CURRENT 2 INACTIVE 3 INACTIVE 4 UNUSED 5 UNUSED 6 UNUSED current redolog status, group 1 is the current online log group, group2, 3 are inactive What we want to delete is that 50m group 1, 2, 3 group 1 is the current online log group and cannot be deleted. Currently, we can delete group 2, 3 SQL > alter database drop logfile group 2 of inactive. Database altered. SQL > alter database drop logfile group 3; Database altered. 5. Switch log switches logs several times until group 1 is in inactive state, SQL > alter system checkpoint; System altered. SQL > alter system switch logfile; System altered. SQL > select group#, status from vault log; GROUP# STATUS--1 INACTIVE 4 UNUSED 5 UNUSED 6 UNUSED SQL > alter database drop logfile group 1; Database altered. Note: if checkpoint still fails to switch to inactive, do global checkpoint SQL > alter system checkpoint global; System altered 6. Check all the status of online logs again: SQL > select group#, bytes, status from v$log GROUP# BYTES STATUS- 4 104857600 INACTIVE 5 104857600 CURRENT 6 104857600 UNUSED 9. Delete the old redolog [oracle@oracle orcl] $rm / oracle/oradata/orcl/redo01.log [oracle@oracle orcl] $rm / oracle/oradata/orcl/redo02.log [oracle@oracle orcl] $rm / oracle/oradata/orcl/redo03.log 10 at the operating system level. Delete redo log had better do a backup of the database, when maintaining reodlog, it is best to operate at a low business peak. Thank you for your reading! This is the end of this article on "how to maintain online redo log in Oracle". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.