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.
Conventional Wisdom (to which I don't subscribe) says to have your logs switch about every 30 minutes. However, most people have the opposite problem, switching too often. You dont need to switch more than once a day as long as your checkpoint interval is configured correctly, but I'm a big believer in getting it in the archived redo log.
Personally, I force my logs to switch every 15 minutes, but I run standby dbs.
WHAT? From where would you restore the current online redo?
My mistake in wording: "Restoring".. (I meant restoring in a general sense not to literally restore from tape or backup set) You wouldn't need or want to restore, just use a valid one or make sure that a valid online log from one of the members exists.