ORA-01567错误是在尝试删除在线日志组时遇到的错误,具体含义是在删除某个日志组后,将为实例保留的在线日志文件数量少于所需的最少数量。以下是关于ORA-01567错误的详细解释、可能的原因及解决步骤。 ORA-01567错误的含义 ORA-01567错误表明,如果删除指定的日志组,将会导致某个实例的在线日志文件数量少于两个,这是不被允许的。每个实例
恢复测试数据库时遇到了日志组不让删的情况。因为这个测试数据库是从RAC克隆而来,每个节点都有独立的REDO LOG FILE,变成单实例后,只有节点1的REDO LOG FILE再用,那就把节点2的删掉吧,再删节点2的REDO LOG FILE时,遇到了ORA-01567错误。SQL> select b.thread#,a.group#,a.member,bytes/1024/1024,b.members ...
RAC恢复的单实例数据库删除日志组时遇到ORA-01567 恢复测试数据库时遇到了日志组不让删的情况。 因为这个测试数据库是从RAC克隆而来,每个节点都有独立的REDO LOG FILE,变成单实例后, 只有节点1的REDO LOG FILE再用,那就把节点2的删掉吧,再删节点2的REDO LOG FILE时,遇到了ORA-01567错误。 SQL> select b.thre...
oracle-ORA-01567错误 删除日志4时将在线索1中保留少于两个日志文件
ORA-01567: dropping log 2 would leave less than 2Jan 6, 2016 5:09PM edited Jan 14, 2016 10:10AM 2 commentsAnswered Hi all Any idea of this? i can't put the redo log status from unused to another status GROUP# THREAD# MEMBER ARCHIVED STATUS Size (MB) --- --- --- --- -...
ORA-16014 与 ORA-00312 场景: SQL> alter system archive log current; alter system archive log current * 第 1 行出现错误: ORA-16014: 日志 2 sequence# 34 未归档, 没有可用的目的地 ORA-00312: 联机日志 2 线程 1: '+DATA_DG/orcl/onlinelog/group_2.258.885126161' ORA-00312: 联机日志 2 线...
ORA-01567: dropping log 2 would leave less than 2Jan 6, 2016 5:09PM edited Jan 14, 2016 10:10AM 2 commentsAnswered Hi all Any idea of this? i can't put the redo log status from unused to another status GROUP# THREAD# MEMBER ARCHIVED STATUS Size (MB) --- --- --- --- -...