Home » RDBMS Server » Server Administration » Dropping redolog group (Oracle 9i / OS win2000 professinal)
Dropping redolog group [message #287685] Thu, 13 December 2007 03:09 Go to next message
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 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
You can drop it if it is inactive.
Re: Dorping redolog group [message #287696 is a reply to message #287685] Thu, 13 December 2007 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Dorping redolog group [message #287719 is a reply to message #287696] Thu, 13 December 2007 04:45 Go to previous messageGo to next message
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
Re: Dorping redolog group [message #287720 is a reply to message #287687] Thu, 13 December 2007 04:47 Go to previous messageGo to next message
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

Re: Dorping redolog group [message #287723 is a reply to message #287720] Thu, 13 December 2007 04:50 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Administrator's Guide
Chapter 6 Managing the Redo Log

Regards
Michel
Previous Topic: ORA-01157: ORA-01110:
Next Topic: Switching between Local and Automatic Segment Management
Goto Forum:
  


Current Time: Thu Dec 08 08:33:58 CST 2016

Total time taken to generate the page: 0.10919 seconds