From: "Dino Hsu" <dino1@ms1.hinet.net>
Newsgroups: comp.databases.oracle.misc
Subject: Study Q2: Good Place to Put Parameter Files, Data Files, Control Files, Log Files, Trace & Alert Files, Archive Log Files?
Date: Sun, 10 Sep 2000 10:46:24 +0800
Lines: 15
Message-ID: <8peshc$cvdib$1@ID-41926.news.cis.dfn.de>
NNTP-Posting-Host: 210.65.39.40
X-Trace: fu-berlin.de 968553837 13612619 210.65.39.40 (16 [41926])
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600


Dear All,

The Starter Database has its parameter file, data files, control files and
log files in %ORACLE_HOME%\database, its trace & alert files in
%ORACLE_HOME%\trace and its archive log files in
%ORACLE_HOME%\database\archive. Some DBA will instead create for each
database a directory, say x:\mydb, and create sub-directories to store these
stuffs. What do you think is the appropriate way to do this? Do these files
have to be included in the file backup plan?

Thanks in advance.
Dino