Drop Online Redo Log Group In Standby

Before dropping a redo log group, consider the following restrictions and precautions: An instance requires at least two groups of redo log files, regardless of the number of members in the groups. (A group comprises one or more members.) You can drop a redo log group only if it is inactive.

Oct 04, 2011 · How to Drop/Rename Standby Redolog file in Oracle 11g While performing the dataguard Broker, we need to drop the standby database while switchover the standby . ... SQL> alter database drop standby logfile group 4; Database altered. ... Once , i receive the e-mail regarding the resize of the redo log file . The Sender want the easiest way to ...

Jun 07, 2017 · >>Ok, as you can see, you cannot drop the current redo log group on standby database because you cannot marked it as INACTIVE or in another status that allows you to drop the redo log group. >>But there is an option that you can use. >>If you want to recreate the redo log group in anoter location,...

Apr 29, 2013 · 9. Clear the log group first before drop. ALTER DATABASE CLEAR LOGFILE GROUP 1; 10. Now drop online redo log. alter database drop logfile group 1; Follow the same process for rest of the groups. 11. Now drop standby redo logs, leave the one which refuses to drop. alter database drop standby logfile group 5; 12. Now create new online redo logs.

SQL> SQL> alter database drop standby logfile group 4; alter database drop standby logfile group 4 * ERROR at line 1: ORA-01156: recovery or flashback in progress may need access to files SQL> alter database recover managed standby database cancel; Database altered.

So now the standby/online redo logfiles are modified on the STANDBY database time to go to the primary and execute the steps for the online redo logfiles as well as the standby redo logfiles. If you receive an message ORA-01623: log # is current log for instance (thread #) – cannot drop. Check out this blog for a solution.

Jul 29, 2009 · online logs, recreate online redo logs, redolog; ... Intention is to drop and recreate these online logs with a different size. ... You dropped log group 3 but did not remove the physical file redo03.log from disk /u03/oradata/test and tried to recreate the group.

Dropping Logfile Group. Similarly, you can also drop logfile group only if the database is having more than two groups and if it is not the current group. SQL>alter database drop logfile group 3; Note: When you drop logfiles the files are not deleted from the disk. You have to use O/S command to delete the files from disk. Resizing Logfiles