ORA-00361

This was tested on an Oracle 9 database. 

One way to relocate redo log groups is to drop members in one location and recreate them in another. However, if your redo log group only has one member and you want to relocate it, you need to create the new member first. If you don’t do this, you get an ORA-00361 as a redo log group must always have at least one member:

 

SQL> select member from v$logfile

  2  where group# = 4

  3  /

 

MEMBER

----------------------------------------

/cisdpt/misdpt1/mis_redo1/redo4_1.dbf

 

SQL> alter database drop logfile member

  2  '/cisdpt/misdpt1/mis_redo1/redo4_1.dbf'

  3  /

alter database drop logfile member

*

ERROR at line 1:

ORA-00361: cannot remove last log member

/cisdpt/misdpt1/mis_redo1/redo4_1.dbf for group 4

 

SQL>

ORA-00360

Oracle returns an ORA-00360 if you try to drop a redo logfile member which does not exist: 

SQL> select group#, member from v$logfile

  2  order by 1, 2;

 

    GROUP# MEMBER

---------- ----------------------------------------

         1 /disk1/redo/log1a.rdo

         1 /disk2/redo/log1b.rdo

         2 /disk1/redo/log2a.rdo

 

SQL> alter database drop logfile member

  2  '/disk2/redo/log2b.rdo';

alter database drop logfile member

*

ERROR at line 1:

ORA-00360: not a logfile member: /disk2/redo/log2b.rdo

 

SQL>

Adding Redo Log Group Members

You can use the alter database add logfile member command to add extra member(s) to a redo log group. You might do this:

 

(1)  To add an extra member on a different disk and remove a single point of failure.

(2)  In conjunction with the alter database drop logfile member, to move a redo log group from one disk to another.

 

You can tell Oracle where to add the new member by giving a group number:

 

SQL> select group#, member from v$logfile;

 

    GROUP# MEMBER

---------- ----------------------------------------

         2 /disk1/redo/log2a.rdo

         1 /disk1/redo/log1a.rdo

 

SQL> alter database add logfile member

  2  '/disk2/redo/log1b.rdo'

  3  to group 1;

 

Database altered.

 

SQL> select group#, member from v$logfile;

 

    GROUP# MEMBER

---------- ----------------------------------------

         2 /disk1/redo/log2a.rdo

         1 /disk1/redo/log1a.rdo

         1 /disk2/redo/log1b.rdo

 

SQL>

 

Or by providing the name(s) of the members already in the group:

 

SQL> select group#, member from v$logfile;

 

    GROUP# MEMBER

---------- ----------------------------------------

         2 /disk1/redo/log2a.rdo

         1 /disk1/redo/log1a.rdo

         1 /disk2/redo/log1b.rdo

 

SQL> alter database add logfile member

  2  '/disk2/redo/log2b.rdo' to

  3  '/disk1/redo/log2a.rdo';

 

Database altered.

 

SQL> select group#, member from v$logfile

  2  order by 1, 2;

 

    GROUP# MEMBER

---------- ----------------------------------------

         1 /disk1/redo/log1a.rdo

         1 /disk2/redo/log1b.rdo

         2 /disk1/redo/log2a.rdo

         2 /disk2/redo/log2b.rdo

 

SQL>