How to configure Oracle Database RMAN backup with Examples

This post describe with real time example how to configure oracle database rman backup. This article first describe how to change oracle logging mode No Archive to Archive mode and briefly describe about rman parameters. Finally show rman backup configuration with an example. 

Step 1: Connect to Target database as sysdba

Step 2: Ensure the database has been configured with ARCHIVELOG mode or not?

Step 3: If the database has been configured with ARCHIVELOG mode then skip the Step number 3 to 6, If not then Shutdown the database.

Step 4: Startup the database in mount state.

Step 5: Configure database in ARCHIVELOG mode.

Step 6: Alter database to open state.

     

     Verify the changes are done

Step 7: Ensure ARCHIVELOG destination

Note: In case you wish to change default archive log destination then issue the following command.

SQL> alter system set log_archive_dest_1='location=/home/oracle/arch' scope=both;

Now log destination check

SQL> archive log list

Step 8: Ensure the flash/fast recovery area location

Step 9: Connect to RMAN on target

Step 10: View Current RMAN Configuration

Step 11: Change Few RMAN Configuration Parameters

i.                 Location: One of the important configuration parameters to set will be, where you want to save the RMAN backup. We are setting RMAN location is '/u01/backup/rman/' where save the RMAN backup

ii.                   Retention Period: We are setting the retention period as 7 days, which will keep the DB backup for a week

Note: Verify that the above two changes are done.

Note: Clear a Parameter: If you want to clear a parameter and set its value to default, use CLEAR at the end of the configuration as shown below.

RMAN> CONFIGURE RETENTION POLICY CLEAR;

Step 12: Backup Oracle Database

Note: Make sure the directory mentioned in the CHANNEK DEVICE TYPE DISK FORMAT is created. i.e /u01/backup/rman/

i.                     Database full backup without Archive logs

ii.                   Full database backup with Archive logs

iii.                 specific tablespace backup

iv.                  Full database backup through multiple channel

 Step 13: View all RMAN Backups

    RMAN> LIST BACKUP SUMMARY;

Note: when the RMAN backup is running, if you want to see the proress, you can query the V$RMAN_STATUS table from sql*plus as shown below.

SQL> SELECT OPERATION, STATUS, MBYTES_PROCESSED, START_TIME, END_TIME from V$RMAN_STATUS;

Thanking You!