Database Administration (MOSC)

MOSC Banner

Advice Sought on Sizing log_archive_dest_1 for ArchiveLogs for switching production DB to archive lo

edited Jan 17, 2014 11:27AM in Database Administration (MOSC) 2 commentsAnswered
Planning to switch database to ArchiveLog mode and am trying to gauge proper sizing for Archive Logs

Query of Redo Log Space below returned a maximum of 400 GB of redo generated a day when some tables are loaded with NOLOGGING option. 

Daily Count and Size of Redo Log Space (Single Instance)
SQL> SELECT A.*,
Round(A.Count#*B.AVG#/1024/1024/1024) Daily_Avg_GB
FROM
(
SELECT
To_Char(First_Time,'YYYY-MM-DD') DAY,
Count(1) Count#,
Min(RECID) Min#,
Max(RECID) Max#
FROM
v$log_history
GROUP
BY To_Char(First_Time,'YYYY-MM-DD')
ORDER
BY 1 DESC
) A,
(
SELECT
Avg(BYTES) AVG#,
Count(1) Count#,
Max(BYTES) Max_Bytes,

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