By Arup Nanda
Orignally, Oracle patchsets issued by Oracle were simple simple.
They contained bugfixes only. There was no worry that
additional functionalities were being added. But with the 10.2.0.4
patchset, Oracle quietly added the workload capture. Still, that was part of a new
functionality anyway.
With the 11.2.0.2 patchset, all the rules changed. With the
patchset came several new
functionalities. Specifically, several functionalities
have been added to RACOne, but unfortunately they did not make it to the
manuals. I discovered some of them just recently. If you have been
using RACOne, or considering it, you will be delighted to know
these things about the 11.2.0.2 patchset:
- OMotion: The OMotion tool was 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, Omotion is gone.
All that is needed to relocate a database instance from one
server to another is the issuance of the srvctl relocate
command:
$ srvctl relocate database -d DBNAME -n
- Say Goodby to the Patch: In 11.2.0.1 RACOne was supported; but you
had to apply patch - 9004119 . Well, it was confusing at
best. Now, it's gone; 11.2.0.2 already has the patch.
- Status: Prior to this patchset, 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.
- Upgrades: Upgrading RACOne? DB Ugrade Assistant is now aware of RACOne.
- Creation: No need to create the RACOne using
raconeinit script. DBCA can create it. Oracle Installer can
install RACOne as well.
-
Conversion: Converting a database to RACOne? SRVCTL comes
to rescue:
$ srvctl convert
database -d ....
- Data Guard will work on RACOne as well.
|
|
 |
|
Get the Complete
Oracle Tuning Details
The landmark book
"Oracle
Tuning: The Definitive Reference Second Edition" has been
updated with over 1,150 pages of expert performance tuning tips.
It's packed with scripts and tools to hypercharge Oracle 11g
performance and you can
buy it for 40% off directly from the publisher.
|
|
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
| |
| |
Copyright ©
1996 -2011 by Burleson Enterprises. All rights reserved.
Oracle® is the registered trademark of Oracle
Corporation. SQL Server® is the registered trademark of Microsoft
Corporation.
Many of the designations used by computer vendors to distinguish their
products are claimed as Trademarks
|
|
