Results 1 to 5 of 5

Thread: Redo log files

  1. #1
    Join Date
    Jun 2003
    Posts
    45

    Unanswered: Redo log files

    Hi all,

    I have mirrored my redolog files to 2 diskw.system Administrator has deleted mirrored files on second disk.So in the alert log file i ot the eroor message.So can i need to recreate the entire group?

    Regards
    sudheer

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    From Oracle9i documentation ...

    "drop the damaged member and add a new member by using the following procedure:

    1. Locate the filename of the damaged member in V$LOGFILE. The status is INVALID if the file is inaccessible:

    SELECT GROUP#, STATUS, MEMBER
    FROM V$LOGFILE
    WHERE STATUS='INVALID';

    2. Drop the damaged member. For example, to drop member log2b.f from group 2, issue:

    ALTER DATABASE DROP LOGFILE MEMBER '/oracle/dbs/log2b.f';

    3. [after you replace the lost disk] Add a new member to the group. For example, to add log2c.f to group 2, issue:
    ALTER DATABASE ADD LOGFILE MEMBER '/oracle/dbs/log2c.f' TO GROUP 2;"
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    copy the good member over to the mirror destination.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273

    Re: Redo log files

    Originally posted by sudheer_ics
    Hi all,

    ...So in the alert log file i ot the eroor message.So can i need to recreate the entire group?

    Regards
    sudheer
    No, You do not need to create the entire group instead you do the following.

    ALTER DATABSE ADD LOGFILE MEMBER
    '/your/mirrered/disk' TO GROUP x;

    where x is your Group Number.You can get it from v$logfile view.

    Hi the_Duck,

    I guess simply copying the good members to the mirred disk does not help if the mirrered member was deleted using ALTER DATABASE DROP LOGFILE MEMBER....command.

    HTH
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296

    Re: Redo log files

    Originally posted by Hings
    Hi the_Duck,

    I guess simply copying the good members to the mirred disk does not help if the mirrered member was deleted using ALTER DATABASE DROP LOGFILE MEMBER....command.

    HTH
    Oops!
    I thought he meant someone had gone in and deleted the mirror from the server command line.

    I've recovered from corruption or deletion of a mirror simply by copying
    the original over to the missing file (with the db shut down).

    I thought that is what we were talking about.
    Sorry for the confusion.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •