Database Administration (MOSC)

MOSC Banner

How to disable redo log multiplexed member

edited May 21, 2013 9:11AM in Database Administration (MOSC) 5 commentsAnswered
Hello everyone

I am working with oracle 11g 11.2.0.3 and i have my redologs multiplexed like this

1 1  ONLINE +DATA/bdjde/onlinelog/group_1.281.815305363 NO
2 1  ONLINE +FRA/bdjde/onlinelog/group_1.260.815305365 YES
 but the +FRA is located on an array with RAID 5 and i am experiencing high log file sync waits everytime a dml is issued on my database and the recomendation from oracle is that this redologs not to be stored on a storage configured with RAID 5

So i would like to disable the automatic creation of redologs on this second location and have them only created on the DATA diskgroup.

If anyone could explain how i might acomplish this i will appreciate it.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center