Category Archives: ORACLE

Home »  ORACLE

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

Converting SE RAC Database to EE RAC Database !!!

On October 5, 2013, Posted by , In ORACLE, By ,, , With 2 Comments

In this article I will show you the steps of converting SE RAC database to EE RAC database. You are using a Standard Edition (SE) database and want to convert it to the Enterprise Edition (EE) because functionality you require is not part of the SE. Since the same “SQL.BSQ”…

Restore as single instance DB and convert to RAC DB !!!

On February 26, 2013, Posted by , In ORACLE, By , , With No Comments

For this article, we have taken a RMAN backup of an existing 10g RAC database. There is another 10g RAC cluster on which we will restore this backup. We will restore RMAN backup as single Instance database and then convert it to RAC database by adding instances to the cluster configuration. Similarly, you…

Upgrade 10gR2 RAC to 11gR2 RAC on RHEL Server !!!

In this article we will see how to upgrade Oracle Clusterware, ASM and Database from 10gR2 [10.2.0.5] RAC to 11gR2 [11.2.0.3] RAC. The current 10gR2 RAC database configuration is as below, • OS: RHEL 5.8 • Oracle User: oracle • Grid User: grid • Oracle Home: /u01/app/oracle/products/10.2.0/db • Grid Home:…

Recover Standby Database Using RMAN Incremental Backup !!!

In this article, we will show the steps that can be used to resolve problems if a physical standby database has lost or corrupted archived redo data or has an unresolvable archive log files gap. ======================================================================================================   Below are the steps to perform a Rolling forward for standby database using…