SQL> alter system switch logfile
  2  /
alter system switch logfile
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


SQL> select group#,members,status from V$log;
select group#,members,status from V$log
*
ERROR at line 1:
ORA-03114: not connected to ORACLE


SQL> select group#,members,status from V$logfile;
select group#,members,status from V$logfile
*
ERROR at line 1:
ORA-03114: not connected to ORACLE


SQL> conn sys/shah as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area   59535032 bytes
Fixed Size                   282296 bytes
Variable Size              54525952 bytes
Database Buffers            4194304 bytes
Redo Buffers                 532480 bytes
Database mounted.
ORA-00313: open failed for members of log group 4 of thread 1
ORA-00312: online log 4 thread 1: 'N:\ORACLE\ORA90\DBS\REDO4.ABC'


SQL> select group#,members,status from V$logfile;
select group#,members,status from V$logfile
              *
ERROR at line 1:
ORA-00904: invalid column name


SQL> select member,status from V$logfile;

MEMBER
------------------------------------------------
STATUS
-------
N:\ORACLE\ORA90\DBS\DATAFILE\REDOLOG_1.LOG
STALE

N:\ORACLE\ORA90\DBS\DATAFILE\REDOLOG_2.LOG


N:\ORACLE\ORA90\DBS\REDO4.ABC



SQL> select group#,members,status from V$log;

    GROUP#    MEMBERS STATUS
---------- ---------- ----------------
         1          1 INVALIDATED
         2          1 INACTIVE
         4          1 UNUSED

SQL>
SQL> shutdown
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area   59535032 bytes
Fixed Size                   282296 bytes
Variable Size              54525952 bytes
Database Buffers            4194304 bytes
Redo Buffers                 532480 bytes
Database mounted.
Database opened.