Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Placing database files - a beginner question
On Wed, 26 Nov 1997 13:05:56 -0800, Julio <julio.negueruela_at_si.unirioja.es> wrote:
>Chin Fang wrote:
>> However, now the /opt/oracle/dbs looks really messy:
>>
>> cntrlLN73.dbf log2WG73.dbf* sgadefLN73.dbf toolLN73.dbf*
>> cntrlWG73.dbf log2c sgadefWG73.dbf toolWG73.dbf*
>> init.ora log3LN73.dbf* sql.bsq ud1.dbf
>> initLN73.ora* log3WG73.dbf* systLN73.dbf* ud1.dbs
>> initWG73.ora* orapwLN73 systWG73.dbf* ud2.dbf
>> log1LN73.dbf* orapwWG73 tempLN73.dbf* usrLN73.dbf*
>> log1WG73.dbf* rbs2.dbf tempWG73.dbf* usrWG73.dbf*
>> log1c rbsLN73.dbf* tempdataLN73.dbf* usrdataLN73.dbf*
>> log2LN73.dbf* rbsWG73.dbf* tempdataWG73.dbf* usrdataWG73.dbf*
>>
>> I would much prefer to put all *WG73* in a subdirectory, say WG73, and
>> all *LN73* in another subdirectory, say LN73. However, checking all
>> documentations that I have access to (including these on line HTML
>> versions), I have not yet been able to find any descriptions about
>> such procedures.
>
>After creating the directories, you should a COPY of every datafile to
>the new location. Then:
>If you must move the system tablespace's datafiles then you must
>shutdown database and start it in no mount mode. If they are of another
>tablespace then you must put it offline (alter tablespace
><tablespace_name> offline;).
>Then, for each datafile you must do:
>alter tablespace <tablespace_name>
>rename datafile '<old_location>/<datafile_name>' to
>'<new_location>/<datafile_name';
>Afer renaming all datafiles of the tablespace, put it online and erase
>all datafiles.
>In case of system tablespace, just open it.
>
>Anyway I suggest for you to read anything about OFA arquithecture.
>
>
>Regards
What we've done is create an admin directory tree and put each instance under it. This is what oracle calls OFA (open flexible architecture). For us it looks like...
ORACLE_HOME=/u02/app/oracle/product.7.3.2.1 ORACLE_BASE=/u02/app/oracle
$ORACLE_HOME
dbs bin etc.... $ORACLE_BASE dba bin sql log admin QVCP (Instance 1's name) pfile Init.ora files bdump Background_dump_dest cdump core_dump_dest creat DB create scripts udump User_dump_dest reports QVCDW Instance 2's name (same subdirs for each instance) product (Oracle's product subdirs)
In the $ORACLE_HOME/dbs subdir, don't put copies of your password and initialization files. Put symbolic links to the files under $ORACLE_BASE/admin.
-- Chuck Hamilton chuckh_at_dvol.com Never share a foxhole with anyone braver than yourself!Received on Wed Nov 26 1997 - 00:00:00 CST