Tuesday, May 27, 2014

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>

No comments: