-
Hi,
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.
Regards,
Ganesh.G.
Ganesh.G
-
recover
Hi,
You can change
CREATE CONTROLFILE REUSE DATABASE "BLABLA" NORESETLOGS NOARCHIVELOG
to
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)
HTH
Tycho
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|