RMAN Full Backup Script

Though, creating RMAN Full backup script is pretty simple, I would like to share my script and how to create it over here.

Firstly, Invoke RMAN. Then, connect to your Recovery Catalog and Target Database.

You can create a RMAN Full Backup Script by running the following:

create script prod_full_bkp{
CROSSCHECK BACKUP;
CROSSCHECK
ARCHIVELOG ALL;
Sql 'alter system archive log current’;
BACKUP DATABASE;
BACKUP ARCHIVELOG ALL DELETE INPUT;
REPORT UNRECOVERABLE;
REPORT
OBSOLETE ORPHAN;
}

The script will be stored in the Recovery Catalog. Here, obsolete will reflect obsolete backups as per the retention policy configured for the target database. Delete Input will delete the archivelogs after they have been backed up.

You can either manually run or schedule a job to run using the following script:

spool log to '\prod_full_bkp.log';
run {execute script prod_full_bkp;}
list backup summary;
spool log off;