appg_ofa.htm

Debian中文参考手册,系统介绍了Debian系统

</strong></font></th>
</tr>
</thead><tbody>
<tr align="left" valign="top">
<td id="r2c1" headers="r1c1" align="left" colspan="1" rowspan="1">Control files
</td>
<td headers="r2c1 r1c2" align="left" colspan="1" rowspan="1"><code>&#047;</code><em><code>pm</code></em><code>&#047;</code><em><code>q</code></em><code>&#047;</code><em><code>d</code></em><code>&#047;control.ctl</code>
</td>
</tr>
<tr align="left" valign="top">
<td id="r3c1" headers="r1c1" align="left" colspan="1" rowspan="1">Redo log files
</td>
<td headers="r3c1 r1c2" align="left" colspan="1" rowspan="1"><code>&#047;</code><em><code>pm</code></em><code>&#047;</code><em><code>q</code></em><code>&#047;</code><em><code>d</code></em><code>&#047;redo</code><em><code>n</code></em><code>.log</code>
</td>
</tr>
<tr align="left" valign="top">
<td id="r4c1" headers="r1c1" align="left" colspan="1" rowspan="1">Datafiles
</td>
<td headers="r4c1 r1c2" align="left" colspan="1" rowspan="1"><code>&#047;</code><em><code>pm</code></em><code>&#047;</code><em><code>q</code></em><code>&#047;</code><em><code>d</code></em><code>&#047;</code><em><code>tn</code></em><code>.dbf</code>
</td>
</tr></tbody>
</table>
<p>The following table describes this syntax:
</p>
<table title="File naming syntax." summary="This table describes the syntax in the preceding table." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0">
<thead>
<tr align="left" valign="top">
<th id="r1c1" align="left" colspan="1" rowspan="1" valign="bottom">
<font face="Arial, Helvetica, sans-serif">
<strong>Variable
</strong></font></th>
<th id="r1c2" align="left" colspan="1" rowspan="1" valign="bottom">
<font face="Arial, Helvetica, sans-serif">
<strong>Description
</strong></font></th>
</tr>
</thead><tbody>
<tr align="left" valign="top">
<td id="r2c1" headers="r1c1" align="left" colspan="1" rowspan="1"><em><code>pm </code></em>
</td>
<td headers="r2c1 r1c2" align="left" colspan="1" rowspan="1">A mount point name described previously in this chapter
</td>
</tr>
<tr align="left" valign="top">
<td id="r3c1" headers="r1c1" align="left" colspan="1" rowspan="1"><em><code>q</code></em>
</td>
<td headers="r3c1 r1c2" align="left" colspan="1" rowspan="1">A string distinguishing Oracle data from all other files (usually named ORACLE or oradata)
</td>
</tr>
<tr align="left" valign="top">
<td id="r4c1" headers="r1c1" align="left" colspan="1" rowspan="1"><em><code>d</code></em>
</td>
<td headers="r4c1 r1c2" align="left" colspan="1" rowspan="1">The value of the initialization parameter DB&#095;NAME (synonymous with the instance <em>sid</em> for single-instance databases)
</td>
</tr>
<tr align="left" valign="top">
<td id="r5c1" headers="r1c1" align="left" colspan="1" rowspan="1"><em><code>t</code></em>
</td>
<td headers="r5c1 r1c2" align="left" colspan="1" rowspan="1">An Oracle tablespace name
</td>
</tr>
<tr align="left" valign="top">
<td id="r6c1" headers="r1c1" align="left" colspan="1" rowspan="1"><em><code>n</code></em>
</td>
<td headers="r6c1 r1c2" align="left" colspan="1" rowspan="1">A two-digit string
</td>
</tr></tbody>
</table>
<div align="center">
<br /><table summary="This is a layout table to format a note" title="This is a layout table to format a note" dir="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"><tbody>
<tr>
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>Note:</strong>
</font>
</p>Do not store files other than control files, redo log files, or datafiles associated with database <em><code>d</code></em> in the path <code>&#047;</code><em><code>pm</code></em><code>&#047;</code><em><code>q</code></em><code>&#047;</code><em><code>d</code></em>.
</td>
</tr></tbody>
</table><br />
</div>
<p>Following this convention, you could produce, for example, a datafile with the name <code>&#047;u03&#047;oradata&#047;sab&#047;system01.dbf</code>, making it easy to see the database to which the file belongs.
</p>
</div class="sect2">
<div class="sect2">
<!--
infolevel=all
infotype=general
--><a id="sthref807" name="sthref807"></a>
<h3>
<font face="arial, helvetica, sans-serif" color="#330099">
Separate Segments With Different Requirements
</font>
</h3>
<p>Separate groups of segments with different lifespans, I&#047;O request demands, and backup frequencies across different tablespaces. 
</p>
<p><a href="#g641180">Table G-5</a> describes the special tablespaces that the Database Configuration Assistant creates for each Oracle database. If you manually create a database, you must create the required tablespaces. These tablespaces are in addition to those required for application segments.
</p>
<div align="center">
<br /><table summary="This is a layout table to format a tip" title="This is a layout table to format a tip" dir="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"><tbody>
<tr>
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>See Also:</strong>
</font>
</p><em>Oracle9i Database Administrator&#039;s Guide for information on creating tablespaces manually.</em>
</td>
</tr></tbody>
</table><br />
</div><a id="sthref808" name="sthref808"></a><a id="g641180" name="g641180"></a>
<p><strong><em><font face="arial, helvetica, sans-serif">Table G-5 Special Tablespaces 
</font></em></strong></p>
<table title="Special Tablespaces " summary="This table describes the special tablespaces that the Database Configuration Assistant (DBCA) creates for each Oracle database." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0">
<thead>
<tr align="left" valign="top">
<th id="r1c1" align="left" colspan="1" rowspan="1" valign="bottom">
<font face="Arial, Helvetica, sans-serif">
<strong>Tablespace
</strong></font></th>
<th id="r1c2" align="left" colspan="1" rowspan="1" valign="bottom">
<font face="Arial, Helvetica, sans-serif">
<strong>Required
</strong></font></th>
<th id="r1c3" align="left" colspan="1" rowspan="1" valign="bottom">
<font face="Arial, Helvetica, sans-serif">
<strong>Description
</strong></font></th>
</tr>
</thead><tbody>
<tr align="left" valign="top">
<td id="r2c1" headers="r1c1" align="left" colspan="1" rowspan="1">CWMLITE 
</td>
<td headers="r2c1 r1c2" align="left" colspan="1" rowspan="1">No
</td>
<td headers="r2c1 r1c3" align="left" colspan="1" rowspan="1">OLAP catalog metadata repository (CWMLite)
</td>
</tr>
<tr align="left" valign="top">
<td id="r3c1" headers="r1c1" align="left" colspan="1" rowspan="1">DEMO
</td>
<td headers="r3c1 r1c2" align="left" colspan="1" rowspan="1">No
</td>
<td headers="r3c1 r1c3" align="left" colspan="1" rowspan="1">Demo schema
</td>
</tr>
<tr align="left" valign="top">
<td id="r4c1" headers="r1c1" align="left" colspan="1" rowspan="1">DRSYS
</td>
<td headers="r4c1 r1c2" align="left" colspan="1" rowspan="1">No
</td>
<td headers="r4c1 r1c3" align="left" colspan="1" rowspan="1">Oracle Text segment
</td>
</tr>
<tr align="left" valign="top">
<td id="r5c1" headers="r1c1" align="left" colspan="1" rowspan="1">INDX
</td>
<td headers="r5c1 r1c2" align="left" colspan="1" rowspan="1">No
</td>
<td headers="r5c1 r1c3" align="left" colspan="1" rowspan="1">Index associated with data in the USERS tablespace
</td>
</tr>
<tr align="left" valign="top">
<td id="r6c1" headers="r1c1" align="left" colspan="1" rowspan="1">OEM&#095;REPOSITORY
</td>
<td headers="r6c1 r1c2" align="left" colspan="1" rowspan="1">No
</td>
<td headers="r6c1 r1c3" align="left" colspan="1" rowspan="1">Repository for Oracle Enterprise Manager
</td>
</tr>
<tr align="left" valign="top">
<td id="r7c1" headers="r1c1" align="left" colspan="1" rowspan="1">RBS
</td>
<td headers="r7c1 r1c2" align="left" colspan="1" rowspan="1">Yes
</td>
<td headers="r7c1 r1c3" align="left" colspan="1" rowspan="1">Rollback segments
</td>
</tr>
<tr align="left" valign="top">
<td id="r8c1" headers="r1c1" align="left" colspan="1" rowspan="1">SYSTEM
</td>
<td headers="r8c1 r1c2" align="left" colspan="1" rowspan="1">Yes
</td>
<td headers="r8c1 r1c3" align="left" colspan="1" rowspan="1">Data dictionary segments
</td>
</tr>
<tr align="left" valign="top">
<td id="r9c1" headers="r1c1" align="left" colspan="1" rowspan="1">TEMP
</td>
<td headers="r9c1 r1c2" align="left" colspan="1" rowspan="1">Yes
</td>
<td headers="r9c1 r1c3" align="left" colspan="1" rowspan="1">Temporary segments
</td>
</tr>
<tr align="left" valign="top">
<td id="r10c1" headers="r1c1" align="left" colspan="1" rowspan="1">USERS
</td>
<td headers="r10c1 r1c2" align="left" colspan="1" rowspan="1">No
</td>
<td headers="r10c1 r1c3" align="left" colspan="1" rowspan="1">Miscellaneous user segments
</td>
</tr>
<tr align="left" valign="top">
<td id="r11c1" headers="r1c1" align="left" colspan="1" rowspan="1">XDB
</td>
<td headers="r11c1 r1c2" align="left" colspan="1" rowspan="1">No
</td>
<td headers="r11c1 r1c3" align="left" colspan="1" rowspan="1">The XDB tablespace holds the data that is stored in the Oracle XML DB repository through SQL or through protocols such as HTTP and WebDAV.
</td>
</tr></tbody>
</table>
<p>Creating these special tablespaces is effective because data dictionary segments are never dropped, and no other segments that can be dropped are allowed in the<strong> </strong>SYSTEM tablespace. Doing this ensures that the SYSTEM tablespace does not require a rebuild due to tablespace free-space fragmentation. 
</p>
<p>Because rollback segments are not stored in tablespaces holding applications data, the administrator is not blocked from taking an application&#039;s tablespace offline for maintenance. The segments are partitioned physically by type, and the administrator can record and predict data growth rates without using complicated tools.
</p>
</div class="sect2">
<div class="sect2">
<!--
infolevel=all
infotype=general
--><a id="sthref809" name="sthref809"></a>
<h3>
<font face="arial, helvetica, sans-serif" color="#330099">
Naming Tablespaces
</font>
</h3>
<p>Name tablespaces descriptively using a maximum of eight characters. Although Oracle9<em>i</em> tablespace names can be 30 characters long, portable UNIX filenames are restricted to 14 characters. The recommended standard for a datafile basename is <em><code>tn</code></em><code>.dbf</code>, where <em><code>t</code></em> is a descriptive tablespace name and <em><code>n</code></em> is a two-digit string. Because the extension plus the two-digit string occupy a total of six characters, only eight characters remain for the tablespace name.
</p>
<p>Descriptive names enable the datafile to be associated with the tablespace that uses it. For example, the names GLD and GLX might be used for the tablespaces storing General Ledger data and indices, respectively. 
</p>
<div align="center">
<br /><table summary="This is a layout table to format a note" title="This is a layout table to format a note" dir="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"><tbody>
<tr>
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>Note:</strong>
</font>
</p>Do not embed reminders of the word "tablespace" in your tablespace names. Tablespaces are distinguishable by context, and names do not need to convey information on type.
</td>
</tr></tbody>
</table><br />
</div>
</div class="sect2">
<div class="sect2">
<!--
infolevel=all
infotype=general
--><a id="sthref810" name="sthref810"></a>
<h3>
<font face="arial, helvetica, sans-serif" color="#330099">
Exploiting the OFA Structure for Oracle Files
</font>
</h3>
<p> <a href="#g641220">Table G-6</a> describes the syntax used for identifying classes of files.
</p><a id="sthref811" name="sthref811"></a><a id="g641220" name="g641220"></a>
<p><strong><em><font face="arial, helvetica, sans-serif">Table G-6 Directory Structure Syntax for Identifying Classes of Files 
</font></em></strong></p>
<table title="Directory Structure Syntax for Identifying Classes of Files " summary="This table describes the syntax used for identifying classes of files." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0">
<thead>
<tr align="left" valign="top">
<th id="r1c1" align="left" colspan="1" rowspan="1" valign="bottom">
<font face="Arial, Helvetica, sans-serif">
<strong>Directory Structure Syntax
</strong></font></th>
<th id="r1c2" align="left" colspan="1" rowspan="1" valign="bottom">
<font face="Arial, Helvetica, sans-serif">
<strong>Description
</strong></font></th>
</tr>
</thead><tbody>
<tr align="left" valign="top">
<td id="r2c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u&#091;0-9&#093;&#091;0-9&#093;</code>
</td>
<td headers="r2c1 r1c2" align="left" colspan="1" rowspan="1">User data directories
</td>
</tr>
<tr align="left" valign="top">
<td id="r3c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;&#042;&#047;home&#047;&#042;</code>
</td>
<td headers="r3c1 r1c2" align="left" colspan="1" rowspan="1">User home directories
</td>
</tr>
<tr align="left" valign="top">
<td id="r4c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;&#042;&#047;app&#047;&#042;</code>
</td>
<td headers="r4c1 r1c2" align="left" colspan="1" rowspan="1">User application software directories
</td>
</tr>
<tr align="left" valign="top">