7 Replies Latest reply on Mar 27, 2007 11:45 AM by Eduardo Legatti

    dropping a redo log file in the mount state

    541410
      This is a test database.

      The database is in the mount state.

      When I did
      alter database drop logfile member '/home/ORA_OEM/data/OEMRMAN/redo04.log';

      I got the error
      ORA-01609: log 4 is the current log for thread 1 - cannot drop members
      ORA-00312: online log 4 thread 1: '/home/ORA_OEM/data/OEMRMAN/redo04.log'
      ORA-00312: online log 4 thread 1: '/ORA_OEM/data/OEMRMAN/redo04.log'

      The solution offered is: alter system switch logfile. But this works only when the db is open.

      Is there any other way?

      thanks