Home » RDBMS Server » Server Administration » How to recover 9i UNDO datafile damage?
How to recover 9i UNDO datafile damage? [message #62573] Thu, 29 July 2004 22:53 Go to next message
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?
Re: How to recover 9i UNDO datafile damage? [message #62591 is a reply to message #62573] Mon, 02 August 2004 02:24 Go to previous messageGo to next message
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
Re: How to recover 9i UNDO datafile damage? [message #62625 is a reply to message #62591] Wed, 04 August 2004 02:25 Go to previous messageGo to next message
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!
Re: How to recover 9i UNDO datafile damage? [message #62628 is a reply to message #62625] Wed, 04 August 2004 03:58 Go to previous messageGo to next message
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
Re: How to recover 9i UNDO datafile damage? [message #197006 is a reply to message #62628] Mon, 09 October 2006 09:16 Go to previous messageGo to next message
mrlagarto
Messages: 8
Registered: October 2006
Junior Member
Hi.
I&acute;m having the same error
"ORA_01092:Oracle instance terminated.Disconnection forced"

I&acute;m using INIT.ORA.
Set UNDO_MANAGEMENT=MANUAL;

But I still have the error above.
I dont&acute;n know what to do.

I need some help.
Thanks

PD: I&acute;m isong oracle 9
Re: How to recover 9i UNDO datafile damage? [message #197043 is a reply to message #62573] Mon, 09 October 2006 13:04 Go to previous message
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.
Previous Topic: How to see or what is query to see all parameter on Orcle DB
Next Topic: ORA-06512 in AlertLog
Goto Forum:
  


Current Time: Thu Dec 05 16:03:46 CST 2024