[Installing Oracle Database 12c Release 1 on Microsoft Windows 2008 Server]: Final Backup (Hot Backup)


CMD>
CMD> e:
CMD> md  E:\app\oracle\oradata\ora121\scripts
CMD> cd E:\app\oracle\oradata\ora121\scripts


$ Create a file named rmanscript.rman


RUN {
	CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;
	BACKUP FULL DATABASE TAG "FULL_DATABASE" PLUS ARCHIVELOG TAG "FULL_DATABASE_ARCHIVELOGS";
	BACKUP CURRENT CONTROLFILE TAG "FULL_DATABASE_CONTROLFILE";
	BACKUP SPFILE TAG "FULL_DATABASE_SPFILE";
}

Check the syntax of the created script file

rman CHECKSYNTAX @rmanscript.rman

Execute the backup script

rman target / @rmanscript.rman

View the list of backups:

RMAN> rman target /


RMAN> list backup of database summary;


The following command tells RMAN to mark all backups except the last one as obsolete.

RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

Now ask RMAN to delete obsolete backups (without confirmation).

RMAN> delete noprompt obsolete;


RMAN> list backup of database summary;


RMAN>  quit