Recovery Manager [RMAN] is a very powerful tool when it comes to Backup, Restore or recovering your database.

Today we will see Configuration of RMAN and how we can set them.

Let’s start from scratch.

1: Connecting to RMAN

To connect with rman we need to specify a target database name, username and password.

Or if we have set an environment variable for target database we can simply connect RMAN using following command it will be connected using OS credentials.

2. Let’s check the available configuration of RMAN using SHOW ALL command

3. We can see all available configuration in the above output.

Lets us start with retention policy.

Now, what is retention policy ??

It means till when or what number of backups we can keep.

We can set a retention policy by two methods :

1. Recovery Window : If we set it to 5 days till 5 days backup will be kept and after that backup will become obsolete . So if space pressure occurs in fast recovery area RMAN can delete those obsolete backups.

2.Retention Policy: Number of backups kept in the fast recovery area after that backup will become obsolete.

In the above output, we can see I have set retention policy to 5 redundancy. That means 5 full back-ups will be kept safe in the fast recovery area. After that first backup will become obsolete , so when we will take 6th backup if space pressure occurs in fast recovery area rman can delete the first backup.

4. In show, all output we have seen control file autobackup is off.

As we have set it on, every time backup is taken using RMAN, SPFILE and controlfile will be automatically backed up.

5.Clear RMAN configuration to default

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.