Redo log help!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Redo log help!

  1. #1
    Join Date
    Jul 2000
    Posts
    147

    Redo log help!

    SQL> select group#, thread#, sequence#, status, archived from v$log;

    GROUP# THREAD# SEQUENCE# STATUS ARC
    ---------- ---------- ---------- ---------------- ---
    1 1 61 INACTIVE YES
    2 1 62 INACTIVE YES
    3 1 63 INACTIVE YES
    4 1 64 CURRENT NO
    5 2 36 INACTIVE YES
    6 2 37 CURRENT NO

    6 rows selected.
    Now I try to drop group 5 and 6 but giving me error below..

    SQL> alter database drop logfile group 5;
    alter database drop logfile group 5
    *
    ERROR at line 1:
    ORA-01567: dropping log 5 would leave less than 2 log files in thread 2
    ORA-00312: online log 5 thread 2: '/parh/redo05.log'
    Even I switch the logfiles
    SQL> alter system switch logfile;

    System altered.
    I think it has to do with the THREAD#.

    Any idea how can I drop it?

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    is this RAC - you have two threads, each thread must have more than one group

  3. #3
    Join Date
    Jul 2000
    Posts
    147
    Yes davey23uk, it is RAC. Sorry about not mentioning it. I was multiplexing the logs.
    I did manager to multiplex 1 through 4, but stuck in 5 and 6. Any suggestion would be greatly appreciate it.

  4. #4
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    As you only have two groups for thread 2, you'd need to add another one before you can drop group 5.
    Assistance is Futile...

  5. #5
    Join Date
    Jul 2000
    Posts
    147
    Thank you so much!

    I added LOGFILE THREAD 2 and alll worked fine.

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