Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: No Talk, Only Do

RE: No Talk, Only Do

From: Thomas Day <tday6_at_csc.com>
Date: Thu, 5 Aug 2004 15:47:25 -0400
Message-ID: <OFB6EA8AEC.5282E36C-ON85256EE7.006BD828@csc.com>

I have a development instance that the developers love to play around with (and mess up). I have put everything (control files, pfile, spfile, redo logs, tablespaces ...) under a single mount point. Stop the database and copy the mount point to a backup directory. When they need a restore they can stop the database and copy the backup directory back to their mount point. Simplicity.

When they foul their nest, they get to clean it.

The mount point is spread across multiple spindles via the system level striping. Moving the redo logs and the control files to separate mount points would not ensure that they were on separate spindles.

I'd spend more time making sure that they were if it was a production system. Since it has a limited number of users, disk I/O contention is not a huge issue.

I respect OFA if you're talking about physical devices. But if you're just moving files around on logical devices so that it looks OFA compliant you may be defeating your purpose.

                                                                                                                                       
                      "Gogala, Mladen"                                                                                                 
                      <Mladen.Gogala           To:      "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>                            
                      @aetn.com>               cc:                                                                                     
                      Sent by:                 Subject: RE: No Talk, Only Do                                                           
                      oracle-l-bounce                                                                                                  
                                                                                                                                       
                                                                                                                                       
                      08/05/2004 03:21                                                                                                 
                      PM                                                                                                               
                      Please respond                                                                                                   
                      to oracle-l                                                                                                      
                                                                                                                                       
                                                                                                                                       




Great topic! I have only one question: why do I have to have all those silly directories? I'd like to cram all software under /oramydatabasesoftware
and scatter the data across the filesystems named in such a way to deceive the
enemy. I'd also like to put all control files and all redo logs on the same disk. Can you, please, explain to me why would that be bad?

--
Mladen Gogala
Oracle DBA
email:mladeng_at_aetvn.com
Ext: 9787



> -----Original Message-----
> But the next idiot that asks me to modify a script to fit
> their inconsistently designed file system had better duck ...
>
> Thanks to everyone for listening ... I feel ever so much better. :)
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
Received on Thu Aug 05 2004 - 14:43:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US