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
March | 2010 | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Welcome!

  • Posted by Gavin Soorma
  • On March 29, 2010
  • 1 Comments
Welcome to Oracle DBA Tips and Techniques – a site by a DBA for all the DBA community.  I have just migrated my site to a new host, so still experimenting with themes and appearances.  Please provide your valuable feedback to gavsal@yahoo.com
Read More
 

11g Release 2 Rolling Upgrade using Transient Logical Standby database

  • Posted by Gavin Soorma
  • On March 22, 2010
  • 0 Comments
This note illustrates how we can perform a rolling upgrade from Oracle 11g Release 1 to Oracle 11g Release 2 using a Transient Logical Standby database. This approach will miminise the downtime required for an upgrade which can potentially run into several hours down to just the time required to perform a switchover which could […]
Read More
 2

11g Data Guard Broker DGMGRL Configuration quick steps

  • Posted by Gavin Soorma
  • On March 19, 2010
  • 2 Comments
This note describes the commands used to create a Data Guard broker configuration using the command line dgmgrl interface. This can also be done via the Enterprise Manager Grid Control GUI as well and the assumption is that there is a Physical Standby database in place and redo transport and redo apply have already been […]
Read More
 1

Create Standby Database using 11g DUPLICATE FROM ACTIVE DATABASE

  • Posted by Gavin Soorma
  • On March 17, 2010
  • 2 Comments
Purpose This note explains the procedure of creating a Physical Standby database using 11g RMAN DUPLICATE FROM ACTIVE DATABASE feature which is now available in 11g Release 1 onwards. This enables us to create a physical standby database without having to take a backup of the primary database as a prerequisite step. Environment Primary Database […]
Read More
 

Oracle 11g External Tables to store results of OS commands

  • Posted by Gavin Soorma
  • On March 16, 2010
  • 1 Comments
In Oracle 11g, we can now use external tables to not only display data stored in flat files outside the database, but also store the result of any command executed at the OS level – for example in this case we have a shell script which basically runs the ‘uptime’ command and we then run […]
Read More
 

Oracle GoldenGate Tutorials now available …..

  • Posted by Gavin Soorma
  • On March 8, 2010
  • 10 Comments
GoldenGate Concepts and Architecture Installation on Red Hat Linux with Oracle 11g Configuring the Manager process Performing an initial data load Configuring online change synchronization Configuring the Data Pump process Configuring DDL Synchronization Filtering and Mapping data Monitoring Goldengate Performing a zero downtime cross platform database upgrade Installing the GoldenGate Director and Client Using the […]
Read More