Monday, January 11, 2010

Add a controlfile into ASM when original controlfile is stored on ASM

Some days ago I installed Oracle 11gR2 on a RAC formed by two nodes. The default installation on ASM use just a controlfile. So I decided to add another one and the following are the steps I've done.

I'm using of course an spfile for my instance.
From a sqlplus sessions I needed to know where my current controlfile was and then altered the system to add another one. So I typed:
sql> show parameter control_files
sql> alter system set control_files='+DATA_RAC3/rac3/controlfile/current.260.706989187', '+DATA_RAC3' scope=spfile sid='*';

After I needed to put the instance in NOMOUNT mode, so as the oracle user, I typed:
srvctl stop database -d RAC3 -o immediate

From rman I was able to duplicate the controlfile, using the following commands:
$ rman nocatalog
RMAN>connect target
RMAN> restore controlfile from '+DATA_RAC3/rac3/controlfile/current.260.706989187';

After those commands, I put the database in OPEN mode, always from RMAN console:
RMAN> sql 'alter database mount';
RMAN> sql 'alter database open;

From a new sqlplus session I was able to see my new duplicated controlfile:
sql> select name from v$controlfile;

And now the last step. I needed to alter again the system, modifing the control_file parameter with the complete path of the new file:
sql> alter system set control_files='+DATA_RAC3/rac3/controlfile/current.260.706989187', '+DATA_RAC3/rac3/controlfile/current.268.707763013' scope=spfile sid='*';


Anonymous said...

thanks dude..

Manish Nashikkar

bonzer said...

Thank you. That saved me some time

Jeff B said...

Thank you for taking the time to post those instructions Marco!

Anonymous said...

exactly what i was looking for - thanks for posting such an elegant solution to this problem

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

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