Rollback segment datafile deleted
Somebody deleted the rollback segment datafile from the server. The database cannot be started again. We get "ORA-01545 rollback segment 'RBS01' specified not available." Sometimes, it will throw a ORA-00600 error.
- Somebody deleted the rollback segment datafile from the server.
- The database cannot be started again.
- startup mount
- alter database datafile 'rbs01.dbf' offline drop;
- alter database open;
- ORA-01545 rollback segment 'RBS01' specified not available.
- Sometimes, it will throw a ORA-00600 error.
The following is what I did, but it failed:
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
- startup nomount
- alter database backup controlfile to trace;
- re-create controlfile
- recover database;
- alter database open;
- ORA-00600: internal error code, arguments: [25012],[1],[2],[],[],[],[],[]
-
select * from v$tablespace; TS# NAME 0 SYSTEM 2 TEMP .....
-
select file#,name from v$datafile; FILE# NAME 1 system.dbf 3 temp01.dbf
I think the database has been dropped RBS tablespace, what can I do?
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments