| Ora-01113 Very Urgent [message #54017] |
Thu, 24 October 2002 04:00  |
SureshB
Messages: 7
Registered: June 2002
|
Junior Member |
|
|
Hello,
When I try to startup my database I get:
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3: '/u06/oracle/oradata/crow/rbs01.dbf'
How can I clear this up?
Thanks
suresh.
|
|
|
|
|
|
| Re: Ora-01113 Very Urgent [message #54032 is a reply to message #54017] |
Thu, 24 October 2002 13:06  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Don't give up so easy.
Comment out ROLLBACK_SEGMENTS parameter in your init.ora file. Add _OFFLINE_ROLLBACK_SEGMENTS and restart your database.
You will be able to open the database. Then query DBA_ROLLBACK_SEGS to check that all non-system rollback segments are taken offline. Then drop and recreate them with:
DROP ROLLBACK SEGMENT rollback_segment_name;
Once you have done that, drop and recreate the rollback tablespace and the rollback segments.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
| Ora-01113 Very Urgent [message #55782 is a reply to message #54017] |
Sat, 15 February 2003 23:21 |
BIJU JOSEPH
Messages: 3
Registered: January 2002
|
Junior Member |
|
|
hello,
can somebody help me ?
when i try to startup my database i get the following error
ORA-01113 : FILE NEEDS MEDIA RECOVERY
ORA-01110 : DATAFILE E:ORANTDATABASEUSR1TECH.ORA
HOW CAN I START MY DATABASE
PLEASE HELP
REGARDS
BIJU
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
