I am confused because I have two answers to the same question.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
Question: After a disk crash I lost some control files and all logfiles (no archive). After restoring the system I would like to copy the good control file to the old ones. What should I do with logfiles to restart without problem?
As the database was in NOARCHIVELOG mode at the time of media failure, you cannot use the current datafiles because they are inconsistent (and cannot be consistent because there are no archive logs). So You CANNOT perform ALTER DATABASE OPEN RESETLOGS.
If you still want to open the database using RESETLOGS option, then follow the steps below (NOARCHIVELOG mode (cold backup)).
The bottom line is that this method is the same as restoring the database from full cold backup (DATA LOST).
Personally, I'd restore everything from a good cold backup. But if you want to use one of the two answers given, then the second answer is correct. When you open the database with RESETLOGS, it will recreate your missing online redo log files.
The moral of this story is to make sure that you have a sound backup and recovery strategy. This example is one of the many recovery scenarios that DBAs practice.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.