My Oracle Support Banner

RECOVERING FROM A LOST DATAFILE IN A UNDO TABLESPACE (Doc ID 1013221.6)

Last updated on JUNE 07, 2023

Applies to:

Enterprise Manager for Oracle Database - Version 9.2.0.1 to 11.2.0.4
Information in this document applies to any platform.

Purpose

Problem Description: 
==================== 
 
This is a recovery scenario in which a datafile in a rollback segment 
tablespace has been lost or damaged to a point that Oracle cannot recognize it 
anymore. Trying to startup the database will result in ORA-1157, ORA-1110, and 
possibly an operating system level error such as ORA-7360. Trying to shut down 
the database in normal or immediate mode will result in ORA-1116, ORA-1110, 
and possibly an operating system level error such as ORA-7368.

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.