Clear standby log files

Check Primary Redo Thread Number and size. Check Standby Thread number and Size for Standby redo logs. As you see standby is unassigned status means it is not used by standby database. Stop the data-guard recovery process in Standby database: -- for standby db which is under recovery, recovery needs to be stopped first alter database recover managed standby database cancel;. In this example we configure 6 standby redo files. Start the Recovery of the dataguard in oracle.

PL Deploying a New Forms. As a certified and experienced Oracle Database Administrator with Almost 12 Years of Experience I am able to perform all levels of database maintenance and am fully qualified to do Oracle updates as well. I have developed exceptional analytical skills that allow me to diagnose and take care of issues immediately. Extremely skilled in planning and execution of special projects in time- critical environments.

Extensive knowledge in directing, coordinating and exercising concern authority for planning, organization, control and successful completions. Very skilled at solving customer relations issues by seeking first to understand and then to be understood. Effectively able to communicate with customers, vendors and management. Previous adgentns. What if we want to set threshold for archive logs deletion which are already applied on standby DB?

Thank you so much for sharing this well written article with all - very objectively presented indeed! God Bless! Deleting Archive Log files in a Data Guard environment. Back to overview. System altered. You have following choices to free up space from recovery area :.

If you are using Data Guard,. Back up files to tertiary device such as tape using RMAN. If an operating. Starting backup at 06 - NOV - Finished backup at 06 - NOV - RMAN - : warning : archived log not deleted, not yet applied by standby.

Deleted 1 objects. Tweet Share Share. Comments 7 erptree Oracle 07 June om Pierre 06 February om Mayank 12 June om Bastiaan 12 June om Prabhu 07 August om Shashi 17 September om Sumeet 28 December om