Take the 2-minute tour ×
Server Fault is a question and answer site for professional 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?

This is urgent and even though I'm currently googling for an answer I have yet to find it.

Thanks in advance.

share|improve this question
add comment

1 Answer

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

http://www.stanford.edu/dept/itss/docs/oracle/10gR2/backup.102/b14191/osrecov009.htm

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
add comment

Your Answer

 
discard

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.