11g ASM rolling upgrade from 11.1.0.6 to 11.1.0.7

Posted by Gavin Soorma
On December 15, 2009
0 Comments

In Oracle 11g, we can now do rolling upgrades of the ASM instanaces in a RAC cluster configuration. In this example shown below, one of the ASM instances is being upgraded to 11.1.0.7 while the other instance is still running on version 11.1.0.6. While the ASM software is being upgraded, client connections to the RAC […]

Posted by Gavin Soorma
On December 10, 2009
0 Comments

The following screenshots are taken from a RAC Clusterware upgrade from 11.1.0.6 to 11.1.0.7 on AIX 64 bit platform. We encountered an issue related to Bug 8925669: ROOT111.SH 0509-150 DEPENDENT MODULE LIBTTSH11.SO COULD NOT BE LOADED. I have provided the workaround we used in this case and which did work for us. The last screen […]

Posted by Gavin Soorma
On December 8, 2009
0 Comments

In my earlier post 11g Standby Database Creation Without Any RMAN Backups I had illustrated how to create a standby database using the 11g Active Duplication feature which enabled us to create a standby database without any backup taken of the primary database. In this case it was a ASM Primary and a non ASM […]

Posted by Gavin Soorma
On December 4, 2009
1 Comments

Quick steps to set up a 11g Standby database with Active Data Guard using the Active Duplication feature available in 11g where we can create a standby database without having to take a backup on the primary database. Datafiles are copied over the network. Primary machine – OATU036 Standby machine – DROU036 Database Name – […]

Posted by Gavin Soorma
On December 3, 2009
0 Comments

We can use the procedure outlined below to clear outstanding warning and critical alerts which are displayed on the EM Grid console home page. Normally these alerts get cleared automatically when the event ot threshold which caused these events in the first place is longer in the ‘critical’ or ‘warning’ state. But there are some […]

Posted by Gavin Soorma
On December 1, 2009
1 Comments

Oracle 11g Release 2 introduced compression algorithm levels which can be used for compressing table data, Data Pump exports and RMAN backups as well. The compression levels are BASIC, LOW, MEDIUM and HIGH and each affords a trade off related to backup througput and the degree of compression afforded. To use this option, we can […]

Posted by Gavin Soorma
On December 1, 2009
0 Comments

In Oracle 11g, we can grant restricted access to the RMAN catalog to some users so that they can only access a limited set of databases that are registered in the RMAN catalog. This is done by creating a Virtual Private Catalog which in turn will grant a particular user read/write access to only that […]

News

11g ASM rolling upgrade from 11.1.0.6 to 11.1.0.7

11.1.0.6 Clusterware upgrade to 11.1.0.7

Duplicate from active database – ASM Primary to ASM Standby

11g Standby database creation without any RMAN backups

How to manually clear EM Grid Control alerts

11g Release 2 RMAN Backup Compression

11g RMAN Virtual Private Catalog