首頁 > 資料庫 > mysql教程 > RAC下丢失inactive logfile的恢复

RAC下丢失inactive logfile的恢复

WBOY
發布: 2016-06-07 17:20:49
原創
909 人瀏覽過

(1)手动模拟删除onlinelog状态为inactive。 SQLgt; select * from v$log; SQLgt; alter database open;alter database open*

(1)手动模拟删除onlinelog状态为inactive。

SQL> select * from v$log;

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

检查alert文件:

Errors in file /u01/app/Oracle/admin/RACDB/bdump/racdb1_lgwr_24441.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+RAC_DISK/racdb/onlinelog/group_1.260.795090071'
ORA-17503: ksfdopn:2 Failed to open file +RAC_DISK/racdb/onlinelog/group_1.260.795090071
ORA-15012: ASM file '+RAC_DISK/racdb/onlinelog/group_1.260.795090071' does not exist
ORA-00312: online log 1 thread 1: '+RAC_DISK/racdb/onlinelog/group_1.261.795090069'
ORA-17503: ksfdopn:2 Failed to open file +RAC_DISK/racdb/onlinelog/group_1.261.795090069
ORA-15012: ASM file '+RAC_DISK/racdb/onlinelog/group_1.261.795090069' does not exist
Thu Sep 27 11:08:00 2012
ARC0: STARTING ARCH PROCESSES
Thu Sep 27 11:08:00 2012
Errors in file /u01/app/oracle/admin/RACDB/udump/racdb1_ora_24735.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '+RAC_DISK/racdb/onlinelog/group_1.261.795090069'
ORA-00312: online log 1 thread 1: '+RAC_DISK/racdb/onlinelog/group_1.260.795090071'
报错中显示找不到onlinelog。

(2)由于onlinelog必须存在2个组,,所以先增加新GROUP,再删除丢失的GROUP。

SQL> alter database add logfile thread 1 group 5;

SQL> alter database drop logfile group 1;

SQL> alter database open;

SQL> alter system switch logfile;

linux

相關標籤:
來源:php.cn
本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
最新問題
熱門教學
更多>
最新下載
更多>
網站特效
網站源碼
網站素材
前端模板