- 论坛徽章:
- 0
|
一不小心删除了一个RDO日志文件,数据库启不起来了!!!!!!
*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 |
|