Processing of loss of table space file in Oracle rollback segment

The database is starting up.

If you detect a data file that is missing or corrupted the rollback segment tablespace, and the database is running, do not drop it. In many cases, the database is open rather than closed to solve the problem.

Two possible solutions to this situation are:

A offline The missing data file and restores it from backup, which is true for databases that are archived.

B Another method is to offline the rollback segment of all the table spaces that the file belongs to, drop that tablespace, and then build them. You may have to kill the process that uses the rollback segment to make it offline.

Method II. A: Recover that data file from backup

This method only uses your library in an archived way.

1, offline (offline) that lost data file.

ALTER DATABASE DATAFILE OFFLINE;

Tip: For the current database transaction volume, you may need to build a temporary rollback table space and some temporary rollback segments for normal business operation.

2, restore the data file from the backup (Restore).

3. Execute the following order

SELECT V1.GROUP#, MEMBER, SEQUENCE#
FROM V$LOG V1, V$LOGFILE V2
WHERE V1.GROUP# = V2.GROUP# ;

This will list all the online redo logs and their serial number and first change numbers.

4, to use the online log and archive log to restore the file

RECOVER DATAFILE

5. Verify that all logs are restored, only to the information you receive "Media recovery complete".

6. Make this data file online

ALTER DATABASE DATAFILE ONLINE;

Method II. B: Rebuilding the rollback table space

This approach does not have to take into account whether the database is archive mode.