- What are the main considerations when estimating database size of an Oracle database? Are there any rules of thumb?
- How to estimate the size and number of datafiles, redo log files, control files and archived redo log files?
The number of control files should be three for most Oracle databases. Typically, you will want three to five online redo log groups (with two members each) for your database. However, if you see "checkpoint not complete" messages in your alert log, then you may want to add more groups.
The datafiles depend on your tablespaces and how much data each tablespace needs to hold. If your tablespace will be small, then you will only require one datafile for the tablespace. If the tablespace will be large, then you may require more datafiles.
For more information:
How to find Oracle database instance size