Step by Step Creation of Cascading Standby

Cascading Standby Database works in two layers. As per normal the standby configuration, standby database receives redo from the primary database. In Layer 2 standby database will receive redo from another standby database rather than directly from the primary database. With Cascading standby database we can minimize the load of Primary Database. As per Oracle […]

Read More

Using the RMAN Recovery Catalog in a Data Guard Configuration

Recover Catalog: A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. Benefits and Restrictions of RMAN in DataGuard In easy words, RMAN metadata is stored in a different database instead of the control file. That database works as a repository. Recovery catalog and data guard : Use of the RMAN recovery […]

Read More

Benefits of Using Data Guard Broker

Oracle Data Guard Broker automates configuration and monitoring tasks for data guard. Data Guard Broker Architecture With Oracle Data Guard Broker we can enable FAST_START FAILOVER which helps in case of crash scenario or inoperativeness of production, it directs Primary Database role to standby database in this scenarios. It provides simplified switchover and failover operations. […]

Read More

Read Alert log from x$dbgalertext in Oracle

This post is small in content but most useful for all DBAs. We are going to have look at the most important part of Oracle RDBMS. Being Oracle DBA we all are well known about alert logs but few of us experts know how to read it. We re being a part of IT basic thing taught […]

Read More

Shrink Lob segment in Oracle

Today we are going to have look on “Shrink Lob segment”. Before we start the article we must know about the heading. What does it stands every one must know. Shrinking Segments: Overview Shrinking a sparsely populated segment improves the performance of scan and DML operations on that segment. It resolves mainly two issues:- • Full table scans […]

Read More

How to add Datafile in Oracle

Today we are going to learn about modifications of Tablespace. In production Database, we do update tablespace on daily basis. Being a DBA it must be on our key tips. Right decision on correct time is more fruitful. Being DBA our brain must be active about database health on daily basis we must do a modification […]

Read More

How to Flush Single SQL Plan out of Shared Pool in Oracle

Todays let ‘s have look at the query which we use to resolve this issue ” How to Flush Single SQL Plan out of Shared Pool”.      Find the address and the hash value

Execute the purge procedure

Thank you for giving your valuable time to read the above information. If you […]

Read More

Check Materialized View Refresh Schedule in Oracle

This post is about the view which we use in Oracle. What is  Materialized View? The view which we use to make a replica of a target master from a single point in a time is known materialized view. As we know why do we need materialized view in Oracle? redesign the system and eliminate those […]

Read More

Startup Procedure in Oracle

We are going to have look at the most basic but most important part of Database. It is the first step of Database. We can call it initial stage of Database. Let’s have look at this image. It indicates some hidden simple and most meaningful message. Ladders are to meant to climb only it shows we […]

Read More

Progress status of index rebuild in Oracle

  The game never ends after the creation of anything. It starts when it comes to the phase of maintenance. Today we are going to have look on the query which is used to look “Progress status of index rebuild/creation or long operation”.      Let’s have look on the query.

v$session_longops will show […]

Read More