Redo log file
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Redo log file

  1. #1
    Join Date
    Sep 2001
    Location
    Oporto - Portugal
    Posts
    14
    Hi,

    I got this problem:

    I deleted the redo log files of a database by accident i want to know how can i open the database!

    The error message while opening teels me the file does not exist.

    Thanks

    PFMS

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Mount the database, and open the database with resetlog option. The redo log files will be created.

  3. #3
    Join Date
    Sep 2001
    Location
    Oporto - Portugal
    Posts
    14
    sorry;

    Can you tell me the command?

    An example will be helpful

    thanks,
    pfms

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    from svrmgrl or sqplus as sysdba

    startup mount
    alter database open resetlogs

    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  5. #5
    Join Date
    Sep 2001
    Location
    Oporto - Portugal
    Posts
    14
    Iīve tried that and it didnīt worked.
    I receive the message:
    "RESETLOGS option only valid after an incomplete database recovery"

    Now i canīt drop the group or file cause it is linked to a thread.
    Can anybody tell me how i can solve this problem?

    Note: Iīcanīt open the database and cause of that i canīt do an export too;

    Thanks

    PFMS

  6. #6
    Join Date
    Jun 2001
    Posts
    316
    recover database until cancel;

    do this and then
    alter database open resetlogs;

  7. #7
    Join Date
    Sep 2001
    Location
    Oporto - Portugal
    Posts
    14
    now i got the following error after doing :

    recover database until cancel

    ORA-00279: change 513301 generated at 10/19/2001 19:50:43 needed for thread 1
    ORA-00289: suggestion : E:\ORACLE\ORA81\RDBMS\ARC00172.001
    ORA-00280: change 513301 for thread 1 is in sequence #172
    Specify log: {=suggested | filename | AUTO | CANCEL}

    i tried : auto

    then it appears:

    ORA-01194: file 1 needs more recovery to be consistent
    ORA-01110: data file1:
    'E:\ORACLE\ORADATA\db\SYSTEM01.DBF'

    Any suggestion?

    Pfms



  8. #8
    Join Date
    Apr 2001
    Posts
    6
    Try CANCEL while using recovery instead of AUTO. That might work.

  9. #9
    Join Date
    Jan 2002
    Posts
    94
    I got the same problem like described here. Could anybody help on the last step written here? - I need the syntax for this step!
    Thank you in advance,

    chris

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Run
    Code:
    recover database until cancel using backup controlfile;
    in the mount status and then type the name of the current redolog. Then open the database with resetlogs:
    Code:
    alter database open resetlogs;
    This should work.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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