[Oracle DataBase Server 12.1 installation on Windows 2008 Server]: Final Hot backup


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


$ Создаем файл с именем 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 syntax

rman CHECKSYNTAX @rmanscript.rman

Execute script

rman target / @rmanscript.rman

Look to the list of backups:

RMAN> rman target /


RMAN> list backup of database summary;


With next command i inform RMAN, what all backups except last it should mark as obsolete.

RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

Next command should remove all backups marked as obsolete without additional questions.

RMAN> delete noprompt obsolete;


RMAN> list backup of database summary;


RMAN>  quit