Redo Log Group, members on a separate disk
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Redo Log Group, members on a separate disk

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Redo Log Group, members on a separate disk

    Hi all,

    Happy New Year to all.

    We have two Redo log groups having 3 members each. But, since the begining, all members of a particular log group are on the same disk. Oracle recommends to have members of the same group on a separate disk so that in case a particular disk fails, we do not loose all members and there is no need to do database recovery.

    Now, pl. tell me what is the procedure for relocating the members on separate disks.

    Thanks in Adv.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    creating new ones and dropping old ones

  3. #3
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109
    HI,

    1. Backup the Database ( For Security Reason)

    2. Using operating system method copy the online redolog files to
    the new location

    3. Alter database rename file (from) to (destination)

    4. Backup the ControlFile

    Seelan

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    thats gonna take a whole lot longer than creating new ones and dropping old ones.

    Why make work for yourself?

  5. #5
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Originally posted by davey23uk
    thats gonna take a whole lot longer than creating new ones and dropping old ones.
    Davey23uk,

    Do I need to open the database in Restricted mode to do this or I can do it online?

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  6. #6
    Join Date
    May 2002
    Posts
    2,645
    Originally posted by seelan
    HI,

    1. Backup the Database ( For Security Reason)

    2. Using operating system method copy the online redolog files to
    the new location

    3. Alter database rename file (from) to (destination)

    4. Backup the ControlFile

    Seelan
    Does the word "fuzzy" have any meaning for you?

  7. #7
    Join Date
    May 2002
    Posts
    2,645

    Re: Redo Log Group, members on a separate disk

    Originally posted by samdba
    Hi all,

    Happy New Year to all.

    We have two Redo log groups having 3 members each. But, since the begining, all members of a particular log group are on the same disk. Oracle recommends to have members of the same group on a separate disk so that in case a particular disk fails, we do not loose all members and there is no need to do database recovery.

    Now, pl. tell me what is the procedure for relocating the members on separate disks.

    Thanks in Adv.
    Great question to research on your own given that you've stated you want to get certified.

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Davey23uk,

    Do I need to open the database in Restricted mode to do this or I can do it online?

    Thanks,
    No you can do it online, which is good.

    I will leave it to you to work out how its done

  9. #9
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by seelan
    HI,

    1. Backup the Database ( For Security Reason)

    2. Using operating system method copy the online redolog files to
    the new location

    3. Alter database rename file (from) to (destination)

    4. Backup the ControlFile

    Seelan
    Really ? :-)
    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