Managing RMAN Configuration using DBMS_BACKUP_RESTORE Package

In this blog article, I will illustrate the ability to change RMAN configuration through SQL using DBMS_BACKUP_RESTORE package. This package is not well known and is not documented.

 

Traditionally we use RMAN interface utility as shown:

rman target /

RMAN> show all;

rman1

Let us now explore changing RMAN configuration through the package:

SQL> VARIABLE rman_config NUMBER;

SQL> EXECUTE :rman_config := SYS.DBMS_BACKUP_RESTORE.SETCONFIG(‘BACKUP OPTIMIZATION’,’ON’);

rman2

Checking through the RMAN interface utility, we can see that the configuration change is reflected successfully:

rman3

 

What are the benefits?

This will help you with the provisioning and automation of your new databases to have identical RMAN configuration. Also, this will enable you to propagate RMAN configuration changes to all of your landscape.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s