GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Purge Standby redo logs at Downstream

edited Oct 2, 2012 8:02AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
I am trying to Purge Standby redo logs at Downstream in 11.2.0.2 andwhen I run the following query to see what standby archive logs are purgeable I see none of them are purgeable, wondering when they will become purgable and why all of the registered logs are marked as not purgeable

COLUMN CONSUMER_NAME HEADING 'Capture|Process|Name' FORMAT A15
COLUMN NAME HEADING 'Archived Redo Log|File Name' FORMAT A25
COLUMN FIRST_SCN HEADING 'First SCN' FORMAT 99999999999
COLUMN NEXT_SCN HEADING 'Next SCN' FORMAT 99999999999
COLUMN PURGEABLE HEADING 'Purgeable?' FORMAT A10

SELECT r.CONSUMER_NAME,
r.NAME,
r.FIRST_SCN,
r.NEXT_SCN,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center