3          1         61    2097152          1 YES INACTIVE                649920 15-NOV-05

SQL> alter system switch logfile;
alter system switch logfile
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
SQL> /
alter system switch logfile
*
ERROR at line 1:
ORA-03114: not connected to ORACLE

SQL> conn / as sysdba
Connected to an idle instance.
SQL> /
alter system switch logfile
*
ERROR at line 1:
ORA-01034: ORACLE not available

SQL> conn / as sysdba
Connected to an idle instance.
SQL>

 

启动数据库，报错：
SQL> conn / as sysdba
Connected to an idle instance.
SQL>
SQL> startup
ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
ORA-00316: log 1 of thread 1, type 0 in header is not log file
ORA-00312: online log 1 thread 1: '/oracle/oradata/TSMISC02/redo01.log'

IXDBA.NET技术社区
SQL> select name,OPEN_MODE from  v$database;

NAME      OPEN_MODE
--------- ----------
TSMISC02  MOUNTED

SQL> select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION           STARTUP_T STATUS       PAR    THREAD# ARCHIVE LOG_SWITCH_
----------------- --------- ------------ --- ---------- ------- -----------
LOGINS     SHU DATABASE_STATUS   INSTANCE_ROLE      ACTIVE_ST
---------- --- ----------------- ------------------ ---------
1 TSMISC02
ts01
9.2.0.4.0         15-NOV-05 MOUNTED      NO           1 STARTED
ALLOWED    NO  ACTIVE            PRIMARY_INSTANCE   NORMAL

SQL> set linesize 132

SQL> col member for a100
SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER
---------- ------- -------
         1         ONLINE  /oracle/oradata/TSMISC02/redo01.log
         2         ONLINE  /oracle/oradata/TSMISC02/redo02.log