REDO LOG and ARCHIVE LOG size
Please take this as very theoretical question, there is no actual server in place yet ...
I have mid-size solaris 10 server with Oracle 10.2, the main tablespace (or better say few tablespaces) will have 3TB. This will be data warehouse server (smaller instance with maybe 20-30 users), and daily loads which will not exceed 50GB (50gb is really overstated number). There will be archive log with daily backups.
1. What is the rule of thumb as a decent size initial REDO and ARCHIVE LOG size? I know there is no way to give me exact number, I am talking high level ballpark here.
2. We will have 6 SAN filesystems attached to the server, would you recommend to use one for data, one for archive log and 2 for redo or would you rather use all 6 evenly for all data files (redo, archive, data, index, temp, ...).