I lost all control files, 2 online redo log files out of 3. I do have all data files backup including system tablespace, archive logs.
I can create control files but I have only one on line redo log file. But unless I have all redo log files I can not restore database.
I tryed to recreate control file by omiting redolog2,redolog3.
But I got error message saying that Database need at least 2 redo log files.
Please some one advice to restore database at this situation.
You can change
CREATE CONTROLFILE REUSE DATABASE "BLABLA" NORESETLOGS NOARCHIVELOG
CREATE CONTROLFILE REUSE DATABASE "BLABLA" RESETLOGS NOARCHIVELOG
The you don't need redologs but lose all changes made after the last logswitch.
(And open the database with resetlogs)
Click Here to Expand Forum to Full Width