问题解决了,我关掉数据库出去了,然后回来一看就可以了,难道是要重启一下吗?
SQL> conn sys/ as sysdba
输入口令: ****
已连接。
SQL> select group#,sequence#,members,status,bytes,archived from v$log;
GROUP# SEQUENCE# MEMBERS STATUS BYTES ARC
---------- ---------- ---------- ---------------- ---------- ---
1 9 1 INACTIVE 52428800 NO
2 10 3 CURRENT 15728640 NO
3 7 3 INACTIVE 15728640 NO
4 8 3 INACTIVE 15728640 NO
SQL> alter database drop logfile group 1;
数据库已更改。
SQL> select group#,sequence#,members,status,bytes,archived from v$log;
GROUP# SEQUENCE# MEMBERS STATUS BYTES ARC
---------- ---------- ---------- ---------------- ---------- ---
2 10 3 CURRENT 15728640 NO
3 7 3 INACTIVE 15728640 NO
4 8 3 INACTIVE 15728640 NO
SQL> alter database add logfile
2 ('c:\disk3\orcl\onlinelog\redo 01A.log;',
3 'c:\disk6\orcl\onlinelog\redo 01B.log;',
4 'c:\disk9\orcl\onlinelog\redo 01C.log;')
5 size 15M;
数据库已更改。
SQL> select group#,sequence#,members,status,bytes,archived from v$log;
GROUP# SEQUENCE# MEMBERS STATUS BYTES ARC
---------- ---------- ---------- ---------------- ---------- ---
1 0 3 UNUSED 15728640 YES
2 10 3 CURRENT 15728640 NO
3 7 3 INACTIVE 15728640 NO
4 8 3 INACTIVE 15728640 NO
数据库已更改。
心情不好,不纠结这么多,哪天再弄吧
转载于:https://blog.51cto.com/oceanii/846220