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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,685 views