OraFAQ Forum: Server Administration » Dropping redolog group

Home » RDBMS Server » Server Administration » Dropping redolog group (Oracle 9i / OS win2000 professinal)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dropping redolog group [message #287685]

Thu, 13 December 2007 03:09

Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA

Member

Dear All,
Please tell me, that can I drop corrupted redolog group when Database is open , on production ddatabase, If yes , then HW. and wt r the limitation of this operation.

Thanks
Vivek Kumar

[RENAMED by LF: the old title was 'Dorping redolog group']

[Updated on: Thu, 13 December 2007 04:54] by Moderator

Report message to a moderator

Re: Dorping redolog group [message #287687 is a reply to message #287685]

Thu, 13 December 2007 03:21

varu123
Messages: 754
Registered: October 2007

Senior Member

You can drop it if it is inactive.

Report message to a moderator

Re: Dorping redolog group [message #287696 is a reply to message #287685]

Thu, 13 December 2007 03:36

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As I told you in private message: read and follow OraFAQ Forum Guide, especially section about IM speak.
What does mean "HW", "wt", "r"?

Regards
Michel

Report message to a moderator

Re: Dorping redolog group [message #287719 is a reply to message #287696]

Thu, 13 December 2007 04:45

Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA

Member

Dear sir,
What does mean "HW", "wt", "r"?
I mean , if it can be dropped , What are the steps to drop it? and what would be the limitation doing this oeration

Thanks
Vivek

Report message to a moderator

Re: Dorping redolog group [message #287720 is a reply to message #287687]

Thu, 13 December 2007 04:47

Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA

Member

Dear sir,
it can be dropped , What are the steps to drop it? and what would be the limitation doing this operation. If database is not open? Please give steps.........

Thanks
vivek

Report message to a moderator

Re: Dorping redolog group [message #287723 is a reply to message #287720]

Thu, 13 December 2007 04:50

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Database Administrator's Guide
Chapter 6 Managing the Redo Log

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-01157: ORA-01110:
Next Topic:	Switching between Local and Automatic Segment Management

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 05:43:35 CST 2024