Estimating Archivelog size
790498Dec 15 2010 — edited Dec 15 2010##PLEASE REPLY TO IT As IT IS URGENT##
We have a database of approx 2 TB in size of version 10.2.0.4 - 64 bit production. It is a RAC configuration with 2 nodes running. There is no DR database for it yet. ASM is used for storage. Currently it is in NO ARCHIVELOG mode and there is NO backup policy yet defined.
We need to put this database in archive log mode and apply a backup policy for it. Our query is how much space it will take to store one day archive files.
Secondly we are planning to have RMAN level 0 backup weekly and incremental backup then after every day, so we would like to estimate the size for level 0 backup sets.
NOTE: It is an OLTP database and daily approx 20 GB data is inserted into it.
Please find below the details
================================
SQL> select sum(bytes/1024/1024/1024) from dba_data_files;
SUM(BYTES/1024/1024/1024)
-------------------------
4571.1201
SQL> select sum(bytes/1024/1024/1024) from dba_segments;
SUM(BYTES/1024/1024/1024)
-------------------------
1967.59375
SQL> select group#,SEQUENCE#,bytes,members,status from v$log;
GROUP# SEQUENCE# BYTES MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
1 794357 52428800 1 ACTIVE
2 794358 52428800 1 CURRENT
3 905485 52428800 1 CURRENT
4 905484 52428800 1 ACTIVE
=====================================================