Skip to Main Content

Database Software

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 How to do a periodic full database backup to delete archivelogs

OlgaTogiApr 13 2020 — edited Apr 15 2020

Hello,

I am a newby in RMAN.

My DB is in the Archive Mode:

SQL> archive log list;

Database log mode        Archive Mode

Automatic archival        Enabled

Archive destination        USE_DB_RECOVERY_FILE_DEST

Archive logs are accumulated and I can not allow them to take all disc space.

Periodically I run:

backup archivelog until time 'sysdate-60' delete all input;

But backupsets are accumulated too. And the disc space of FRA is increasing.

Should I to do a periodic full database backup and delete all backupsets and archivelogs?

How to do this?

Or should I do something else?

Thanks,

Olga.

Comments
Post Details
Added on Apr 13 2020
9 comments
2,356 views