How many is good - arch logs?
Recently i have created a database and went live. When i created the db from dbca, redo logs files were created as default 100mb. I further created members in the group.
I have set fast start mttr target as 1800, log checkpoint as zero and log checkpoint interval 1800.
When observing over a few weeks i could see that only one file getting created as archive log per day. The db is small and not much activities. In case if ineed to restore db then i may lose a days data as the current online log would not been archived.
Under the above circumstances:
> should i create a small size redo logs say 20mb and see more arch log files created.
> any other valid suggestions