Tuesday, January 19, 2010

How to multiplex redo log members and groups on ASM with sqlplus and EM

This post will show you how to add new redo log members and groups when the storage engine is ASM; they will be added using both sqlplus console and Enterprise Manager Console.
The following picture is a screenshot taken from the Enterprise Manager after I finished to configure a default Oracle RAC installation formed by two nodes. As you can see there are four groups with just one redo log member.

From sqlplus console you can see how this redo log groups and redo log member are accessible by both nodes.
If you want to see which redo log member is accessible by one node, simply run the following query:
SQL> select * from v$logfile order by GROUP#;

Otherwise if you want to see which redo log member is accessible by both nodes, run this other query:
SQL> select * from gv$logfile order by INST_ID, GROUP#;


Now we will add a new redo log group from sqlplus console, using the following command:
SQL> ALTER DATABASE ADD LOGFILE THREAD 1 GROUP 5 SIZE 51200K;


As you can see from the EM console the new redo log group is created and magically two redo log members are added to this redo log group. Now let's create another redo log group, the sixth, but using the EM console. Click on the CREATE button on the right.


Complete the group name, the file size and choose to which thread assign this new redo log group. Then click on SHOW SQL button to see what command will be executed.


As you can see the command is the same we executed previously from sqlplus console. Click RETURN button. On the previuos screen you can simply click OK button to execute the command.


Again the EM console will show our new configuration and the new redo log group will be formed by two redo log members.


Now we want to add another redo log member to redo log groups 1, 2, 3 and 4. For 1, 2 and 3 I will add them by sqlplus console; the fourth will be added by EM console.
From sqlplus console I simply used the following commands as you can see from picture. My storage engine is based on ASM (Automatic Storage Management), so the syntax is very easy.
ALTER DATABASE ADD LOGFILE MEMBER '+DATA_RAC3' TO GROUP 1;
ALTER DATABASE ADD LOGFILE MEMBER '+DATA_RAC3' TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER '+DATA_RAC3' TO GROUP 3;


From EM console, select redo log group number 4 and then click EDIT button.


The following screenshot will be showed. To add a new redo log member, click ADD button.


Use default suggestion and the click on CONTINUE.


The following screenshot will be showed. Now select SHOW SQL button to see the command line.


As you can see it's the same we executed by sqlplus console. Click RETURN.



Click APPLY to add the new redo log member to redo log group number 4.


Finally... every redo log group is formed now by two redo log members.



61 comments:

Anonymous said...

very good one.

Anonymous said...

buy tramadol online tramadol 50mg for dogs and humans - tramadol online credit card

Anonymous said...

xanax online xanax drug profile - generic xanax same real xanax

Anonymous said...

buy tramadol online tramadol hcl zydol 50mg - buy tramadol online no prescription cheap

Anonymous said...

generic xanax order brand xanax online no prescription - xanax over the counter

Anonymous said...

xanax online buy xanax brand online - xanax dosage compared valium

Anonymous said...

generic xanax xanax dosage pink pill - xanax dosage effects

Anonymous said...

where to buy tramadol tramadol for dogs with kidney disease - tramadol and xanax

Anonymous said...

buy xanax bars online alprazolam 0 5mg c 30 ems - xanax side effects on fetus

Anonymous said...

buy carisoprodol caridoxen naproxeno carisoprodol side effects - carisoprodol drug facts

Anonymous said...

buy tramadol online tramadol hcl acetaminophen 650 - tramadol dosage 10 lb dog

Anonymous said...

generic xanax xanax dosage 0.5 - generic xanax gg 249

Anonymous said...

buy tramadol online what is tramadol 50 mg street value - buy tramadol generic ultram

Anonymous said...

xanax online get xanax online legally - xanax 2mg 11

Anonymous said...

xanax online xanax drug mechanism - xanax generic g3722

Anonymous said...

no prescription xanax good place buy xanax online - xanax insomnia

Anonymous said...

xanax online buy xanax 2mg bars online - buy xanax online legally cheap

Anonymous said...

carisoprodol 350 mg soma = carisoprodol tablets 350 mg - soma carisoprodol wiki

Anonymous said...

buy tramadol online tramadol order online tramadol 50mg - tramadol overdose nhs

Anonymous said...

tadalafil without prescription cialis reviews - cialis price 10mg

Anonymous said...

buy tramadol online purchase tramadol com - buy tramadol thailand

Anonymous said...

buy cialis cheap online buy cialis online us - buying cialis online forum

Anonymous said...

xanax online xanax dosage not working - xanax withdrawal treatment

Anonymous said...

buy tramadol online tramadol clorhidrato 100mg gotas - day 5 tramadol withdrawal

Anonymous said...

buy cialis online is it safe to buy cialis from usa - cheap cialis in sydney

Anonymous said...

xanax online xanax drug test system - can 2mg of xanax kill you

Anonymous said...

cialis online no prescription canada where to buy real viagra cialis online - cialis bathtubs

Anonymous said...

buy cialis online cialis online-versand - cialis daily use 10mg

Anonymous said...

cialis online cialis 20mg reviews - cialis online no prescription usa

Anonymous said...

generic cialis tadalafil cialis dosage reviews - buy cialis online nz

Anonymous said...

cialis online buy brand cialis online us - cheap cialis 20 mg

Anonymous said...

buy tramadol cod buy tramadol hydrochloride - tramadol addiction long term use

Anonymous said...

http://landvoicelearning.com/#57594 tramadol cause addiction - tramadol hcl xr 100mg

Anonymous said...

buy tramadol online tramadol 50 mg para que sirve - can you buy tramadol online in usa

Anonymous said...

learn how to buy tramdadol buy tramadol online cod only - tramadol for dogs and people the same

Anonymous said...

buy tramadol tramadol addiction treatment program - tramadol withdrawal vomiting

Anonymous said...

http://blog.dawn.com/dblog/buy/#fda tramadol for dogs safe - tramadol 50 mg pain killer

Anonymous said...

buy tramadol buy tramadol for dogs - tramadol injection

Anonymous said...

buy tramadol 100mg tramadol for dogs contraindications - tramadol addiction side effects

Anonymous said...

http://landvoicelearning.com/#57594 tramadol 50mg biogaran - tramadol addiction management

Anonymous said...

http://landvoicelearning.com/#23561 tramadol dosage weight dogs - order tramadol online no prescription

Anonymous said...

buy tramadol buy tramadol cod free - order tramadol no prescription overnight

Anonymous said...

buy tramadol where to buy tramadol forum - where to order tramadol online

Anonymous said...

ways to buy ativan online ativan rx 774 - where to buy lorazepam

Anonymous said...

buy ativan online buy ativan online uk - order lorazepam online no prescription

Anonymous said...

buy tramadol tramadol hcl 50 mg high - tramadol hcl good

Anonymous said...

generic ativan online ativan effects - order ativan canada

Anonymous said...

buy tramadol cheap no prescription tramadol 50 mg for humans - can you order tramadol online legally

Anonymous said...

buy tramadol online buy tramadol online europe - tramadol 50 mg kern pharma

Anonymous said...

http://staam.org/#41652 tramadol make u high - tramadol generic cost

Anonymous said...

http://staam.org/#50589 tramadol online no prescription overnight - buy tramadol online mastercard

Anonymous said...

http://staam.org/#50589 tramadol tylenol high - tramadol hcl 50 mg side effects

Anonymous said...

buy xanax online xanax overdose stories - xanax 1 mg par jour

Anonymous said...

where to buy xanax online no prescription blue round xanax 031 - flexeril xanax drug interactions

Anonymous said...

order tramadol online mastercard buy tramadol with paypal - buy tramadol for dogs

Anonymous said...

buy ambien paypal buy herbal ambien - buy ambien with no prescription

oakleyses said...

oakley sunglasses, prada handbags, oakley sunglasses, longchamp handbags, longchamp handbags, louboutin shoes, louis vuitton handbags, coach factory outlet, tiffany and co, coach purses, louis vuitton outlet, polo ralph lauren outlet, air max, prada outlet, longchamp outlet, oakley sunglasses cheap, ray ban sunglasses, louboutin outlet, michael kors outlet, michael kors outlet, tiffany and co, burberry outlet, christian louboutin shoes, coach outlet store online, jordan shoes, polo ralph lauren outlet, louboutin, kate spade handbags, michael kors outlet, coach outlet, air max, gucci outlet, michael kors outlet, ray ban sunglasses, chanel handbags, michael kors outlet, tory burch outlet, nike free, kate spade outlet, louis vuitton outlet, burberry outlet, louis vuitton outlet stores, louis vuitton, nike shoes, michael kors outlet

oakleyses said...

air max, hollister, true religion outlet, nike blazer, louboutin, ray ban sunglasses, polo ralph lauren, michael kors, true religion jeans, sac guess, sac longchamp, hogan outlet, ralph lauren, vans pas cher, sac louis vuitton, air max pas cher, nike free pas cher, nike free, air max, mulberry, nike roshe run, sac burberry, hollister, vanessa bruno, louis vuitton, lululemon, michael kors pas cher, oakley pas cher, air jordan, ray ban pas cher, new balance pas cher, polo lacoste, converse pas cher, north face, sac louis vuitton, michael kors, sac hermes, nike tn, timberland, louis vuitton uk, longchamp, true religion jeans, nike air max, air force, north face

oakleyses said...

abercrombie and fitch, instyler, ghd, bottega veneta, ugg boots, jimmy choo outlet, soccer shoes, ugg pas cher, herve leger, beats by dre, birkin bag, abercrombie and fitch, north face jackets, soccer jerseys, mont blanc, rolex watches, lululemon outlet, celine handbags, nike roshe run, nike trainers, giuseppe zanotti, hollister, wedding dresses, nike huarache, mcm handbags, vans shoes, chi flat iron, babyliss pro, north face outlet, nike roshe, ugg australia, ugg, marc jacobs, barbour, nfl jerseys, p90x, new balance shoes, asics running shoes, ferragamo shoes, mac cosmetics, insanity workout, uggs outlet, reebok outlet, longchamp, valentino shoes

oakleyses said...

abercrombie and fitch, instyler, ghd, bottega veneta, ugg boots, jimmy choo outlet, soccer shoes, ugg pas cher, herve leger, beats by dre, birkin bag, abercrombie and fitch, north face jackets, soccer jerseys, mont blanc, rolex watches, lululemon outlet, celine handbags, nike roshe run, nike trainers, giuseppe zanotti, hollister, wedding dresses, nike huarache, mcm handbags, vans shoes, chi flat iron, babyliss pro, north face outlet, nike roshe, ugg australia, ugg, marc jacobs, barbour, nfl jerseys, p90x, new balance shoes, asics running shoes, ferragamo shoes, mac cosmetics, insanity workout, uggs outlet, reebok outlet, longchamp, valentino shoes

oakleyses said...

converse, air max, gucci, canada goose, juicy couture outlet, canada goose, wedding dresses, moncler, ralph lauren, lancel, montre homme, moncler, louboutin, oakley, karen millen, vans, coach outlet store online, air max, canada goose jackets, ugg, hollister clothing store, louis vuitton, baseball bats, hollister, rolex watches, juicy couture outlet, iphone 6 cases, canada goose uk, canada goose outlet, ugg, moncler, moncler outlet, timberland boots, hollister, supra shoes, moncler, canada goose, converse shoes, toms shoes, moncler, moncler, canada goose, ugg boots, ray ban, parajumpers, canada goose