首先oracle 的redo 日志 最少是两组日志,因为oracle 日志是循环覆写的。所以ORACLE 不容许只有一组日志,
下面我们删除我的日志
首先我查看一下我的日志数量
select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ------------------------- ---
3 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo03.log
2 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo02.log
1 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo01.log
下面我们删除我的日志
首先我查看一下我的日志数量
select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ------------------------- ---
3 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo03.log
2 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo02.log
1 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo01.log
查看一下它们的状态
SYS@ENMOEDU> select GROUP#,STATUS from v$log;
GROUP# STATUS
---------- ----------------
1 CURRENT
2 INACTIVE
3 INACTIVE
首先我们删除我们的日志组 2 。
SYS@ENMOEDU> alter database drop logfile group 2;
Database altered.
SYS@ENMOEDU> select GROUP#,STATUS from v$log;
GROUP# STATUS
---------- ----------------
1 CURRENT
2 INACTIVE
3 INACTIVE
首先我们删除我们的日志组 2 。
SYS@ENMOEDU> alter database drop logfile group 2;
Database altered.
查询日志数量SYS@ENMOEDU> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ------------------------- ---
3 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo03.log
1 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo01.log
我们接着删除我们的 日志组3
SYS@ENMOEDU> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-01567: dropping log 3 would leave less than 2 log files for instance
ENMOEDU (thread 1)
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/ENMOEDU/redo03.log'
此时数据库报错
由此说明我们的数据库日志 最少是两组
GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- ------------------------- ---
3 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo03.log
1 ONLINE /u01/app/oracle/oradata/E NO
NMOEDU/redo01.log
我们接着删除我们的 日志组3
SYS@ENMOEDU> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-01567: dropping log 3 would leave less than 2 log files for instance
ENMOEDU (thread 1)
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/ENMOEDU/redo03.log'
此时数据库报错
由此说明我们的数据库日志 最少是两组
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30176559/viewspace-1668495/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30176559/viewspace-1668495/