Study Q2: Good Place to Put Parameter Files, Data Files, Control Files, Log Files, Trace & Alert Files, Archive Log Files?

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 Received on Sat Sep 09 2000 - 21:46:24 CDT