在删除redolog的时候遇到以下问题,明明 group 3和5 redo logfile都在使用,但是删除group 4的时候提示少于两组logfile
SQL> select group#,status,bytes/1024/1024 as mb,MEMBERS,ARCHIVED from v$log;
GROUP# STATUS
MBMEMBERS ARC
---------- ---------------- ---------- ---------- ---
3 CURRENT
50
2 NO
4 INACTIVE
50
2 YES
5 CURRENT
200
2 NO
6 INACTIVE
200
2 YES
7 INACTIVE
200
2 YES
8 INACTIVE
200
2 YES
6 rows selected.
SQL>
SQL>
SQL> alter database drop logfile group 4;
alter database drop logfile group 4
*
ERROR at line 1:
ORA-01567: dropping log 4 would leave less than 2 log files for instance
dmgyrac2 (thread 2)
ORA-00312: online log 4 thread 2:
'+DATA/dmgyrac/onlinelog/group_4.270.856892865'
ORA-00312: online log 4 thread 2:
'+DATA/dmgyrac/onlinelog/group_4.271.856892865'
|
