OraFAQ Forum: Server Administration » How to recover 9i UNDO datafile damage?

Home » RDBMS Server » Server Administration » How to recover 9i UNDO datafile damage?

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

How to recover 9i UNDO datafile damage? [message #62573]

Thu, 29 July 2004 22:53

Tian Maohuai
Messages: 23
Registered: December 2003

Junior Member

My Oracle9.0.1,run on Win2k in NOARCHIVELOG mode.the rollback management is AUTO,but sometime the UNDO tablespace datafile is damaged.I can't startup any longer.How can I recover it and can startup database?

Report message to a moderator

Re: How to recover 9i UNDO datafile damage? [message #62591 is a reply to message #62573]

Mon, 02 August 2004 02:24

satyajit
Messages: 4
Registered: March 2001

Junior Member

do the following steps

1. sql> startup mount
2. sql>show parameter
there it will show undo_management = auto
make it manual using this command

3. sql> alter system set undo_management=manual scope=spfile;
4.sql> shutdown
5. sql > startup mount
6. sql> alter database drop datafile 'path of the undo datafile' offline drop;
7. sql>alter database open;
8. sql> create undo tablespace undodbts1
datafile ' path ' size <whatever u like >
autoextend on next 1m maxsize <your max size>;
9. sql> alter system set undo_mangement=auto scope=spfile;
10. sql> shutdown
11. sql>startup

this will solve your problem

Report message to a moderator

Re: How to recover 9i UNDO datafile damage? [message #62625 is a reply to message #62591]

Wed, 04 August 2004 02:25

Tian Maohuai
Messages: 23
Registered: December 2003

Junior Member

When I do as you said:
...
7. sql>alter database open;
...
the "ORA_01092:Oracle instance terminated.Disconnection forced" message is thrown out.
But why?,Please help me!

Report message to a moderator

Re: How to recover 9i UNDO datafile damage? [message #62628 is a reply to message #62625]

Wed, 04 August 2004 03:58

satyajit das
Messages: 12
Registered: August 2004

Junior Member

hi

i think u have done the followng steps:::

1.sql> startup mount
2. sql>show parameter
there it will show undo_management = auto
make it manual using this command

3. sql> alter system set undo_management=manual scope=spfile;
-- here i have given scope =spfile... i think u know what a spfile is ?????
4.sql> shutdown
5. sql > startup mount
--- here when u start the database in mount mode then the spfile file is read instead of pfile i,e init<sid>.ora
-- here do one thing check the parameter undo_management by the following command:-
sql> show parameter undo_
-- it should show undo_management=manual
after that do this steps it will work
6. sql> alter database drop datafile 'path of the undo datafile' offline drop;
7. sql>alter database open;
8. sql> create undo tablespace undodbts1
datafile ' path ' size
autoextend on next 1m maxsize ;
9. sql> alter system set undo_mangement=auto scope=spfile;
10. sql> shutdown
11. sql>startup

this will solve your problem

Report message to a moderator

Re: How to recover 9i UNDO datafile damage? [message #197006 is a reply to message #62628]

Mon, 09 October 2006 09:16

mrlagarto
Messages: 8
Registered: October 2006

Junior Member

Hi.
I´m having the same error
"ORA_01092:Oracle instance terminated.Disconnection forced"

I´m using INIT.ORA.
Set UNDO_MANAGEMENT=MANUAL;

But I still have the error above.
I dont´n know what to do.

I need some help.
Thanks

PD: I´m isong oracle 9

Report message to a moderator

Re: How to recover 9i UNDO datafile damage? [message #197043 is a reply to message #62573]

Mon, 09 October 2006 13:04

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Try this way
1. create new undo tbs.
2. set parameter undo_tablespace = new undo tbs
3. drop old undo tbs.
4. rename to new undo "name" to old undo tbs "name"
hope it will help u.

Report message to a moderator

Previous Topic:	How to see or what is query to see all parameter on Orcle DB
Next Topic:	ORA-06512 in AlertLog

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:38:18 CDT 2024