very aurgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: very aurgent

Hybrid View

  1. #1
    Join Date
    Mar 2002
    Posts
    16

    Angry

    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

  2. #2
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    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
  •  


Click Here to Expand Forum to Full Width