Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from Nov 25 '11 at 14:24

This question came from our site for professional and enthusiast programmers.

If you are sure that you did not lose any data and the problem is only at redolog level you can issue (as sysdba):

alter database open resetlogs;

backup all the datafiles, control files and online redo log before issuing the command so you can "rollback" if something goes wrong.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.