Tuesday, May 27, 2014


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  /
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

No comments: