RMAN configuration – an introduction

There are numerous configurations that can be instrumental in extracting the best out of RMAN. Though RMAN is extremely flexible, the default configuration options available also fare very well in many cases.

There are two ways to list the configuration settings possible for RMAN: from the view V$RMAN_CONFIGURATION, or by executing the command SHOW ALL from the RMAN client. All the configuration settings, either default or modified, are stored in the target database's control file.

Using the V$RMAN_CONFIGURATION view

This can be one of the simplest ways to gather information about the configuration settings for RMAN. This view lists the persistent configuration settings made by the command CONFIGURE (which will be discussed later in the chapter). In other words, this view lists the non-default settings for RMAN. The following code is the output of this view:

SQL> SELECT * FROM V$rman_configuration;

  CONF# NAME                       VALUE           ...