Re: Corrept Undo Tablespace and oracle internal problem

peter wrote:
> Thank you for your reponse.
> But I don't have any metalink user id.
> I am also facing current redo log file corrupt problem. According to
> books also we can issue one command through which we can remove this
> problem, which is :
>
> Alter database clear noarchive logfile group 4;
>
> But it is giving error so right now I am not able to remove this two
> problem.
> You are looking very senior with 5 yrs. of experience, I just have
> nearly 3 months of experience, please help me.
>
> Thank You
>
> DA Morgan wrote:

>> peter wrote:
>>> I know when my undo tablespace is corrupted then we can change undo
>>> tablespace to new undo tablespace but what are the problems we can
>>> face. Like what will happen with pending transactions.
>>> And could anyone please tell me which book or site can help me to
>>> explore database internally.
>> Having never seen a corrupt undo tablespace in what is it now ... 5
>> years ... I have no idea. But my first instinct, if I had this question,
>> would be to hit metalink.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damorgan_at_x.washington.edu
>> (replace x with u to respond)
>> Puget Sound Oracle Users Group
>> www.psoug.org

1. Please do not top post. Scroll to the bottom of a post to add your input.
2. It sounds to me like you and your organization desperately need to buy a support contract from Oracle. You are in a position where not having access is costing more than the admission ticket.
3. Report what Frank has asked. And also why, if you know, corruption may exist. You started off asking about UNDO and not you are talking about LOGS. What is the relationship? -- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org