Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
September | 2010 | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

11g Active Standby Database Automatic Block Corruption Repair

  • Posted by Gavin Soorma
  • On September 28, 2010
  • 0 Comments
In addition to the real time query capability of the 11g Active Data Guard feature, we can also add to our high availability capability by using the Automatic Block Media Repair feature whereby data block corruptions on the Primary database can be repaired by obtaining those blocks from the standby site – all performed by […]
Read More
 

11g Active Data Guard – enabling Real-Time Query

  • Posted by Gavin Soorma
  • On September 23, 2010
  • 1 Comments
Active Data Guard is a good new feature in 11g (although requires a license) which enables us to query the Standby database while redo logs are being applied to it. In earlier releases, we had to stop the log apply, open the database in read only mode and then start the log apply again when […]
Read More
 

10g Agent mass deployment using the clone method.

  • Posted by Gavin Soorma
  • On September 21, 2010
  • 0 Comments
The oracle 10g management agent needs to be installed on all the remote services which we wish to monitor and administer using the Enterprise Manager Grid Control product. If we are faced with deploying the agent on hundreds of servers which is very likely in case of large organizations, we need to be able to […]
Read More
 

Downgrading a failed 11g Upgrade – the easy way

  • Posted by Gavin Soorma
  • On September 17, 2010
  • 1 Comments
One of the best practices before performing any database upgrade is to take a full backup before we start the upgrade process just in case the upgrade fails and we want to then restore the previous version. In many cases owing to the size of the database, we are constrained both by time as well […]
Read More
 

Cloning 10g Application Server Middle Tier

  • Posted by Gavin Soorma
  • On September 14, 2010
  • 2 Comments
Recently at one on my client sites, there was a requirement to create an additional 10g Discoverer instance of an Oracle Application Server. Rather than attempt a fresh installation as a number of patches had been applied to this Oracle Home, I decided to perform an Oracle Application Server clone instead. Here are the steps […]
Read More
 

11g RMAN Duplicate from Active Database and ORA-01017

  • Posted by Gavin Soorma
  • On September 8, 2010
  • 0 Comments
Recently while performing an 11g Release 2 Active Database duplication, I encountered an error which one would normally associate with password files and the fact that the SYS password is not the same on the source and target databases. RMAN-03002: failure of Duplicate Db command at 09/01/2010 09:17:39 RMAN-03015: error occurred in stored script Memory […]
Read More
 

Purging trace and dump files with 11g ADRCI

  • Posted by Gavin Soorma
  • On September 2, 2010
  • 3 Comments
In previous versions of Oracle prior to 11g, we had to use our own housekeeping scripts to purge the udump, cdump and bdump directories. In Oracle 11g, we now have the ADR (Automatic Diagnostic Repository) which is defined by the diagnostic_dest parameter. So how are unwanted trace and core dump files cleaned out in 11g […]
Read More