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
export PATH=$ORACLE_HOME/bin:$PATHConnect 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:
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”