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!

Data Guard Deletion Policy - Purge Log Files

da306939laJun 22 2017 — edited Jun 23 2017

Oracle 12102, Windows 2008 R2

hi everyone - am looking for sound advice on how to Purge Log Files (Shipped and Applied);

I have setup on Primary:

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;

Setup On Standby:

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

is there anything else I need to configure.

PURGE LOGS FROM FOLDERS:

we have FRA on and ARC logs - can someone explain the difference between the two, I have read on some blogs DO NOT USE 'FRA' if possible.

if 'FRA' is not a necessity I would like to disable (flashback_off) on Primary and Standby.

in 'FRA' folder we have logs - example

O1_MF_DNHV_87JK_.FLB

in ARCHLOGS folder we have - example

ARC0000140935_07682558280.0001

these logs are growing fast (each approx. 50gb) and I would like the purge the logs that are no longer necessary from both folders.

all advice and recommendations is greatly appreciated.

This post has been answered by mseberg on Jun 22 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2017
Added on Jun 22 2017
15 comments
1,118 views