>sqlplus /nolog
SQL>connect sys/system as sysdba
已连接
SQL>select group#,sequence#,archived,status from v$log;
SQL>alter database clear logfile group 3;
SQL>alter database datafile "C:\DB\VOLTAGE" OFFLINE DROP;
SQL>ALTER DATABASE OPEN;
本文共 281 字，大约阅读时间需要 1 分钟。
>sqlplus /nolog
SQL>connect sys/system as sysdba
已连接
SQL>select group#,sequence#,archived,status from v$log;
SQL>alter database clear logfile group 3;
SQL>alter database datafile "C:\DB\VOLTAGE" OFFLINE DROP;
SQL>ALTER DATABASE OPEN;
转载于:https://my.oschina.net/u/857610/blog/189962