Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN Backup archivelogs

792290Sep 11 2020 — edited Sep 11 2020

Hello,

scheduled an RMAN script to delete the archive logs from log mount point which are sysdate -14.  here are the commands, but it's not deleting after it backs up the logs from the disk.  it runs once a week using cronjob.

set echo on

run {

       crosscheck backup;

       crosscheck archivelog all;

        report obsolete;

        delete expired backup;

        delete expired archivelog all;

        delete obsolete;

        crosscheck archivelog all;

       backup as compressed backupset format '/mnt/data/bkarc/%d_archbkp_%T_%s_%p' archivelog  until time 'sysdate-14' delete input;

    }

list backup summary;

crosscheck backup;

any help is appreciated.

Thank you.

Comments
Post Details
Added on Sep 11 2020
12 comments
1,771 views