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

If you have the ability to write to specific disks, place each copy of your control file and online redo on separate disks. If you are keeping multiple copies of archived logs, put those on separate disks. The specific paths aren't critical, but they should make some sort of common sense, and you should choose a scheme that you can use on as many of your servers as possible. Then you'll always be able to find the same information at the same location no matter which database you're looking at.

"Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message news:8peshc$cvdib$1_at_ID-41926.news.cis.dfn.de...
> 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 Sun Sep 10 2000 - 18:54:31 CDT