Resizing / Recreating Online Redo Log Files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Resizing / Recreating Online Redo Log Files

  1. #1
    Join Date
    Mar 2006
    Posts
    174

    Resizing / Recreating Online Redo Log Files

    Hi All,

    I have RAC DB running with DG and I need to resize my redo logs files, below are the steps I am thinking:

    1. switch the log file couple times and be sure the log group I want to drop is INACTIVE.
    2. Drop the INACTIVE log group.
    3. create new log group with bigger size.
    4. Repeat step 1-3 for the rest log group.


    Does it sound right? Also, I have Dataguard and I am on 10G, I wonder what I need to do for the DG DB? Anything I have to watch out?

    Thanks,

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    It looks like a plan to me provided storage is not ASM.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Mar 2006
    Posts
    174
    I am using ASM and OFM.

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by matthew00 View Post
    I am using ASM and OFM.
    Please check the document next, just in case http://kb.dbatoolz.com/tp/3374.how_t...p_members.html
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Mar 2006
    Posts
    174
    thanks for your time and response. I am using OFM so what is the format/command to add rego log on OFM?

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