Let us consider a scenario, where the application owner wants to perform read/write testing using production database. This is not possible in a real environment as you cannot play with production data. Oracle, provides a feature to use the standby database in read write mode, so that application users can perform tests, and then revert the standby to physical standby status.

This feature is possible in both Oracle 10g and Oracle 11g. Oracle 11g calls it a snapshot standby and can be performed directly. Oracle creates a Restore Point internally.

This article will demonstrate both Oracle 10g and Oracle 11g methods.

Read the rest of this entry »

Creating a physical standby database on Oracle 11gR2

This article is a simple example to setup a standby database in Oracle 11g. The standby database environment will be used in later articles for configuring dataguard broker and logical standby database creation

Read the rest of this entry »

This post is a demonstration of duplicating an Oracle database to another server over the network. The article is for the scenario where ALL directory structures are the same on both the source and the destination database.

Read the rest of this entry »

In this section, we will go through a demo of generating and detecting locks with scripts

Read the rest of this entry »