Q
Problem solve Get help with specific problems with your technologies, process and projects.

Altering the control file to fix accidental rollback segment deletion

I goofed and deleted a public rollback segment file before the tablespace was dropped on a Unix system with Oracle 8i. It's to my understanding that I should be able to fix this by editing the control file so that it doesn't see the datafile anymore. When I log into service manager and try to shutdown immediate or normal, I get an error saying it's looking for that tablespace data file. Is there a way to shutdown so that I can complete the remainder commands that will allow me to alter the control file?

You could always restore this file from your database backup and then apply recovery to start your database. Otherwise, you'll have to perform these steps:

  1. Modify your parameter file to not contain the ROLLBACK_SEGMENTS parameter.
  2. Startup the instance in MOUNT mode.
  3. ALTER TABLESPACE rbs OFFLINE DROP;
  4. DROP TABLESPACE rbs;
  5. ALTER DATABASE OPEN;
  6. Create a new RBS tablespace and create new rollback segments.
  7. All the rollback segments in your parameter file.
  8. Restart the instance.

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close