
Today, we will learn how to drop standby redo logs in Oracle in this article. Let’s go through this step by step:
Steps to drop standby redo logs in Oracle :
Step 1: Stop MRP
SQL>alter database recover managed standby database cancel;
Step 2: SET STANDBY_FILE_MANAGEMENT=’MANUAL’
If the above parameter ‘standby_file_management’ is auto, we have to set it manual
SQL>alter system set standby_file_managament='MANUAL';
Step 3: Drop SRLs in the Standby Database
SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP 4;
Database altered.
SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP 5;
Database altered.
SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP 6;
Database altered.
SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP 7;
Database altered.
Step 4: Check if the SRLs are dropped :
SQL>select * from v$logfile;
Step 5: SET STANDBY_FILE_MANAGEMENT=’AUTO’
SQL>alter system set standby_file_managament='AUTO';
Step 6: Start MRP
SQL>alter database recover managed standby database disconnect from session;
Hope this helps to do how to drop standby redo logs in Oracle!! Also, you can get more information from the below Oracle Doc as well.
Our Other Oracle Related Articles :
- Insufficient SRLs reported by DGMGRL
- ORA-00392: log 2 of thread 1 is being cleared, operation not allowed