Database Backup and Recovery (MOSC)

MOSC Banner

Archived log files does not get deleted from Physical Standby Database, when we take backup on Prima

edited Jun 28, 2010 3:43AM in Database Backup and Recovery (MOSC) 6 commentsAnswered
Oracle Version: 11g  Environment: Oracle Data Guard
Primary Database: ORATST
Physical Standby Database: ORAPSD
Flashback Recovery Area Enabled on both databases
Primary Database RMAN configuration: 
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE
Physical Standby Database RMAN configuration: 
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY 

Also on both database init parameter _log_deletion_policy=’ALL is added in respective spfiles and both databases are restarted.

Data Guard is working in Maximum Available mode. Our observation is, both databases are in sync. And  Redo Transport as well as Apply Services are properly running. 

Primary database has its archived log files in its Flash Recovery Area. And Physical Standby database has received archived log files(received from Primary Database) in its Flash Recovery Area.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center