When a datafile gets corrupted, you will have to restore/recover it. It should be possible at some point in time not to have the datafile for the tablespace during this operation. The concept is how it works. At some point in time, during the construction of the operational environment, this might not b ethe actual situation. That's why enforcing the concept is not useful.
Think of the creation of a tablespace: The tablespace needs to be entered in the DD, as well the datafile(s) description. The datafiles need to be created as well. This is not really a 'transaction', there is no redo for the work that the OS does on the filesystem.
Tempfiles will not be backed up, they are temporary. So, you can end up with a database without temp files, e.g. after a restore or the creation of a standby database.
HTH
Best regards,
Carel-Jan Engel
=== If you think education is expensive, try ignorance. (Derek Bok) ===
So after a restore, you end up with a temporary On Fri, 2005-07-01 at 12:38, Sinardy wrote:
> But why it allow the tablespace without datafile. > > The 10g Concept said: > > Databases, tablespaces, and datafiles are closely related, but they > have important differences: > > 1. An Oracle database consists of one or more logical storage > units called tablespaces, which collectively store all of the > database's data. > > 2. Each tablespace in an Oracle database consists of one or more > files called datafiles, which are physical structures that > conform to the operating system in which Oracle is running. > > 3. A database's data is collectively stored in the datafiles that > constitute each tablespace of the database. For example, the > simplest Oracle database would have one tablespace and one > datafile. Another database can have three tablespaces, each > consisting of two datafiles (for a total of six datafiles). > > > > My situation, seems like a bit different, don't you think so? Or > > Regards, > Sinardy > > -- -- Original Message -- -- > From: "Mladen Gogala" <gogala@(protected)> > To: <all_about_oracle@(protected)> > Cc: "Oracle-L" <oracle-l@(protected)> > Sent: Friday, July 01, 2005 6:30 PM > Subject: Re: Temp tbs with no temp file > > On 07/01/2005 06:15:19 AM, Sinardy wrote: > > > Why Oracle allow to have temporary tablespace without the temp file? > > Because tablespace is a logical and not a physical structure. > > > > > What should I do? > > > Add one. > > -- > Mladen Gogala > Oracle DBA
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN"> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8"> <META NAME="GENERATOR" CONTENT="GtkHTML/3.0.10"> </HEAD> <BODY> <FONT SIZE="3">Sinardy,<BR> </FONT><BR> When a datafile gets corrupted, you will have to restore/recover it. It should be possible at some point in time not to have the datafile for the tablespace during this operation. The concept is how it works. At some point in time, during the construction of the operational environment, this might not b ethe actual situation. That's why enforcing the concept is not useful.<BR> <BR> Think of the creation of a tablespace: The tablespace needs to be entered in the DD, as well the datafile(s) description. The datafiles need to be created as well. This is not really a 'transaction', there is no redo for the work that the OS does on the filesystem.<BR> <BR> <FONT SIZE="3">Tempfiles will not be backed up, they are temporary. </FONT>So, you can end up with a database without temp files, e.g. after a restore or the creation of a standby database. <BR> <BR> HTH<BR> <BR> <BR> <TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"> <TR> <TD> Best regards,<BR> <BR> Carel-Jan Engel<BR> <BR> ===<BR> If you think education is expensive, try ignorance. (Derek Bok)<BR> === </TD> </TR> </TABLE> <BR> <BR> <BR> So after a restore, you end up with a temporary <BR> On Fri, 2005-07-01 at 12:38, Sinardy wrote: <BLOCKQUOTE TYPE=CITE> <FONT COLOR="#737373" SIZE="2"><I>But why it allow the tablespace  ;without datafile.</FONT><BR> <FONT COLOR="#737373"> </FONT><BR> <FONT COLOR="#737373" SIZE="2">The 10g Concept said:</FONT><BR> <FONT COLOR="#737373"></FONT><BR> <FONT COLOR="#737373" SIZE="2">Databases, tablespaces, and datafiles are closely related, but they have important differences:</FONT><BR> <FONT COLOR="#737373"></FONT><BR> <UL> <LI TYPE=1 VALUE=1><FONT COLOR="#737373" SIZE="2">An Oracle database consists of one or more logical storage units called tablespaces, which collectively store all of the database's data.</FONT><BR> <FONT COLOR="#737373"></FONT><BR> <LI TYPE=1 VALUE=2><FONT COLOR="#ff0000" SIZE="2">Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running.</FONT><BR> <FONT COLOR="#737373"></FONT><BR> <LI TYPE=1 VALUE=3><FONT COLOR="#737373" SIZE="2">A database's data is collectively stored in the datafiles that constitute each tablespace of the database. For example, the simplest Oracle database would have one tablespace and one datafile. Another database can have three tablespaces, each consisting of two datafiles (for a total of six datafiles).</FONT><BR> <FONT COLOR="#737373"><BR> </UL> <BR> </FONT><BR> <FONT COLOR="#737373" SIZE="2">My situation, seems like a bit different, don't you think so? Or </FONT><BR> <FONT COLOR="#737373"> </FONT><BR> <FONT COLOR="#737373" SIZE="2">Regards,<BR> Sinardy</FONT><BR> <FONT COLOR="#737373"> </FONT><BR> <FONT COLOR="#737373" SIZE="2">-- -- Original Message -- -- <BR> From: "Mladen Gogala" <</FONT><A HREF="mailto:gogala@(protected) .net"><FONT SIZE="2"><U>gogala@(protected)</U></FONT></A><FONT COLOR="#737373" SIZE="2">><BR> To: <</FONT><A HREF="mailto:all_about_oracle@(protected)"><FONT SIZE="2"> <U>all_about_oracle@(protected)</U></FONT></A><FONT COLOR="#737373" SIZE="2">> <BR> Cc: "Oracle-L" <</FONT><A HREF="mailto:oracle-l@(protected)" ><FONT SIZE="2"><U>oracle-l@(protected)</U></FONT></A><FONT COLOR="#737373" SIZE="2">><BR> Sent: Friday, July 01, 2005 6:30 PM<BR> Subject: Re: Temp tbs with no temp file</FONT><BR> <FONT COLOR="#737373"></FONT><BR> <FONT COLOR="#737373" SIZE="2">On 07/01/2005 06:15:19 AM, Sinardy wrote:<BR> <BR> > Why Oracle allow to have temporary tablespace without the temp file? <BR> <BR> Because tablespace is a logical and not a physical structure.<BR> <BR> > <BR> > What should I do?<BR> <BR> <BR> Add one.<BR> <BR> -- <BR> Mladen Gogala<BR> Oracle DBA</I></FONT> </BLOCKQUOTE> <TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"> <TR> <TD> <BR> </TD> </TR> </TABLE>
