oracle dataguard ora-01624解决方法
来源:互联网 发布:淘宝衣服在哪里找货源 编辑:程序博客网 时间:2024/06/05 00:32
oracle physical dataguard :
drop logfile 的时候报错:ora-01624,通过查找文档,解决办法如下:
SQL> recover managed standby database cancel;
Media recovery complete.
SQL> alter database drop logfile '/u01/oradata/demo/redo07.log';
alter database drop logfile '/u01/oradata/demo/redo07.log'
*
ERROR at line 1:
ORA-01624: log 7 needed for crash recovery of instance demo (thread 1)
ORA-00312: online log 7 thread 1: '/u01/oradata/demo/redo07.log'
/////////////////////////////////////////////////////////////////////////////////////////////////////////////
主库:
SQL> select group#,member from v$logfile;
GROUP# MEMBER
---------- ---------------------------------------------
3 /u01/oradata/demo/redo03.log
2 /u01/oradata/demo/redo02.log
1 /u01/oradata/demo/redo01.log
4 /u01/oradata/demo/redo04.log
5 /u01/oradata/demo/redo05.log
6 /u01/oradata/demo/redo06.log
7 /u01/oradata/demo/redo07.log
7 rows selected.
SQL> select group#,status from V$log;
GROUP# STATUS
---------- ----------------
1 CURRENT
2 INACTIVE
3 INACTIVE
7 INACTIVE (确保即将删除的这个logfile不是current redo logfile,并且保证log状态是INACTIVE,如果不是,请checkpoint一下!!!)
从库:
SQL> alter system set standby_file_management=auto;
System altered.
SQL> recover managed standby database disconnect;
Media recovery complete.
SQL> select group#,member,type from v$logfile;
GROUP# MEMBER TYPE
---------- --------------------------------------------- -------
3 /u01/oradata/demo/redo03.log ONLINE
2 /u01/oradata/demo/redo02.log ONLINE
1 /u01/oradata/demo/redo01.log ONLINE
4 /u01/oradata/demo/redo04.log STANDBY
5 /u01/oradata/demo/redo05.log STANDBY
6 /u01/oradata/demo/redo06.log STANDBY
7 /u01/oradata/demo/redo07.log ONLINE
7 rows selected.
SQL> alter system set standby_file_management=manual;
System altered.
SQL> recover managed standby database cancel;
Media recovery complete.
主库:
SQL> alter database drop logfile '/u01/oradata/demo/redo07.log';
Database altered.
SQL> select group#,member from v$logfile;
GROUP# MEMBER
---------- ---------------------------------------------
3 /u01/oradata/demo/redo03.log
2 /u01/oradata/demo/redo02.log
1 /u01/oradata/demo/redo01.log
4 /u01/oradata/demo/redo04.log
5 /u01/oradata/demo/redo05.log
6 /u01/oradata/demo/redo06.log
6 rows selected.
从库:
SQL> alter database drop logfile '/u01/oradata/demo/redo07.log';
alter database drop logfile '/u01/oradata/demo/redo07.log'
*
ERROR at line 1:
ORA-01624: log 7 needed for crash recovery of instance demo (thread 1)
ORA-00312: online log 7 thread 1: '/u01/oradata/demo/redo07.log'
SQL> alter system checkpoint;
alter system checkpoint
*
ERROR at line 1:
ORA-01109: database not open
SQL> select group#,status from V$log;
GROUP# STATUS
---------- ----------------
1 CLEARING_CURRENT
7 CLEARING
3 CLEARING
2 CLEARING
SQL> alter database drop logfile '/u01/oradata/demo/redo07.log';
alter database drop logfile '/u01/oradata/demo/redo07.log'
*
ERROR at line 1:
ORA-01624: log 7 needed for crash recovery of instance demo (thread 1)
ORA-00312: online log 7 thread 1: '/u01/oradata/demo/redo07.log'
SQL> select group#,member from v$logfile;
GROUP# MEMBER
---------- ---------------------------------------------
3 /u01/oradata/demo/redo03.log
2 /u01/oradata/demo/redo02.log
1 /u01/oradata/demo/redo01.log
4 /u01/oradata/demo/redo04.log
5 /u01/oradata/demo/redo05.log
6 /u01/oradata/demo/redo06.log
7 /u01/oradata/demo/redo07.log
7 rows selected.
SQL> alter database clear logfile group 7;
Database altered.
SQL> alter database drop logfile '/u01/oradata/demo/redo07.log';
Database altered.
SQL> select group#,member from v$logfile;
GROUP# MEMBER
---------- ---------------------------------------------
3 /u01/oradata/demo/redo03.log
2 /u01/oradata/demo/redo02.log
1 /u01/oradata/demo/redo01.log
4 /u01/oradata/demo/redo04.log
5 /u01/oradata/demo/redo05.log
6 /u01/oradata/demo/redo06.log
6 rows selected.
SQL> alter system set standby_file_management=auto;
System altered.
SQL> recover managed standby database disconnect;
Media recovery complete.
主库:
SQL> alter system switch logfile;
System altered.
SQL> select name,standby_dest,applied from v$archived_log;
NAME STA APP
-------------------------------------------------- --- ---
/u01/oradata/log/1_3_714156559.dbf NO NO
/u01/oradata/log/1_4_714156559.dbf NO NO
/u01/oradata/log/1_5_714156559.dbf NO NO
...
NAME STA APP
-------------------------------------------------- --- ---
/u01/oradata/log/1_54_714156559.dbf NO NO
10gstandby YES YES
/u01/oradata/log/1_55_714156559.dbf NO NO
10gstandby YES NO
/u01/oradata/log/1_56_714156559.dbf NO NO
10gstandby YES NO
xxx rows selected.
SQL>
从库:
SQL> select name,standby_dest,applied from v$archived_log;
NAME STA APP
-------------------------------------------------- --- ---
....
/u01/oradata/log/1_51_714156559.dbf NO YES
/u01/oradata/log/1_52_714156559.dbf NO YES
/u01/oradata/log/1_53_714156559.dbf NO YES
/u01/oradata/log/1_54_714156559.dbf NO YES
/u01/oradata/log/1_55_714156559.dbf NO YES
/u01/oradata/log/1_56_714156559.dbf NO YES
21 rows selected.
SQL>
恢复正常!
参考:
1.ASKTOM:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:55812348055
2.Metalink:Note:395146.1(未查,没有metalink账号)
- oracle dataguard ora-01624解决方法
- Oracle DataGuard ora-16198
- DataGuard - ORA-00261错误及解决方法
- oracle 11g dataguard 出现ORA-16143: 终端恢复过程中或之后不允许进行 RFS 连接解决方法
- ORACLE:ORA-12560解决方法
- Oracle ora-01555解决方法
- Oracle 11G DataGuard ORA-16086问题修复详细过程
- oracle 10g dataguard修改保护模式遭遇ORA-03113
- Oracle Study之--DataGuard 最大保护模式故障(ORA-16198)
- Oracle---dataguard
- Oracle ORA-32700 错误解决方法
- ORACLE之ORA-27101解决方法
- Oracle ORA-01110错误解决方法
- Oracle ORA-00600 [15764] 解决方法
- Oracle ORA-01045错误解决方法
- Oracle ora-01045错误解决方法
- Oracle ora-01045错误解决方法
- ORACLE-ORA-01795的解决方法
- .net中 参数out,ref,params的区别.
- HTML常用代码(编个人主页用)
- 欢迎您来到谷歌搜索在中国的新家
- 强签名的由来和作用
- 2010-03-23
- oracle dataguard ora-01624解决方法
- Windows下Critical Section、Event、Mutex、Semaphores区别
- sh_upd_stnfo onsa 站出问题---bob King 给出解决方法
- 为什么刚开机就出现非法boot.ini正从Windows启动
- QT的事件机制
- Http协议的无状态性
- I still remember I love you...
- svn
- 刘翔博客答即时通信公司网友提问