HP StorageWorks Storage Mirroring application notes - High availability for Oracle 9i (T2558-88087, April 2008)

6
• File Description—This column gives a brief description of each file.
Default Location and Table to Query—The Default Location column identifies
the directory where a specific file is stored if you choose the default installation
directory. If you did not use the default directory and do not know the location of a
specific file, query the table identified in the Table to Query column to determine the
location. For detailed information on querying tables, see your Oracle reference guide.
If you do not know the location of files that are not associated with a table, locate those
files using the Windows Find feature
File Name File
Description
Default Location Table to Query
nit.ora Parameter
File
\oracle\admin\instance_name\pfi
le
N/A
control#.ct
l
Control File \oracle\oradata\instance_name V$CONTROLFILE
redo#.log Online
Redo Log
\oracle\oradata\instance_name V$LOGFILE
system*.dbf System
Tablespace
\oracle\oradata\instance_name V_$DATAFILE
indx#.dbf Index
Tablespace
\oracle\oradata\instance_name V_$DATAFILE
tools#.dbf Tools
Tablespace
oracle\oradata\instance_name V_$DATAFILE
undotbs#.db
f
Rollback
Tablespace
oracle\oradata\instance_name V_$DATAFILE
temp#.dbf Temporary
Tablespace
oracle\oradata\instance_name V_$DATAFILE
users#.dbf Data
Tablespace
\oracle\oradata\instance_name V_$DATAFILE
drsys#.dbf Text-relate
d Schema
Objects
\oracle\oradata\instance_name V_$DATAFILE
odm#.dbf ODM and
ODM_MTR
schema
objects
\oracle\oradata\instance_name V_$DATAFILE