Blogs

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….

Prechecks for Oracle 11gR2 RAC installation on Linux !!!

On February 23, 2015, Posted by , In 11g, By ,, , With No Comments

In this article, we will be doing prechecks for Oracle 11gR2 RAC installation on Linux. ======================================================================================================   For this article, I have configured 2 systems containing RHEL 5.10 (64 bit) operating system. The Public and Private IPs have been already configured. Below are the details of IPs assigned, – RAC…

Prechecks for Oracle 11gR2 RAC installation on HP-UX !!!

On December 2, 2014, Posted by , In 11g, By ,, , With No Comments

In this article, we will be doing prechecks for Oracle 11gR2 RAC installation on HP-UX. ======================================================================================================   We will be configuring a two node Oracle RAC (11.2.0.4) on HP-UX Itanium Servers (B.11.31 – 64 bit). Below are the prechecks that need to be completed before proceeding with the installation of…