ORA-01624: log 3 needed for crash recovery of instance orcl (thread 1)
来源:互联网 发布:网络安全意识 责任心 编辑:程序博客网 时间:2024/06/07 14:51
SQL> select GROUP#, STATUS, TYPE, MEMBER from v$logfile;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
3 ONLINE
/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_3_dyd9t6b2_.log
3 ONLINE
/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/o1_mf_3_dyd9tcwo_.log
2 ONLINE
/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_2_dyd9sokw_.log
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
2 ONLINE
/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/o1_mf_2_dyd9stxc_.log
1 ONLINE
/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_1_dycmddnl_.log
1 ONLINE
/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/o1_mf_1_dycmdlh3_.log
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
4 ONLINE
/data/oracle/onlinelog/REDO04a.LOG
4 ONLINE
/data/oracle/onlinelog/REDO04b.LOG
5 ONLINE
/data/oracle/onlinelog/REDO05a.LOG
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
5 ONLINE
/data/oracle/onlinelog/REDO05b.LOG
6 ONLINE
/data/oracle/onlinelog/REDO06a.LOG
6 ONLINE
/data/oracle/onlinelog/REDO06b.LOG
12 rows selected.
SQL>
SQL> alter database drop logfile group 1;
Database altered.
SQL> alter database drop logfile group 2;
Database altered.
SQL> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-01623: log 3 is current log for instance orcl (thread 1) - cannot drop
ORA-00312: online log 3 thread 1:
'/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_3_dyd9t6b2_.log'
ORA-00312: online log 3 thread 1:
'/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/o1_mf_3_dyd9tcwo_.log'
SQL> select GROUP#,members,BYTES/1024/1024 size_M,STATUS,ARCHIVED from v$log;
GROUP# MEMBERS SIZE_M STATUS ARC
---------- ---------- ---------- ---------------- ---
3 2 500 CURRENT NO
4 2 1024 UNUSED YES
5 2 1024 UNUSED YES
6 2 1024 UNUSED YES
SQL> alter system switch logfile;
System altered.
SQL> select GROUP#,members,BYTES/1024/1024 size_M,STATUS,ARCHIVED from v$log;
GROUP# MEMBERS SIZE_M STATUS ARC
---------- ---------- ---------- ---------------- ---
3 2 500 ACTIVE YES
4 2 1024 CURRENT NO
5 2 1024 UNUSED YES
6 2 1024 UNUSED YES
SQL> alter database drop logfile group 3;
alter database drop logfile group 3
*
ERROR at line 1:
ORA-01624: log 3 needed for crash recovery of instance orcl (thread 1)
ORA-00312: online log 3 thread 1:
'/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_3_dyd9t6b2_.log'
ORA-00312: online log 3 thread 1:
'/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/o1_mf_3_dyd9tcwo_.log'
SQL> alter system checkpoint;
System altered.
SQL> select GROUP#,members,BYTES/1024/1024 size_M,STATUS,ARCHIVED from v$log;
GROUP# MEMBERS SIZE_M STATUS ARC
---------- ---------- ---------- ---------------- ---
3 2 500 INACTIVE YES
4 2 1024 CURRENT NO
5 2 1024 UNUSED YES
6 2 1024 UNUSED YES
SQL> alter database drop logfile group 3;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> select GROUP#,members,BYTES/1024/1024 size_M,STATUS,ARCHIVED from v$log;
GROUP# MEMBERS SIZE_M STATUS ARC
---------- ---------- ---------- ---------------- ---
4 2 1024 ACTIVE YES
5 2 1024 CURRENT NO
6 2 1024 UNUSED YES
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/data/oracle/onlinelog/REDO04a.LOG
/data/oracle/onlinelog/REDO04b.LOG
/data/oracle/onlinelog/REDO05a.LOG
/data/oracle/onlinelog/REDO05b.LOG
/data/oracle/onlinelog/REDO06a.LOG
/data/oracle/onlinelog/REDO06b.LOG
6 rows selected.
- ORA-01624: log 3 needed for crash recovery of instance orcl (thread 1)
- ORA-00600 Recovery of Online Redo Log: Thread 1 Group 2 Seq 128 Reading mem 0 错误特殊恢复
- ORA-27072 instance crash
- Oracle:ORA-00392: log 3 of thread 1 is being cleared, operation not allowed
- ORA-00314: log 2 of thread 1, expected sequence# doesn't ORA-00312: online log 2 thread 1:
- 【ORA-600】[kcratr_nab_less_than_odr] 异常宕机后的实例恢复during Instance Recovery after Database Crash
- 12c dbca CRS-2674: Start of 'ora.orcl.db' on 'rac1' failed ORA-01017: invalid username/password; log
- ORA-00314: log 20 of thread 1, expected sequence# 108055 doesn't match 108053
- Oracle error:Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
- Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
- Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
- Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
- Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
- ORA-600 [KFDAUDEALLOC2] AND INSTANCE CRASH EVEN WITH THE FIX OF BUG 14467061 (文档 ID 1903273.1)
- ORA-00312: 联机日志 2 线程 1:'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'
- ORA-00494: enqueue [CF] held for too long (more than 900 seconds) cause instance crash
- Whether Thread Pool is Needed for You?
- ORA-00313 open failed for members of log group解决办法
- html标签上存静态数据传入js方法中
- Upd建立网络连接
- D3D11 聚光灯
- ue4 c++ 新建一个有输入输出的函数
- Jmeter配置使用Selenium
- ORA-01624: log 3 needed for crash recovery of instance orcl (thread 1)
- SSL2775 2017年10月19日提高组 新壳栈
- NOIP模拟 打牌【贪心】
- rtl8169网卡驱动
- Js/es for(let i in Obj)效率分析及优化
- 九度OJ——1028继续畅通工程
- bzoj3173: [Tjoi2013]最长上升子序列
- ConfigReader(五十九)—— RuneConfig
- jqueryrotate--jQuery旋转插件