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.



32 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...

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

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...

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...

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...

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...

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

Anonymous said...

buy tramadol tramadol addiction treatment program - tramadol withdrawal vomiting

Anonymous said...

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

Anonymous said...

generic ativan online ativan effects - order ativan canada

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...

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...

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

yanmaneee said...

yeezy boost
nike kd 11
michael kors outlet online
yeezy shoes
jordan shoes
off white
balenciaga shoes
michael kors outlet online
hermes belt
canada goose