HP StorageWorks Storage Mirroring application notes - High availability for Oracle 10g (T2558-88088, April 2008)

Storage Mirroring High availability for Oracle 10g application notes 7
• File Name—This column lists each file name you need to select for replication. These files are
assigned names during your initial Oracle installation and configuration causing some of these files
to be unique to your environment. For example, if you used the default Oracle installation, your
instance parameter file will be init.ora and located in the
\oracle\admin\instance_name\pfile folder in the destination drive. If you supplied an
instance name of prod, your init.ora file will be located in the
\oracle\admin\prod\pfile folder by default. Files with unique names will be identified in
the table with a wildcard asterisk (*).
Additionally, some of the files are identified with a number sign (#) placeholder in the file name.
This placeholder identifies redundant files and/or multiple files which may exist because of
tablespace configurations. For example, you may have control01.dbf, control02.dbf,
undotbs01.dbf, and undotbs02.dbf.
• 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
init.ora.xxxxx Initialization Parameter
File
\oracle\product\10.1.0\admin\
instance_name\pfile
N/A
control#.ctl 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
undotbs*.dbf Undo Tablespace \oracle\oradata\instance_name V_$DATAFILE
sysaux*.dbf System Auxiliary
Tablespace
\oracle\oradata\instance_name V_$DATAFILE
users#.dbf Users Tablespace \oracle\oradata\instance_name V_$DATAFILE
example*.dbf Example Tablespace \oracle\oradata\instance_name V_$DATAFILE
temp*.dbf Temporary Tablespace \oracle\oradata\instance_name V_$DATAFILE
listener.ora Listener File \oracle\product\10.x.x\db_1\
network\admin
N/A
tnsnames.ora Service Configuration
File
\oracle\product\10.x.x\db_1\
network\admin
N/A
pwd*.ora Password Information
File
\oracle\product\10.x.x\db_1\
database
N/A
spfile*.ora Server Parameter File \oracle\product\10.x.x\db_1\
database\
N/A