SQL> col member for a55
SQL> select * from v$logfile;
GROUP# STATUSTYPE
---------- ------- -------
MEMBER
IS_
------------------------------------------------------- ---
3 ONLINE
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOGNO
2 STALE ONLINE
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOGNO
1 STALE ONLINE
C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOGNO
SQL> alter database drop logfile group 1;
数据库已更改。
SQL> select group#,sequence#,members,bytes,status,archived from v$log;
GROUP#SEQUENCE#MEMBERSBYTES STATUS ARC
---------- ---------- ---------- ---------- ---------------- ---
2 60
1 52428800 INACTIVE NO
3 61
1 52428800 CURRENT
NO
SQL> alter database add logfile
2('c:\disk3\orcl\onlinelog\redo01a.log',
3'c:\disk6\orcl\onlinelog\redo01b.log',
4'c:\disk9\orcl\onlinelog\redo01c.log',
5SIZE 50M;
SIZE 50M
*
第 5 行出现错误:
ORA-02236: 文件名无效
SQL>
几次不能重建group1后我手快写了个shutdown,到现在还没关好。。
会不会崩溃掉啊
?而且group1已经不存在了,redo1也就剩下操作系统文件了,该怎么办?请各位大侠指点一二~~谢谢!!
|