Monthly Archives: September 2015

Home »  2015 »  September

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…