How to drop standby redo logs in Oracle : 5 easy Steps

drop standby redo logs in Oracle

Today, we will learn how to drop standby redo logs in Oracle in this article. Let’s go through this step by step:

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.

How to Drop/recreate A Standby Redo Log Group From Standby Database Which is Active status (Doc ID 2516522.1)

Our Other Oracle Related Articles :

Leave a Reply