Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Safely dropping a Redo log group

CastellNov 2 2013 — edited Nov 2 2013

Version: 11.2.0.3 on RHEL 6.2

We have a production Database which is in ARCHIVELOG mode.For a redo log resizing activity, we want to drop some Online redo logs. So,after we add the new log groups with bigger size, we will drop the smaller log groups. I was planning to drop the INACTIVE redo log group.

But, according to the below documentation redo log groups with the status INACTIVE or ACTIVE may or may not be archived. So, how can I safely drop an INACTIVE redo log group ?

http://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_2029.htm

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 30 2013
Added on Nov 2 2013
4 comments
598 views