Author Archives: TJ

Home »  Author: TJ

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…

Restore DB using RMAN and then change DB name using NID !!!

In this article, we will restore DB using RMAN and then change DB name using NID utility. Here we will be restoring database “orcldb” on a new server and then will change the DB name to “homedbs”. ======================================================================================================   • Copy init.ora file to $ORACLE_HOME/dbs dir and make appropriate changes…

Manually Create Database in Oracle !!!

In this article I will show you the steps to manually create Database in Oracle. We will use the CREATE DATABASE sql statement for this. After the database is created, we have to manually build the views on the data dictionary tables and install PL/SQL packages using scripts. ======================================================================================================  …

Configure NFS Disks using NetApp Ontap Simulator !!!

In this post we will only see the steps to configure NFS disks using NetApp Ontap Simulator 8.2. We will be using the 7-mode for this article. For this article I have already configured a NetApp Filer with extra disks If you want to configure the NetApp Ontap Simulator from…