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

Oracle 19c Grid Infrastructure Upgrade

  • Posted by Gavin Soorma
  • On June 21, 2019
  • 1 Comments
This note describes the process used to upgrade a two-node Oracle 12c Release 2 Grid Infrastructure environment to Oracle 19c on Linux OEL7. The upgrade from 12c to 19c is performed in a rolling fashion using batches which will limit the application downtime. Create the directory structure for Oracle 19c Grid Infrastructure and unzip the […]
Read More
 

Oracle Exadata X5-2 Data Guard Configuration

  • Posted by Gavin Soorma
  • On November 1, 2016
  • 0 Comments
This note describes the procedure of creating an Oracle 11.2.0.4 Data Guard Physical Standby database with a two-node Real Application Cluster (RAC) Primary and Standby database on an Oracle Exadata X5-2 eight rack. The procedure will use RMAN for the creation of the Physical Standby database and will use the DUPLICATE FROM ACTIVE DATABASE method […]
Read More
 2

Performing a database clone using a Data Guard Snapshot Database

  • Posted by Gavin Soorma
  • On January 28, 2015
  • 1 Comments
Some times we need to have an exact replica of the production database data to urgently test an issue encountered in production. If the production database is very large having a clone process running on the production server or taking a fresh full database backup just for the clone is also not desirable as well […]
Read More
 

Minimal Downtime Cross Platform Migration and 12c Database Upgrade using Data Guard

  • Posted by Gavin Soorma
  • On January 27, 2015
  • 0 Comments
This note describes the procedure used to perform a minimal downtime platform migration from Windows to Linux as well as a database upgrade from Oracle 11.2.0.4 to Oracle 12c (12.1.0.2). We create a Data Guard physical standby database using the DUPLICATE FROM ACTIVE DATABASE feature, followed by a switchover and then we activate the standby […]
Read More
 

Minimal downtime database upgrade from Oracle 10g to Oracle 12c

  • Posted by Gavin Soorma
  • On December 8, 2014
  • 0 Comments
This note describes the procedure of migrating as well as upgrading an Oracle 10g Release 2 database to Oracle 12c (12.1.0.2) using a combination of RMAN Incremental backups and the new Oracle 12c command line parallel upgrade utility. This method minimises the outage required for the migration as well as database upgrade and the outage […]
Read More
 3

Creating an Oracle 12c Data Guard Active Standby Database

  • Posted by Gavin Soorma
  • On November 19, 2013
  • 1 Comments
This note examines how to create an Oracle 12.1.0 physical standby Active Data Guard database using the RMAN DUPLICATE FROM ACTIVE command. We will be creating the data guard configuration in a 12c Container Database. Remember – in 12c Data Guard is set up at the Container level and not the individual Pluggable database level […]
Read More
 1

Minimal downtime rolling database upgrade to 12c Release 1

  • Posted by Gavin Soorma
  • On August 2, 2013
  • 0 Comments
This note describes the procedure used to perform a rolling database upgrade from 11.2.0.3 to Oracle 12c Release 1 using a Data Guard physical standby database and transient logical standby database. The average time to perform a database upgrade would be in the region of one to two hours and for many organizations even that […]
Read More
 1

11g Data Guard Cascading Standby Database

  • Posted by Gavin Soorma
  • On May 8, 2013
  • 2 Comments
This note describes the procedure used to setup and configure a Data Guard Cascaded Standby database environment. The cascading standby database receives redo from the Primary database and then this redo is cascaded to one or more cascaded standby databases. So the cascaded  standby database does not receive its redo directly from the Primary database […]
Read More
 

Performing a database clone using a Data Guard physical standby database

  • Posted by Gavin Soorma
  • On April 19, 2012
  • 3 Comments
A common DBA task is to perform regular clones and database refreshes of the production database for the purpose of setting up training or test or development environments. If we are having a physical standby Data Guard environment, then we can easily offload the potentially I/O and CPU intensive backup process required for creating these […]
Read More
 

Oracle 11g Cross Platform Active Standby – Windows Primary database and Linux Active Standby

  • Posted by Gavin Soorma
  • On November 8, 2011
  • 0 Comments
This note describes the procedure of configuring a cross platform using the 11g RMAN Active Duplicate as well as an Active Standby Database setup over a Windows and Linux platform. The Metalink note Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration [ID 413484.1] describes the supported cross platform combinations […]
Read More
 

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
 

EM Grid Control and High Availability

  • Posted by Gavin Soorma
  • On April 12, 2010
  • 0 Comments
A question often asked is can we use Oracle Data Guard as a high availibility option for the EM Grid Control Repository database. The repository database contains information on all the targets, the jobs configured, alerts and notification history etc. It has a lot of very valuable information and can be deemed as a fairly […]
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