How to add redo log file in oracle 11g

Notify me of new comments via email. Notify me of new posts via email. It may be in use for block recovery, and may or may not be archived. The redo log can be open or closed. It may be in use for media recovery, and may or may not be archived. Share this: Twitter Facebook. Like this: Like Loading Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:.

Email required Address never made public. Name required. Blog at WordPress. Follow Following. Ebenze's Weblog. For example, adding groups can solve availability problems. To create a new group of online redo log files use the following command:. In OMF the following statement creates redo log group and adds log members automatically No need to specify the filename in the path specified by the parameters explained in the Oracle documentation for OMF.

In this case, you can add new members to an existing group. The following statement adds a new redo log member to redo log group number Notice that filenames must be specified, but sizes need not be. The size of the new members is determined from the size of the existing members of the group. Skip Headers. When using Oracle Managed Files, the cleanup of operating systems files is done automatically for you. Consider the following restrictions and precautions before dropping individual redo log members:.

It is permissible to drop redo log files so that a multiplexed redo log becomes temporarily asymmetric. For example, if you use duplexed groups of redo log files, you can drop one member of one group, even though all other groups have two members each.

However, you should rectify this situation immediately so that all groups have at least two members, and thereby eliminate the single point of failure possible for the redo log. An instance always requires at least two valid groups of redo log files, regardless of the number of members in the groups.

If the member you want to drop is the last valid member of the group, you cannot drop the member until the other members become valid. A stale log file becomes valid again the next time its group is made the active group. You can drop a redo log member only if it is not part of an active or current group.