Databases Reference
In-Depth Information
Note that the
CREATE DATABASE
statement used in this step deviates slightly from the OFA standard in terms
of the directory structure. I prefer not to place the Oracle data files, online redo logs, and control files under
ORACLE_BASE
(as specified by the OFA standard). I instead directly place files under directories named
/<mount_point>/<file_type>/<database_name>
, because the path names are much shorter. The shorter path names
make command line navigation to directories easier, and the names fit more cleanly in the output of SQL
SELECT
statements. Figure
2-1
displays this deviation from the OFA standard.
/
root directory
/u01
app
oracle
product
12.1.0
db_1
bin
/u02
dbfile
dbname1
system01.dbf, temp01.dbf, data01.dbf
/u03
dbfile
dbname1
sysaux01.dbf, undo01.dbf, index01.dbf, control01.ctl
/u04
dbfile
dbname1
data02.dbf, temp02.dbf, users01.dbf, control02.ctl
/u05
dbfile
dbname1
index02.dbf, undo02.dbf, control03.ctl
/u06
oraredo
dbname1
redo01a.rdo, redo02a.rdo, redo03a.rdo
/u07
oraredo
dbname1
redo01b.rdo, redo02b.rdo, redo03b.rdo
/u08
oraarch
dbname1
log archive_dest_1, log_archive_format <dbname1>_%t_%s_%r.arc
/u09
oradump
dbname1
rman
backup piece
datapump
data pump backups
/u10
fra
backupset
YYYY_MM_DD
backup piece
autobackup
YYYY_MM_DD
backup piece
If using FRA
db _recovery_file_dest
(init parameter)
dbname1
datafile
image copy
onlinelog
online redo log
controlfile
archivelog
control file
oraInst.loc
oratab
oraset
/etc
YYYY_MM_DD
archive redo log
flashback
flashback log
installation media
orainst
12.1.0
/home
oracle
database
runInstaller
bin
sql
Figure 2-1.
A slight deviation from the OFA standard for laying out database files
It's not my intention to have you use nonstandard OFA structures. Rather, do what makes sense for your
environment and requirements. Apply reasonable standards that foster manageability, maintainability, and
scalability.
Step 5. Create a Data Dictionary
After your database is successfully created, you can instantiate the data dictionary by running two scripts. These
scripts are created when you install the Oracle binaries. You must run these scripts as the
SYS
schema:
SQL> show user
USER is "SYS"
