Locating the initialization parameter file, Locating redo log files – Oracle Audio Technologies ORACLE9I B10508-01 User Manual
Page 101
Starter Database Contents
Post-Installation
5-25
Locating the Initialization Parameter File
The database initialization parameter file (
init.ora
) is generated when a database
is created. The
init.ora
file is used to bring up the instance and to create the
database and the data dictionary. When the database is complete, the instance is
shutdown, and the
init.ora
file is saved to
ora_root:[dbs]init
. The logical, ORA_PARAMS, points to
ora_root:[dbs]init
.
The
init.ora
file is a text file that contains a list of preconfigured instance
configuration parameters and that must exist for an instance to start
.
No edits are
required to this file in order to use the starter database.
Locating Redo Log Files
The starter database and the custom database each contain three redo log files that
are located in the ora_root:[oradata.
describes the redo log files.
See Also:
Oracle9i Database Administrator’s Guide and Oracle9i
Database Reference for more information on database-specific
initialization parameters and their default values.
Table 5–3
Redo Log files
Redolog Files
Disk Size
Description
redo01.rdo
redo02.rdo
redo03.rdo
100 MB
100 MB
100 MB
Redo log files hold a record of all changes
that are made to data in the database
buffer cache. If an instance failure occurs,
then Oracle9i uses the redo log files to
recover the modified data in memory.
Oracle9i uses redo log files in a cyclical
fashion. For example, if three files
constitute the online redo log, then
Oracle9i fills the first file, then fills the
second file, and then fills the third file. In
the next cycle, it reuses and fills the first
file, the second file, and so on.
See Also:
Oracle9i Backup and Recovery Concepts for more
information on redo log files.