Rman full database backup script

rman full database backup script

In this article, we are going to learn how to create rman full database backup script step by step. RMAN (Recovery Manager) is a popular tool to create Oracle Database backups. Using RMAN we can create two types of backups listed below.

  • Full Database Backup
  • Incremental Database Backup

So, here we are going to learn about the rman full database backup script. 

Full Database Backup Script with RMAN

Login as an ORACLE user and set Oracle Database environment variables then connect with the RMAN utility using the below steps.

Oracle Database Environment Variables

xport ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1/
export PATH=/usr/sbin:$PATH

Connect with RMAN UTILITY

Using the below commands you can create rman full database backup.

$rman target/
RMAN>backup database;

The above command will create a full database backup on the default location, if you want to create a database backup on a different location you can use the below command.

RMAN>backup database format '/u01/RMAN_BACKUP/FULL_DATABASE_%U_DB.bkp';

Here is the output from the above query:

rman full database backup script

Full Database Backup plus Archivelog

You can create a database full backup plus archivelog also using rman utility, use below command:

RMAN>backup database plus archivelog;

Compress full database backup

If your target database size is big. so, we need too much disk space for the backup, but the RMAN utility gives us a compressed database backup facility. 

Using "compressed" in the RMAN script we can compress the full database very easily.

RMAN> backup as compressed backupset database;

Output from the above query:


Read: RMAN full Database Backup  Auto SCRIPT

Thanks for visiting, please visit again. If you are really happy with ocptechnology help, write your fillings in the comment box.

One thought on “Rman full database backup script

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to Top