Database Backup and Recovery (MOSC)

MOSC Banner

RMAN is not deleting archivelogs on standby

edited Dec 15, 2016 4:00AM in Database Backup and Recovery (MOSC) 6 commentsAnswered
Hi Friends,
I have a stand alone 11.2.0.3 physical standby database.

Both the primary and standby are in sync. Both the primary and standby are using flash recovery area.

On PRIMARY:

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +FRAGRP
db_recovery_file_dest_size           big integer 8G


On STANDBY
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +FRAGRP
db_recovery_file_dest_size           big integer 8G


On Primary archivelog deletion policy is as follows:

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;


On Standby archivelog deletion policy is as follows:

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

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