[Oracle DataBase Server 12.2 Installation on Oracle Linux 7.4]: Final Backup (Hot Backup):


$ mkdir -p /u02/oracle/oradata/12.2/${ORACLE_SID}/scripts


$ cd /u02/oracle/oradata/12.2/${ORACLE_SID}/scripts


$ vi 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

Run the backup script

$ rman target / @rmanscript.rman


View the list of backups

RMAN> rman target /


RMAN> list backup of database summary;


With the following command, I specify that all backups except the last one should be marked as obsolete.

RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

Now I tell RMAN to delete obsolete backups (without confirmation).

RMAN> delete noprompt obsolete;


RMAN> list backup of database summary;

List of Backups
===============
Key     TY LV S Device Type Completion Time     #Pieces #Copies Compressed Tag
------- -- -- - ----------- ------------------- ------- ------- ---------- ---
1       B  F  A DISK        14/08/2017 14:31:28 1       1       NO         FULL_DATABASE_DATAFILES
8       B  F  A DISK        14/08/2017 15:15:39 1       1       YES        FULL_DATABASE


RMAN>  quit