RMAN Configuration for Oracle

August 4, 2009
When you use rman utility, you can configure some parameters for rman environment.
1. login rman and connect the target database.
OS>rman target /
2. list all rman configurations
RMAN> SHOW ALL;
Note: These configurations are stored in the v$rman_configuration view within your target database's control file.
      You can find then like this:
SQL>select CONF#,NAME,VALUE from v$rman_configuration;

3. configure parameters for RMAN.
RMAN>CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
RMAN>CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2G;
RMAN>CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;
RMAN>CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET;
RMAN>CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT /tmp/%U;
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;

4. clear configurations for RMAN
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP OFF;
RMAN>CONFIGURE RETENTION POLICY CLEAR;
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;

5. Configure Tablespaces for Exclusion from Whole Database Backups
RMAN>CONFIGURE EXCLUDE FOR TABLESPACE ts_data1;
You can find these excluded tablespaces from v$tablespace view. You will find that the TEMPORARY tablespace and the TS_DATA1
tablespace are not included in database backkup.
SQL>SELECT * FROM V$TABLESPACE WHERE INCLUDED_IN_DATABASE_BACKUP<>'YES';

You can also find that the tablespaces which were set flashback off from v$tablespace.
SQL>SELECT * FROM V$TABLESPACE WHERE FLASHBACK_ON<>'YES';