Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

In the company I work for we are heavy users of VMware machines. Almost all our projects are developed inside a virtual environment up to the point where we have to deploy them into a production system.

While in development, some colleagues of mine deleted the redo log files for Oracle in the hopes of gaining some free space. Now they are unable to start the database instance. Is there a way of generating a fresh new redo log so that the instance can be started?

share|improve this question

1 Answer 1

There are two types of redo logs, online and archive. You can restart without the archived ones. The online ones are a different matter. You need to use the RESETLOGS option


share|improve this answer
It seems my colleagues tried using the RESETLOGS option but with no luck. Thanks for your help nonetheless. –  Aikanaro Mar 23 '11 at 16:40

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.