fbpx
en English
ar Arabiczh-CN Chinese (Simplified)nl Dutchen Englishfr Frenchde Germanit Italianpt Portugueseru Russianes Spanish

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.

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

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

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

Connect with RMAN UITILITY

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 above query:

RMAN FULL DATABASE COMPRESS BACKUP

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

1 thought on “Rman full database backup script”

Leave a Comment