Search

OakieTags

Who's online

There are currently 0 users and 33 guests online.

Recent comments

Affiliations

RAC One Changes in 11.2.0.2 Patchset

Oracle patchsets used to be simple - they were bugfixes only; no additional functionalities were added. Oracle added stuff quietly in 10.2.0.4 patchset (the workload capture); but that was part of a new functionality anyway.


The 11.2.0.2 patchset changed all the rules. Several new functionalities were added to the patchsets. Several functionalities have been added to RACOne. Unfortunately they didn't make it to the manuals. Some of them I discovered only recently. If you have been using RACOne, or considering it, you will be delighted to know these.


(1) Bye Bye Patch - In 11.2.0.1 RACOne was supported; but you had to apply a patch #2a2a2a;">#2a2a2a; line-height: 16px;">9004119#2a2a2a; line-height: 16px;"> . Well, it was confusing at the best. A favorite interview question on RACOne fo rmany way this patch. It's gone; 11.2.0.2 already has the patch.


(2) OMotion - remember the OMotion tool used for relocating the database instance? It was probably modeled after the functionality of VMotion in VMWare; hence the namesake. However, it was completely redundant. The clusterware has the functionality anyway; and RACOne has the clusterware; so I never understood the need for OMotion.


In 11.2.0.2, it's gone. To relocate database instance from one server to another, you simply issue srvctl relocate command.


$ srvctl relocate database -d DBNAME -n


(3) Creation - no need to create the RACOne using raconeinit script. DBCA can create it. Oracle Installer can install RACOne as well.


(4) Status - Earlier you had to use raconestatus command to know the status of the RACOne database. This is no longer needed. You can use srvctl status or crsctl status commands.


(5) Upgrades - upgrading RACOne? DB Ugrade Assistant is aware of RACOne as well.


(6) Conversion - Converting a database to RACOne? SRVCTL comes to rescue:


$ srvctl convert database -d ....


(7) Data Guard will work on RACOne as well.