Step by Step to Disabling and droping old RAC instance Log group and thread

Step by Step to Disabling and droping old RAC instance Log group and thread

SQL> select GROUP#,THREAD# from v$log;
    GROUP#    THREAD#
---------- ----------
         1          1
         2          1
         3          1
         4          2
         5          2
         6          2
6 rows selected.
SQL> alter database drop logfile group 4;
alter database drop logfile group 4
*
ERROR at line 1:
ORA-01623: log 4 is current log for instance PROD2 (thread 2) - cannot drop
ORA-00312: online log 4 thread 2: '/u02/UAT02/data/redo04b.dbf'
ORA-00312: online log 4 thread 2: '+DGUAT02/uat02/onlinelog/group_4.385.803355387'
ORA-00312: online log 4 thread 2: '+DGUAT02/uat02/onlinelog/group_4.386.803355389'
SQL> ALTER DATABASE DISABLE THREAD 2;

Database altered.

SQL> alter database drop logfile group 4;

Database altered.

SQL> alter database drop logfile group 5;

Database altered.

SQL> alter database drop logfile group 6;

Database altered.

SQL>