-
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,
-
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.
-
-
Originally Posted by matthew00
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|