Redo log files are not multiplexed in our database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would execute to proceed further?
Oracle 10g Administration
backuporacleoracle-10g
Related Question
- Do oracle redo logs need to be copied when all other data is copied to a new disks
- Archiver stuck after set log_archive_dest_2 to fast recovery area oracle
- How to recover the data from Redo Log Group which has not been archived yet
- Oracle: dbms_repair outputs zero errors about known corrupted object
- Oracle Recovery – Why Uncommitted Blocks Are Created During Instance Recovery
- Oracle: Database writers idle until ‘Checkpoint not complete’ even with multiple redo logs
- Oracle – Database Corruption After Instance Crash: Is It Possible?
- Oracle 12c – Logically There Is A Redo Group But Not Physically – Database Can’t Open
Best Answer
If you are sure that you did not lose any data and the problem is only at redolog level you can issue (as sysdba):
backup all the datafiles, control files and online redo log before issuing the command so you can "rollback" if something goes wrong.