Database Administration (MOSC)

MOSC Banner

Redo Log Switching...

edited Nov 22, 2010 12:53AM in Database Administration (MOSC) 9 commentsAnswered
HI, Our Redo logs are size at 24G each due to the demands of overnight batch, at peak even these switch every 4 mins.

My concern is that in the online day the work load will be small and switching my not happen at all until a backup (RMAN arch) or batch starts again.

Should I be concerned that the Redo logs may not be archived for some hours...?

Were running a 2 Node primary cluster, Data Guarded for max availabilty. 

11.1.0.7 , CRS , ASM for an E-Biz 11 system on AIX

Some init's of interest

log_checkpoint_interval              integer     0
log_checkpoint_timeout               integer     1800
fast_start_mttr_target               integer     0

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