Hot Backup with RMAN in Oracle

We are going to have look on the backup of Oracle, Which is common in DBA’s life. HOT Backup is the most common way to have a backup. Let’s have look on the steps of Oracle’s HOT Backup. Check the archive status

Create a test table

Check the datafile name and begin the backup […]

Read More

Cold Backup with Rman in Oracle

Today we are going to have look on Cold Backup. Being DBA we are aware of the importance of Backup in Oracle. Different kind of backup has a different kind of uses. Let’s have look on Cold Backup. Steps for Cold Backup

Today’s thought… “The only way to get ahead is […]

Read More

RMAN Recovery From Missing All Control File

Today we are going to have look on the steps which are used by “DBA” for RMAN Recovery From Missing All Control File.

Delete control files and start the database

Today’s thought The foundation stones for a balanced success are honesty, character, integrity, faith, love, and loyalty. Zig Ziglar Thank […]

Read More

RMAN Backup With Archivelog

This post is  about how to take RMAN Backup With Archivelog

Note: This will backup all archivelog file and delete those from a target location. If we physically delete some archivelog file before backup then we have to execute the following command before backup-

Some other Options:

Today’s thought Positive thinking […]

Read More

Catalog Database in RMAN

Purpose of Catalog Database A base recovery catalog is a database schema that contains RMAN metadata for a set of target databases. A virtual private catalog is a set of synonyms and views that enable user access to a subset of a base recovery catalog. Catalog Database can be two types Base recovery catalog Virtual […]

Read More

Basic of RMAN Backup and Recovery Scenario

Backup and recovery is a common task in DBA’s Daily Routine. Let’s have looked over the process to take backup of Oracle database and know about the process to recover the database. Check the archive log status

Create a dummy table for testing

Take a Backup

Insert more rows and Shutdown the […]

Read More

RMAN Time Based Recovery

RMAN is the most useful tool for Oracle in DBA’s life. Today’s post is about “RMAN Time Based Recovery”. Let’s have look on the steps. First, take the full backup.

Create a table

Now drop the table

start the database in mount state

set the NLS parameter and run the RMAN […]

Read More

Advantage Of RMAN in Oracle

This post is for those who are new in “Oracle RDBMS”, Being a part of Oracle technology in Database. “RMAN” plays an important part in “Backup&Recovery”. “RMAN” has its own benefits. Let’s have looked over the “RMAN” benefits.     RMAN helps to DBA have incremental where only modified data blocks will be copied It integrity checks for the […]

Read More

Benefits and Restrictions of RMAN in DataGuard

As we use RMAN to backup and restore the database in Simple scenarios. We can use it in Data Guard Environment same way. Oracle Dataguard Even we can use Physical Standby database backup to restore the Primary database and to recover the Primary database. But with some consideration as follow : The recovery catalog is […]

Read More

Create Physical Standby Database using RMAN Backup Restore

We have seen preparing Primary Database for Dataguard and creating Oracle network service on both sides. In this article, we will see Physical Standby database creation and configuration using RMAN backup and restore. Step 1: Connect to the Primary database and check if recovery area has enough space configured or not.

Step 2: Connect to […]

Read More