Online upgradation of ASM version in RAC Environment / roll migration of asm in Oracle

Clustered ASM instances for 11g onwards can be upgraded using a rolling upgrade. 

ALTER SYSTEM START ROLLING MIGRATION TO number;

 

I want to upgrade the asm version from 11.1.0.7 to 11.2.0.0

Alter system start rolling migration to 11.2.0.0.0;

 

Ones node rolling migration is enabled you can be shutdown, upgraded and started.

Do not perform following operation when asm is in rolling migration mode:

  • Mount and dismount of the disk groups.
  • Open, close, resize, and delete of database files.
  • Access to local fixed views and fixed packages.

The current status of the ASM cluster can be determined using the following query.

select sys_context(‘sys_cluster_properties’,’cluster_state’) from dual;

 

After upgradation on all nodes. you can stop the rolling migration

ALTER sYSTEM STOP ROLLING MIGRATION;

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s