Friday, December 20, 2013

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>

No comments: