RMAN 11g new feature – Backup Fast Recovery Area (FRA) to Disk

Posted by Gavin Soorma
On August 3, 2012
1 Comments

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 […]

Posted by Gavin Soorma
On July 6, 2012
0 Comments

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 […]

Building a test 11gR2 RAC environment in minutes using Oracle Virtual Machine templates

Posted by Gavin Soorma
On November 30, 2011
0 Comments

This note illustrates how we can set up an Orace 11g Release 2 Real Application Clusters environment for test purposes using the Oracle VM templates which are currently available in under 30 minutes! The templates are available from the Oracle E-Delivery web site and are available in both OEL 32bit Linux as well as 64bit […]

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 […]

Posted by Gavin Soorma
On June 16, 2011
0 Comments

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 […]

Posted by Gavin Soorma
On April 28, 2011
1 Comments

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 […]

Posted by Gavin Soorma
On March 11, 2011
0 Comments

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 […]

Posted by Gavin Soorma
On February 22, 2011
7 Comments

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 […]

Posted by Gavin Soorma
On February 15, 2011
4 Comments

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 […]

Posted by Gavin Soorma
On December 10, 2010
0 Comments

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 […]

Posted by Gavin Soorma
On December 8, 2010
0 Comments

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 […]

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 […]

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 […]

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 […]

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 […]

Posted by Gavin Soorma
On May 28, 2010
0 Comments

In 11g Release 2, we now have to place the Voting Disk and Cluster Registry files on ASM disks and we do not have the option of placing them on OCFS or raw devices as in the case of previous versions. When you run the root.sh script as part of the 11gR2 RAC installation, it […]

ORA-29701 after IP address change and overcoming the SIHA ORA-29787 error on SPFILE creation

Posted by Gavin Soorma
On May 28, 2010
0 Comments

I had recently installed 11g Release 2 Grid Infrastructure for a single instance on a RHEL 5 virtual machine set up using VMware server and after I changed the IP address for one of the NIC’s (eth0) I started getting ORA-29701 errors whenever I issued the crsctl check command as well as when I tried […]

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 […]

11g Release 2 RMAN Backup Compression

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 November 27, 2009
0 Comments

One of the good new features in 11g Release 2 is that it enables us to recover from a case of a dropped tablespace. TSPITR (tablespace point in time recovery) has been around in earlier releases, but we could not recover a dropped tablespace. What 11gR2 does is that it peforms a fully automated RMAN […]

Page 1 of 212

News

RMAN 11g new feature – Backup Fast Recovery Area (FRA) to Disk

Upgrading 11gR2 RAC Grid Infrastructure to 11.2.0.3

Building a test 11gR2 RAC environment in minutes using Oracle Virtual Machine templates

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

Upgrading to 11g Release 2 and DST Updates

Upgrading 10g ASM to 11gR2 ASM

Creating a 11g Data Guard Physical Standby Database using Enterprise Manager Grid Control 10.2.0.5

Passing the 11g Oracle Certified Master (OCM) Exam – some thoughts

Upgrade to 11g and ensure Optimizer Plan Stability using SQL Plan Baselines

11g Upgrade Workshop and some upgrade lessons learnt

Upgrading from 10g to 11g Release 2 with a physical standby database

11g Active Standby Database Automatic Block Corruption Repair

11g Active Data Guard – enabling Real-Time Query

Downgrading a failed 11g Upgrade – the easy way

11g RMAN Duplicate from Active Database and ORA-01017

11gR2 RAC installation and the ORA-15014 error

ORA-29701 after IP address change and overcoming the SIHA ORA-29787 error on SPFILE creation

11g Release 2 Rolling Upgrade using Transient Logical Standby database

11g Release 2 RMAN Backup Compression

11g Release 2 Tablespace Point In Time Recovery – recover from dropped tablespace