Yearly Archives: 2015

Home »  2015

Upgrade Oracle Database 11203 to 12102 !!!

in this article we will see the steps to Upgrade Oracle Database 11203 to 12102 on Red Hat Enterprise Linux. ======================================================================================================   Follow the below steps to upgrade Oracle database 11203 to 12102 • Download and Install 12c database software We have to install 12c database binaries in a separate…

Oracle Golden Gate with Source and Target databases in same server !!!

In this article, we will see how to configure Oracle Golden Gate with Source and Target databases in same server. Here, I have a 2 node Oracle 11gR2 RAC cluster with ASM storage on RHEL (64 bit). ======================================================================================================   Here we have 2 databases (orcldb, rcatdb). We will be configuring…

Change RMAN Retention Policy of a Standby Database !!!

On November 9, 2015, Posted by , In ORACLE, By , , With 2 Comments

Once a standby database is created, it is not possible to change the backup retention policy on the fly. In this article, we will see how to change RMAN retention policy of a standby database. ======================================================================================================   There may be situation where you might need to change RMAN retention policy…

Upgrade Oracle Database 10205 to 11203 !!!

in this article we will see the steps to Upgrade Oracle Database 10205 to 11203 on Red Hat Enterprise Linux. ======================================================================================================   Follow the below steps to upgrade Oracle database 10205 to 11203 • Download and Install 11gR2 software We cannot upgrade the existing 10g Oracle Home, since 11gR2 is…

Upgrade Oracle Database 10201 to 10205 !!!

In this article, we will see the steps to upgrade Oracle database 10201 to 10205. ======================================================================================================   Follow the below steps to upgrade Oracle database 10201 to 10205 • Download and Unzip 10205 patch Download the patchset p8202632_10205_Linux-x86-64.zip from Oracle Metalink. We have a 64 bit RHEL 5.8 Server, hence…

Recovery Catalog Repository Configuration !!!

The RMAN repository data is always stored in the control file of the target database. But it can also, additionally, be stored in a separate database called a recovery catalog. A recovery catalog preserves backup information in a separate database, which is useful in the event of a lost control…

Graceful Switchover and Switchback activity in Dataguard !!!

In this article, we will see the steps of Graceful Switchover and Switchback activity in Dataguard. ======================================================================================================   • SWICTHOVER Activity – Check whether Primary and Standby databases are in sync or not On Primary database SQL> select name, open_mode, database_role from v$database; SQL> select thread#, max(sequence#) from v$archived_log where…

Rename RAC database using NID utility !!!

On September 23, 2015, Posted by , In ORACLE, By ,, , With 7 Comments

In this article, we will see the steps to rename RAC database using NID utility of Oracle. ======================================================================================================   We will be renaming an existing database emrepdb to rcatdb using the below steps. • Stop the RAC database $ srvctl stop database -d emrepdb   • Remove the database from…

Open Standby database in Read Write Mode and again Revert using Flashback !!!

On September 7, 2015, Posted by , In ORACLE, By , , With Comments Off on Open Standby database in Read Write Mode and again Revert using Flashback !!!

In this article, we will see the steps to open the Standby database in read write mode for any reporting or testing and then move it back to standby database using the flashback technology. Using a combination of Data Guard, restore points, and Flashback Database, a physical standby database can…

11gR2 Single Node RAC Configuration on Linux !!!

On March 2, 2015, Posted by , In 11g, By ,, , With No Comments

In this article, we will be doing 11gR2 Single Node RAC configuration on Linux. We will be using iSCSI disks for the Single Node RAC configuration. The prechecks for Single Node RAC configuration are similar to that required for a multi-node RAC configuration. For prechecks, you can refer this link….