Databases Reference
In-Depth Information
Loss of a temporary datafile
Temporary tablespaces are never backed up. They are not considered as part of
a backup strategy. A temporary datafile can always be recreated if required. Its
information is not considered critical for database recovery purposes.
Starting 10g Rel. 2 at database open time Oracle automatically rebuilds the missing
temporary datafiles.
In the following scenario, the user used for demonstration purposes is
SYS
connected
as
SYSDBA
. The temporary datafile configuration is that of the default database
created with the DBCA assistant.
Originally, the datafile is physically located in the directory reported by the
V$TEMPFILE
dynamic view (
A
). A query explicitly requiring sort segments is issued
(
B
). In the middle of the sort operation from another OS session the temporary
datafile is physically removed and some errors are displayed on the screen letting the
user know that some temporary datafiles are missing (
C
).
Search WWH ::
Custom Search