oracle資料庫日志組成員丢失處理

  日志組成員都丢失的處理

進入 mount狀态 startup force mount   開啟另一視窗，動态監視警報日志 cd $ORACLE_BASE/diag/rdbms/$ORACLE_SID/$ORACLE_SID/trace tailf alert_prod.log   開啟資料庫 alter database open   産生錯誤 ORA-03113: end-of-file on communication channel

警報日志： Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_lgwr_4994.trc: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/prod/redo01.log'   處理方法： 1.删除無用日志組 startup force mount alter database drop logfile group 1 ; 2.重置日志成員資訊 alter database clear logfile group 1;   啟動資料庫 startup