求助：redo log文件损坏 如何恢复?

tyro_it

   数据库有一个redo log文件损坏,而且没有备份,请各位大虾拯救我吧!

老邱

*Loss of online redo:
   o Current
       o When database closed normally :
           RECOVER DATABASE UNTIL CANCEL; / CANCEL
           ALTER DATABASE OPEN RESETLOGS;  (Open resetlogs recreates log files)

       o When database was shutdown abnormally :
           o restore backup and point in time recovery
             (eg RECOVER DATABASE UNTIL CANCEL and cancel when prev log applied)
           
           o No backup: _allow_resetlogs_corruption
                        RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL
                        *Rebuild essential*
                        ALTER DATABASE OPEN RESETLOGS;
   o Non-Current
       o Add member, drop member