sqlplus /nolog conn / as sysdba select status from v$instance; startup nomount alter database mount; alter database clear unarchived logfile group 1; alter database clear unarchived logfile group 2; alter database clear unarchived logfile group 3; alter database clear unarchived logfile group 4; shutdown immediate; startup; select status from v$instance;