About Introduction To Oracle RMAN

 RMAN (Recovery Manager)

There are two ways of performing backup and recovery.

1. Where user does all the hard work. User takes the backup by manually copying and pasting all the necessary files and directories. For this a user can either use OS commands or use the limited number of SQL commands that come with the Database.
2. Another type of backup is where user uses some utility to perform the backup and recovery. In that case this utility or tool does all the work. It is definitely less time consuming and very effective.

The first type of backup where user has to do all the hard work is known as “User Managed Backup-Recovery (UMR)”. Whereas the second type of backup where a specifically designed software performs all the work is known as “Server Managed Backup-Recovery (SMR)”.

1.What is RMAN?

RMAN stands for Recovery Manager. As the name suggests RMAN is a stand-alone utility for managing the backup and recovery of your Oracle Database. It’s a very powerful tool which comes with Oracle Database software.

the core functionality of RMAN is to manage the backup and recovery with minimum user intervention.thus we can say that it’s a “Server-Managed Backup & Recovery” utility for Oracle Database.

RMAN is a command line interpreter. You give some commands to this interpreter, it takes those commands and sends them to the target database by turning those commands as RPCs (Remote Procedure calls). These RPCs get executed at the database.

2.Does RMAN itself needs special privileges?

Yes, to perform all the backup and recovery related tasks Oracle Recovery Manager needs access to internal backup and recovery packages which are built into the Oracle kernel. Since these packages are built into the kernel of the database thus they are available even when the database is closed.

3.How to Install RMAN?

RMAN comes as a feature of your Oracle Database Server. That means it is installed with the installation of your Oracle Database.

4.Can any user of the database use the RMAN?

Since RMAN is a client thus you need some privileges to connect with your database using RMAN.

Before 12c there were only two privileges that you could use to run the RMAN utility. They were –

1. SysDBA, The most obvious option and
2. SYSOPER

But with Oracle Database 12c Oracle added another privilege which was designed for recovery and backup related tasks. It was –

3. SYSBACKUP

we can say that any database user who has either of these privileges can perform backup and recovery operations using either Oracle Recovery Manager also known as RMAN or SQL*Plus command line utility.