Technology Stack - EBS (MOSC)

MOSC Banner

EBS R12.1.3 with 11.2.03 db : too many archive logs generated.

edited Nov 23, 2014 10:00AM in Technology Stack - EBS (MOSC) 1 commentAnswered

Hi ,

I posted this in Database thread and it was suggested to move this to EBS board.   I have an issue with archive log generation.   I have 3 online redolog group of 1GB each.  I expect the archive logs to be generated once every 15 or 30 mins.  However, at present there are too many archive log generated in a day.  The filesize are all over the place and it is getting difficult to manage.

Example

select to_char(first_time,'YYYY-MM-DD HH24:MI:SS'),(blocks*block_size)/(1024*1024) from v$archived_log

  where first_time >= sysdate-1

TO_CHAR(FIRST_TIME, (BLOCKS*BLOCK_SIZE)/(1024*1024)

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