Re: Resize log files

In <53c161$8q0_at_news.cis.okstate.edu>, wshiang_at_a.cs.okstate.edu (WANG SHIANG HUEY) writes:
>SQLDBA> ALTER DATABASE ORACLE DROP LOGFILE 'SYS:ORANW\DATABASE\WGLOG1.ORA';
>ORA-01623: log 2 is current log for thread 1 - cannot drop
>ORA-00312: online log 2 thread 1: 'SYS:ORANW\DATABASE\wglog1.ora'
>SQLDBA> ALTER DATABASE ORACLE DISABLE THREAD 1;
>ORA-01615: thread 1 is mounted - cannot disable
>SQLDBA> SPOOL OFF;
>
>--
>Shiang-Huey Wang
>Leather Center, Inc.
>sherry_at_leathercenter.com
>wshiang_at_a.cs.okstate.edu

Hello,

You need to switch redo logs, issue the command ALTER SYSTEM CHECKPOINT. Bye,
Steve

| any similarity 'tween my opinions and that |
|  of my employers are purely hypothetical   |
|     and should give no cause for alarm     |
 --------------------------------------------