In Oracle 11gR2, there is a good new feature whereby we can backup the fast or flash recovery area to a disk location which could be a remote destination via a NFS attached file system. In earlier releases, we could only backup the Flash Recovery Area to tape and not disk via RMAN. Recovery […]
The 11g Data Recovery Advisor is part of the 11g database health checking framework and diagnoses persistent data failures and not only presents options to repair and fix the problem but also can execute the repair and recovery process at our request. The Repair Advisor can take away lot of the stress associated with peforming […]
Here are some notes I have prepared when I did an upgrade of a 11GR2 Two-Node RAC Grid Infrastructure from 11.2.0.2 to 11.2.0.3 on a Linux 64 bit test environment. The 11.2.0.3 is an out of place upgrade. So we need to install the 11.2.0.3 software in seperate location from the existing 11.2.0.x […]
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 […]
When performing an upgrade to Oracle 11g Release 2, we would need to take into consideration if there are any DST (Daylight Saving Time) implications which could be the vase in case we have application tables using the datatypes TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE. Oracle 11.2.0.2 uses Time Zone version […]
This note describes the procedure of upgrading the 10g ASM to 11g Release 2 ASM on an HP UX 64 bit platform. The procedure of upgrading the ASM in 11g R2 is a bit different to the procedure used to upgrade ASM to 11.1.0.6 or 11.1.0.7. In 11g R2, ASM is now included as part […]
In one of my earlier posts, I had discussed the process of setting up a 11g Standby Database using the DUPLICATE FROM ACTIVE method where we do not use any RMAN backup to create the standby database, but copy the datafiles from an active running database over the network. Let us now have a look […]
I recently passed the 11g Oracle Certified Masters Upgrade Exam and am now an 11g OCM in addition to the 10g OCM. I had to sign a Non Disclosure Agreement (NDA) while taking the exam, so unfortunately I will not be able to divulge too many details about the exam, but would like to share […]
One of the major concerns a DBA has related to performing a database upgrade to Oracle 11g is ‘Are Execution Plans Going To Change Post-Upgrade?’ I am quite sure we would have experienced some queries having different execution plans when we did earlier upgrades to both 9i as well as 10g. This is due to […]
As a large number of the Oracle community would I guess be in the process of upgrading to 11g (Release 2 and its patch is already available), I am including some presentations taken from the 11g Upgrade Workshop which was conducted by Oracle Corp staff members Roy Swonger & Mike Dietrich. The workshop was highly […]
This note details the procedure for upgrading a 10.2.0.2 database running on a Windows 2003 Server platform to an Oracle 11g Release 2 database on the same platform using the Database Upgrade Assistant. Addtional steps are shown in this note which deals with how to perform the upgrade of the Data Guard Physical Standby database […]
Some time back I had posted a few notes on the 11g Grid Control installation and configuration. 11g Grid Control Installation Tips and Solutions 11g Enterprise Manager Grid Control Installation Overview I would like to highlight an extremely good resource on all things related to the 11g Grid Control setup including the WebLogic and Agent […]
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 […]
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 […]
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 […]
This note describes the process of cloning an Oracle Home – in this case we are cloning a 11g Release 2 Oracle Home from source machine linux01 to target machine linux02. On source (linux01) ORACLE_HOME location is : /u01/app/oracle/product/11.2.0/dbhome_1 Go to directory on source machine one level higher and tar the db_home1 directory and all […]
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 […]
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 […]
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 […]
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 […]
