Database Backup and Recovery (MOSC)

MOSC Banner

Perfomance issues on primary database during backp for DR database

edited Aug 28, 2013 2:48PM in Database Backup and Recovery (MOSC) 6 commentsAnswered
Hi All,

Primary Rac 4 node

AIX 6.1 64 bit

oracle 11.2.0.1

-----

DR single instance database

oracle 11.2.0.1

AIX 6.1 64

using Dataguard broker running in Maximum Availability.

service="NBMSP_DR.com", LGWR SYNC AFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_unique_name="NBMSP_DR" net_timeout=30, valid_for=(all_logfiles,primary_role)

 

for the period of 2 hours we are seeing a lot of wait on commit on the primary database while backup is running on DR.

already know there is a issue with the number of redolog groups on DR as they should be more than the ones in Primary. (however this is not the cause as we had this issue before we added redogroups to primary)

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