dropping a redo log file in the mount state
541410Mar 26 2007 — edited Mar 27 2007This 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